JDBC
问题:Java连接MySQL实现CRUD
需求:
- 数据库相关信息存放在配置文件中
- 将连接MySQL的基本方法封装成一个工具类
下面是我所编写的代码
db.properties文件(配置文件)
className = com.mysql.cj.jdbc.Driver
url = jdbc:mysql://localhost:3306/bjpowernode?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
username = root
passwd = 这里写连接数据库的密码
JDBCTool.java文件
package com.jvstudy.day14.test1;
import java.sql.*;
import java.util.ResourceBundle;
/**
* Java连接数据库工具类
*/
public class JDBCTool {
private JDBCTool() { }
/**
* @return 数据库连接对象
* @throws SQLException
*/
public static Connection getConnection() throws SQLException {
ResourceBundle rb = ResourceBundle.getBundle("com.jvstudy.day14.test1.db");
String className = rb.getString("className");
String url = rb.getString("url");
String username = rb.getString("username");
String passwd = rb.getString("passwd");
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return DriverManager.getConnection(url,username,passwd);
}
/**
* @param conn 数据库连接对象
* @param sql sql预编译模板
* @return 数据库操作对象
* @throws SQLException
*/
public static PreparedStatement getPreparedStatement (Connection conn,String sql)throws SQLException{
return conn.prepareStatement(sql);
}
/**
* @param conn 数据库连接对象
* @param ps 数据库操作对象
* @param rs 返回的数据集
*/
public static void close(Connection conn,PreparedStatement ps,ResultSet rs){
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
测试
package com.jvstudy.day14.test1;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class test1 {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = JDBCTool.getConnection();
ps = JDBCTool.getPreparedStatement(conn,"select ename,sal from emp where ename=? or sal>?");
ps.setString(1,"smith");
ps.setInt(2,2500);
rs = ps.executeQuery();
while (rs.next())
System.out.println(rs.getString("ename")+"\t"+rs.getString("sal"));
JDBCTool.close(conn,ps,rs);
} catch (SQLException e) {
e.printStackTrace();
}
}
}