MySQL数据的链接、增加与查找的封装
public class UtilConn {
public static Connection getConn(){
Connection conn=null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
String url="jdbc:mysql://localhost:3306/mydb1?characterEnconding=utf8";
conn=DriverManager.getConnection(url,"root","123456");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static int getReg(String name,String pwd){
int count=0;
Connection conn=getConn();
PreparedStatement ps=null;
if(conn!=null){
try {
String sql="insert into user(name,pass)values(?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pwd);
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(ps!=null){
try {
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
return count;
}
public static User getLogin(String name,String pass){
User user=null;
Connection conn=getConn();
PreparedStatement ps=null;
ResultSet rs=null;
if(conn!=null){
String sql="select id,name,pass from user where name=? and pass=?";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pass);
rs = ps.executeQuery();
if(rs.next()){
String password = rs.getString("pass");
String username=rs.getString("name");
int id=rs.getInt("id");
user=new User(username,password,id);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(rs!=null || ps!=null){
try {
rs.close();
ps.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
return user;
}
}
public class UtilConn {
public static Connection getConn(){
Connection conn=null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
String url="jdbc:mysql://localhost:3306/mydb1?characterEnconding=utf8";
conn=DriverManager.getConnection(url,"root","123456");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static int getReg(String name,String pwd){
int count=0;
Connection conn=getConn();
PreparedStatement ps=null;
if(conn!=null){
try {
String sql="insert into user(name,pass)values(?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pwd);
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(ps!=null){
try {
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
return count;
}
public static User getLogin(String name,String pass){
User user=null;
Connection conn=getConn();
PreparedStatement ps=null;
ResultSet rs=null;
if(conn!=null){
String sql="select id,name,pass from user where name=? and pass=?";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pass);
rs = ps.executeQuery();
if(rs.next()){
String password = rs.getString("pass");
String username=rs.getString("name");
int id=rs.getInt("id");
user=new User(username,password,id);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(rs!=null || ps!=null){
try {
rs.close();
ps.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
return user;
}
}