Java连接数据库（一）_conn = dbutils.getconnection(); ps = conn.prepare-CSDN博客

Java连接数据是Java开发的一个重要部分，本节将以连接MySQL数据库描述Java连接数据库的基本操作：

需要的包

mysql-connector-java-*-bin.jar （具体版本，自行调整）

在src下，添加数据库配置文件

db-config.properties

jdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false
jdbc.username=root
jdbc.password=123456
jdbc.driver=com.mysql.jdbc.Driver

封装工具类

DBUtils.java

public class DBUtils {
public static String URL;
public static String USERNAME;
public static String PASSWORD;
public static String DRIVER;
private static ResourceBundle rb = ResourceBundle.getBundle(“db-config”);
private DBUtils() {
}
static {
URL = rb.getString(“jdbc.url”);
USERNAME = rb.getString(“jdbc.username”);
PASSWORD = rb.getString(“jdbc.password”);
DRIVER = rb.getString(“jdbc.driver”);
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println(“加载数据库驱动失败”);
}
}
/**
* 定义一个获取数据库连接的方法
*
* @return
*/
public static Connection getConnection() {
try {
Connection conn = null;
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
return conn;
} catch (SQLException e) {
System.out.println(“连接创建失败”);
e.printStackTrace();
return null;
}
}
/**
* 关闭数据库连接
*
* @param rs
* @param stat
* @param conn
*/
public static void close(ResultSet rs, Statement stat, Connection conn) {
// 关闭ResultSet
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 关闭Statement
try {
if (stat != null)
stat.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 关闭Connection
try {
if (conn != null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

使用DBUtils工具类进行数据库的操作

public List findAll() throws SQLException {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
User bean = null;
List beanList = new ArrayList();
String sql = “select * from user “;
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
bean = new User();
// 设置属性 ….
beanList.add(bean);
}
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(“查询失败”);
} finally {
DBUtils.close(rs, ps, conn);
}
return beanList;
}