jdbcdemo.java~7~

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

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();
            for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                System.out.println(""+
                                   rsmd.getColumnName(i));
            }
            System.out.println("-----------------");
            while(rs.next())
            {
                System.out.println(
                        "uid:"+rs.getString(1)+
                        "\tuname:"+rs.getString(2));
            }
        } catch (Exception ex) {
            System.out.println("ex:"+ex.getMessage());
        } finally {
            dba.close();
        }
    }
}