jdbcdemo.java~8~

来自「java access 数据库 访问操作 odbc」· JAVA~8~ 代码 · 共 31 行

package day8;
import java.sql.*;
public class JDBCDemo {
    public static void main(String[] args) {
        DBAccess dba=new DBAccess();
        ResultSet rs=null;
        ResultSetMetaData rsmd=null;
        try {
            rs=dba.query("select * from users");
            rsmd=rs.getMetaData();
            int cols=rsmd.getColumnCount();
            for (int i = 1; i <= cols; i++) {
                System.out.println(""+
                                   rsmd.getColumnName(i));
            }
            System.out.println("-----------------");
            while(rs.next())
            {
                for (int i = 1; i <= cols; i++) {
                    System.out.print(""+rs.getString(i)+"\t");
                }
                System.out.println();
            }
        } catch (Exception ex) {
            System.out.println("ex:"+ex.getMessage());
        } finally {
            dba.close();
        }
    }
}