jdbc数据库连接操作(原始/封装)
一、原始方法
(1)Navicat连接数据库
①启动数据库
②连接数据库
(2)添加数据库驱动jar包
(3)数据库连接代码
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接对象
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useSSL=false","root","123456");
//定义sql语句
String sql = "update user set name = '啦啦啦' where id =2";
//获取执行sql的对象
Statement stmt = conn.createStatement();
//执行sql,并接收返回结果
int count = stmt.executeUpdate(sql);
//处理结果
System.out.println(count);
//释放资源
stmt.close();
conn.close();
二、封装方法
(1)同上
(2)同上
(3)JDBCUtils数据库连接工具类
将数据库连接的相关操作封装成一个类,然后通过调用这个类的方法来实现数据库的连接操作
import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;
public class JDBCUtils {
private static String url;
private static String user;
private static String password;
private static String driver;
//读取文件,只需要读取一次即可拿到这些值,
static {
try{
//创建Properties集合类
Properties pro = new Properties();
ClassLoader classLoader = JDBCUtils.class.getClassLoader();
URL res = classLoader.getResource("jdbc.properties");
String path = res.getPath();
System.out.println(path);
//加载文件
pro.load(new FileReader(path));
//获取数值
url = pro.getProperty("url");
user = pro.getProperty("user");
password = pro.getProperty("password");
driver = pro.getProperty("driver");
Class.forName(driver);
}catch(IOException e){
e.printStackTrace();
}catch (ClassNotFoundException e){
e.printStackTrace();;
}
}
//获取连接
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url,user,password);
}
//释放资源
public static void close(ResultSet rs, Statement stmt,Connection conn){
if(rs!=null){
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
(4)jdbc.properties配置文件
url=jdbc:mysql://localhost:3306/test?useSSL=false
user=root
password=123456
driver=com.mysql.jdbc.Driver
(5)调用JDBCUtils类方法进行数据库连接操作
import java.sql.*;
import java.util.Scanner;
public class jdbc_test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Scanner sc = new Scanner(System.in);
System.out.println("请输入用户名:");
String username = sc.nextLine();
System.out.println("请输入密码:");
String password =sc.nextLine();
boolean loginFlag = new jdbc_test().login(username,password);
if(loginFlag){
System.out.println("登陆成功");
}else {
System.out.println("失败");
}
}
public boolean login(String username,String password){
if(username==null||password==null){
return false;
}
Connection conn = null;
Statement stmt = null;
ResultSet rs =null;
try{
conn = JDBCUtils.getConnection();
//定义sql
String sql = "select * from user where name = '"+username+"' and password = '"+password+"'";
//获取执行sql对象
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
return rs.next();
}catch (SQLException e){
e.printStackTrace();
}finally {
JDBCUtils.close(rs,stmt,conn);
}
return false;
}
}