java web mysql可视工具_20160406javaweb JDBC 实例工具类

packagecom.dzq.jdbc;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.Statement;importorg.junit.Test;importcom.dzq.util.JDBCUtils;public classJDBCDemo2 {/*** 该类中方法均以JUnit测试的形式给出*/@Testpublic voiddelete(){

Connection conn=null;

Statement stat=null;

ResultSet rs=null;try{//2.获取连接

conn=JDBCUtils.getConn();//3.获取传输器对象

stat=conn.createStatement();

stat.executeUpdate("delete from user where name='zhaoliu'");

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.close(rs, stat, conn);

}

}

@Testpublic voidfind(){

Connection conn=null;

Statement stat=null;

ResultSet rs=null;try{//2.获取连接

conn=JDBCUtils.getConn();//3.获取传输器对象

stat=conn.createStatement();

rs=stat.executeQuery("select * from user where name='zhaoliu'");while(rs.next()){

String name=rs.getString("name");

String password=rs.getString("password");

String email=rs.getString("email");

System.out.println("name:"+name+"pwd:"+password+"email:"+email);

}

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.close(rs, stat, conn);

}

}

@Testpublic voidupdate(){

Connection conn=null;

Statement stat=null;try{//2.获取连接

conn=JDBCUtils.getConn();//3.获取传输器对象

stat=conn.createStatement();

stat.executeUpdate("update user set password=999 where name='zhangsan'");

}catch(Exception e) {

e.printStackTrace();

}finally{

JDBCUtils.close(null, stat, conn);

}

}

@Testpublic voidadd(){

Connection conn=null;

Statement stat=null;//1.注册数据库驱动

try{//2.获取连接

conn=JDBCUtils.getConn();//3.获取传输器对象

stat=conn.createStatement();//4.执行sql语句

int count=stat.executeUpdate("insert into user values (null,'zhangsan','123456','zhaoliu@qq.com','1999-09-09')");//5.处理结果

if(count>0){

System.out.println("添加数据成功,影响行数为"+count);

}else{

System.out.println("执行失败");

}

}catch(Exception e){

e.printStackTrace();

}finally{//6.关闭资源

JDBCUtils.close(null, stat, conn);

}

}

}