mysql c3p0连接池优化_JDBC之c3p0连接池及其代码优化

packagecom.my.work;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;public classUserEnter{//用户登录

public static voiduserenter(String username,String password){

Connection conn=null;

PreparedStatement pre=null;

ResultSet rs=null;try{//通过工具类获取连接

conn=JDBCUtils.getConnection();//先写SQL语句

String sql="select * from enter where username= ? and password= ?";//执行SQL语句

pre=conn.prepareStatement(sql);//对查询信息进行赋值

pre.setString(1,username);

pre.setString(2,password);//显示结果

rs=pre.executeQuery();if(rs.next()){

System.out.println("登陆成功");

}else{

System.out.println("登陆失败");

}

}catch(Exception e){

e.printStackTrace();

}finally{//释放资源

JDBCUtils.release(rs,pre,conn);

}

}//注册新用户

public static void userenrol(intsno,String username,String password){

Connection conn=null;

PreparedStatement pre=null;try{

conn=JDBCUtils.getConnection();

String sql="insert into enter value(?,?,?)";

pre=conn.prepareStatement(sql);

pre.setString(1, String.valueOf(sno));

pre.setString(2,username);

pre.setString(3,password);int num=pre.executeUpdate();if (num>0){

System.out.println("注册成功");

}else{

System.out.println("注册失败");

}

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.release(pre,conn);

}

}//用户信息修改

public static void useralter(intsno,String username,String password){

Connection conn=null;

PreparedStatement pre=null;try{

conn=JDBCUtils.getConnection();

String sql="update enter set username=?,password=? where sno=?";

pre=conn.prepareStatement(sql);

pre.setString(1,username);

pre.setString(2,password);

pre.setString(3, String.valueOf(sno));int num=pre.executeUpdate();if (num>0){

System.out.println("修改成功");

}else{

System.out.println("修改失败");

}

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.release(pre,conn);

}

}//删除用户

public static void userdrop(intsno){

Connection conn=null;

PreparedStatement pre=null;try{

conn=JDBCUtils.getConnection();

String sql="delete from enter where sno=?";

pre=conn.prepareStatement(sql);

pre.setString(1, String.valueOf(sno));int num=pre.executeUpdate();if (num>0){

System.out.println("删除成功");

}else{

System.out.println("删除失败");

}

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.release(pre,conn);

}

}//查询所有用户信息

public static voiduserallshow(){

Connection conn=null;

PreparedStatement pre=null;

ResultSet rs=null;try{

conn=JDBCUtils.getConnection();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.release(rs,pre,conn);

}

}//查询指定用户信息

public static voidusershow(String username){

Connection conn=null;

PreparedStatement pre=null;

ResultSet rs=null;try{

conn=JDBCUtils.getConnection();

String sql="select * from enter where username=?";

pre=conn.prepareStatement(sql);

pre.setString(1,username);

rs=pre.executeQuery();while(rs.next()){

System.out.println(rs.getString("sno")+" "+rs.getString("username")+" "+rs.getString("password"));

}

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtils.release(rs,pre,conn);

}

}

}