</pre><pre code_snippet_id="1702563" snippet_file_name="blog_20160531_2_9692751" name="code" class="java">//数据库操作
package com.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import com.Student;
import utils.JdbcUtils;
public class UserDao {
//
public boolean IsExist(String name){
Connection con = null;
PreparedStatement pst=null;
ResultSet rs=null;
try {
con = JdbcUtils.getConnection();
String sql="select * from stu where username=?";
pst = con.prepareStatement(sql);
pst.setString(1, name);
rs=pst.executeQuery();
if(rs.next()){
return true;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JdbcUtils.release(rs, pst, con);
}
return false;
}
///
public boolean isExist(String username,String password){
Connection con = null;
Statement st = null;
ResultSet rs=null;
try {
con = JdbcUtils.getConnection();
st = con.createStatement();
String sql="select * from stu where username='"+username+"' and password='"+password+"'";
rs = st.executeQuery(sql);
if(rs.next()){
return true;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JdbcUtils.release(rs, st, con);
}
return false;
}
public void saveUser(Student stu){
Connection con = null;
PreparedStatement pst=null;
ResultSet rs=null;
try {
con = JdbcUtils.getConnection();
String sql="insert into stu(username,password,sex,phone,address)values(?,?,?,?,?)";
pst = con.prepareStatement(sql);
pst.setString(1,stu.getUsername());
pst.setString(2, stu.getPassword());
pst.setString(3, stu.getSex());
pst.setString(4, stu.getPhone());
pst.setString(5, stu.getAddress());
pst.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JdbcUtils.release(rs, pst, con);
}
}
}
jdbc模版
最新推荐文章于 2021-10-17 15:49:43 发布