/*以下是连接数据库提取出的类*/
package com.beiruan.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConnectionUtil {
//连接数据库的四个参数
private static String jdbcDriver="com.mysql.jdbc.Driver";
private static String jdbcURL="jdbc:mysql://localhost:3306/jdbctest";
private static String jdbcUser="root";
private static String jdbcPassword="1234";
public static Connection getConnetion() {
Connection conn=null;
try {
Class.forName(jdbcDriver);//可以control+1引出try-catch
//获取连接
conn=DriverManager.getConnection(jdbcURL, jdbcUser, jdbcPassword);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeAll(Statement st,Connection conn) {
if(st!=null )
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(conn!=null)
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
System.out.println(DBConnectionUtil.getConnetion());
}
}
package com.beiruan.dao;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import com.beiruan.entity.User;
import com.beiruan.util.DBConnectionUtil;
public class UserDao {
public boolean deleteUserByUserId(int userid) {
boolean flag=false;
// TODO Auto-generated method stub
Connection conn=null;
PreparedStatement ps=null;
//加载驱动
try {
//获取连接
conn=DBConnectionUtil.getConnetion();
System.out.println(conn);
//创建执行sql语句的对象
String sql="delete from user where userid= ?";
ps=conn.prepareStatement(sql);
//给占位符赋值
ps.setInt(1, userid);
//执行
int rows=ps.executeUpdate();
if(rows>0)
flag=true;
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接数据库失败!");
}finally {
//有父类的位置可以放子类
DBConnectionUtil.closeAll(ps, conn);
}
return flag;
}
public boolean saveUser(User user) {
boolean flag=false;
// TODO Auto-generated method stub
Connection conn=null;
Statement st=null;
//加载驱动
try {
//获取连接
conn=DBConnectionUtil.getConnetion();
//创建执行sql语句的对象
st=conn.createStatement();
String sql="insert into user(username,password)values("+
"'"+user.getUsername()+"',"+"'"+user.getPassword()+"'"+")";
System.out.println(sql);
int rows=st.executeUpdate(sql);
if(rows>0)
flag=true;
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接数据库失败!");
}finally {
DBConnectionUtil.closeAll(st, conn);
}
return flag;
}
public boolean updateUserByUserId(int userid,String password) {
boolean flag=false;
Connection conn=null;
Statement st=null;
//加载驱动
try {
//获取连接
conn=DBConnectionUtil.getConnetion();
System.out.println(conn);
//创建执行sql语句的对象
st=conn.createStatement();
String sql="update user set password='"+password+"' where userid="+userid;
int rows=st.executeUpdate(sql);
if(rows>0)
flag=true;
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接数据库失败!");
}finally {
DBConnectionUtil.closeAll(st, conn);
}
return flag;
}
}
package com.beiruan.test;
import com.beiruan.dao.UserDao;
import com.beiruan.entity.User;
public class Test3 {
public static void main(String[] args) {
// TODO Auto-generated method stub
UserDao userdao=new UserDao();
User user=new User();
user.setUsername("liyun");
user.setPassword("12345");
boolean flag=userdao.saveUser(user);
System.out.println(flag);
}
}