在Java编程中，Java如何使用列的不同方法对列数进行计数，获取列名称，获取列类型等？假定数据库名称是：testdb，其中有两张表:employee和dept，employee表中有4条记录,dept表中有2条记录。
创建数据库表的语句 -
use testdb;
-- 员工表
drop table if exists employees;
create table if not exists employees (
id int not null primary key,
age int not null,
name varchar(64),
dept_id int(10)
);
INSERT INTO employees VALUES (100, 28, 'MaxSu', 1);
INSERT INTO employees VALUES (101, 25, 'WeiWang', 2);
INSERT INTO employees VALUES (102, 30, 'KidaSu', 2);
INSERT INTO employees VALUES (103, 28, 'KobeBryant', 1);
----
-- 部门表
drop table if exists dept;
create table if not exists dept (
id int not null primary key,
name varchar (64)
);
INSERT INTO dept VALUES (1, '技术部');
INSERT INTO dept VALUES (2, '市场部');
以下示例使用getColumnCount()，getColumnName()，getColumnTypeName()，getColumnDisplaySize()方法来获取列的列号，列的名称或列的类型。
package com.yiibai;
import java.sql.*;
public class UseColumnMethods {
public static void main(String[] args) throws Exception {
String JDBC_DRIVER = "com.mysql.jdbc.Driver";
String DB_URL = "jdbc:mysql://localhost/testdb?useSSL=false";
String User = "root";
String Passwd = "123456";
Connection con = null;
Statement stmt = null;
try {
Class.forName(JDBC_DRIVER);
} catch (ClassNotFoundException e) {
System.out.println("Class not found " + e);
}
try {
con = DriverManager.getConnection(DB_URL, User, Passwd);
stmt = con.createStatement();
String query = "select * from employees order by name";
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
System.out.println("no of columns in the table = " + rsmd.getColumnCount());
System.out.println("Name of the first column " + rsmd.getColumnName(1));
System.out.println("Type of the second column " + rsmd.getColumnTypeName(2));
System.out.println("No of characters in 3rd column " + rsmd.getColumnDisplaySize(2));
} catch (
SQLException e) {
System.out.println("SQL exception occured" + e);
}
}
}
上述代码示例将产生以下结果。
no of columns in the table = 4
Name of the first column id
Type of the second column INT
No of characters in 3rd column 11
注：如果JDBC驱动程序安装不正确，将获得
ClassNotfound异常。
Class not found java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
JDBC Class found
SQL exception occuredjava.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/testdb
