Java连接mysql封装
时间: 2023-07-11 13:39:58 浏览: 104
Java连接MySQL通常使用JDBC API来实现,以下是一个简单的封装示例:
```java
import java.sql.*;
public class MySQLConnect {
private Connection conn = null;
private PreparedStatement pstmt = null;
private ResultSet rs = null;
public MySQLConnect(String url, String user, String password) {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql, Object...params) {
try {
pstmt = conn.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
pstmt.setObject(i+1, params[i]);
}
rs = pstmt.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public void close() {
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
使用时,可以这样调用:
```java
MySQLConnect connect = new MySQLConnect("jdbc:mysql://localhost:3306/test", "root", "password");
ResultSet rs = connect.executeQuery("select * from user where id = ?", 1);
while (rs.next()) {
System.out.println(rs.getString("name"));
}
connect.close();
```