JDBC自学入门基础.doc

《JDBC自学入门基础.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、packagegz.itcast.c_prepared;importgz.itcast.util.JdbcUtil;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importorg.junit.Test;/★★*PreparedStatement執行sql語句*@authorAPPIe*/publicclassDemol{★增加*/@Testpublicvoidtestlnsert(){Connectionc

2、onn=null;PreparedStatementstmt=null;try{//1.获取连接conn=JdbclItil.getConnection();〃2•准备预编译的sqlStringsql="INSERTINTOstudent(NAME,gender)VALUES©,?)”；//?表示一个参数的占位符〃3.执行预编译sql语句(检查语法)stmt=conn.prepareStatement(sql);〃4.设置参数值*参数一：参数位置从1开始*/stmt.setString(1,H李四”);stmt.setStrin

3、g(2,”男”)；〃5.发送参数，执行sqlintcount=stmt.executeUpdate();System.out.println(*影响了”+count+”彳亍')；}catch(Exceptione){e.printStackTrace();thrownewRuntimeException(e);}finally{JdbcUtil.close(conn,stmt);}}★修改*/@TestpublicvoidtestUpdate(){Connectionconn=null;PreparedStatementstmt

4、=null;try{//1•获取连接conn=JdbcUtil.getConnection();〃2准备预编译的sqlStringsql="UPDATEstudentSETNAME=?WHEREid=?”；//?表示一个参数的占位符〃3.执行预编译sql语句(检查语法)stmt=conn.prepareStatement(sql);〃4.设置参数值*参数一：参数位置从1开始*/stmt.setString(1,”王五”)；stmt.setlnt(2,9);〃5.发送参数,执行sqlintcount=stmt.executeUpd

5、ate();System.out.printlnC'影响了“+count+”行”);}catch(Exceptione){e.printStackTrace();thrownewRuntimeException(e);}finally{JdbcUtil.close(conn,stmt);}}★删除*/@TestpublicvoidtestDelete(){Connectionconn=null;PreparedStatementstmt=null;try{//1•获取连接conn=JdbcUtil.getConnection()

6、;〃2.准备预编译的sqlStringsql="DELETEFROMstudentWHEREid=?”；//?表示个参数的占位符〃3.执行预编译sql语句(检查语法)stmt=conn.prepareStatement(sql);〃4.设置参数值*参数一：参数位置从1开始*/stmt.setlnt(1,9);〃5.发送参数，执行sqlintcount=stmt.executeUpdate();System.out.println('影响了”+count+”行”);}catch(Exceptione){e.printStackTr

7、ace();thrownewRuntimeException(e);}finally{JdbcUtil.close(conn,stmt);}}/★**查询*/@TestpublicvoidtestQuery(){Connectionconn=null;PreparedStatementstmt=null;ResultSetrs=null;try{//1•获取连接conn=JdbcUtil.getConnection();〃2.准备预编译的sqlStringsql="SELECT*FROMstudent11;〃3预编译stmt=c

8、onn.prepareStatement(sql);〃4执行sqlrs=stmt.executeQuery();〃5遍历rswhile(rs.next()){intid=rs.getlnt(”id”)；Stringname=rs.getString(”name”