jdbcdemo.java~6~

java access 数据库 访问操作 odbc

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.getColumnClassName(i));
            }
            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();
        }
    }
}