jdbcdemo.java

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

        }
    }
}