JDBC

定义 驱动类 驱动 数据库名 数据库密码 常量;

private static final CLASS="----驱动类----"; 

private static final DRIVER="---驱动---";

private static final USERNAME="------";

private static final PWD="----";

 

private Connection conn;

private PreparedStatement pre;

private ResultSet rs;

 

Class.forName(CLASS);加载驱动

conn=DriverManager.getConnection(CRIVER,USERNAME,PWD);创建连接

 

String sql="select * from bbc where xxx=?";

pre=conn.prepareStatement(sql);

pre.setObject(1,"acb");//设置 ? .

//查询

rs=pre.executeQuery();//执行SQL语句

 

//增 删 改

pre.executeUpdate();