jdbcdemo.java~10~

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

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

//        String sql="update users set uname='wanger' "+
//                   "where uid=6";
//        try {
//            int n=dba.update(sql);
//            if(n>0)
//                System.out.println("update success!");
//            else if(n==0)
//                System.out.println("update fail");
//            else
//                System.out.println("exception throw");
//        } catch (Exception ex) {
//
//        }
    }
}