基本步骤
- 加载数据库驱动
- 获取数据库连接
- 获取数据库操作对象
- 编写sql语句
- 利用操作对象执行sql语句
- 获得结果集
- 释放相关资源
准备工作
导入数据库连接相关jar包
实例代码
//MyConnection.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DatabaseConnection {
//驱动
private static final String DRIVER ="com.mysql.cj.jdbc.Driver";
//URL
private static final String URL ="jdbc:mysql://localhost:3306/nsno?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT";
//数据库用户名和密码
private static final String USERNAME ="root";
private static final String PASSWORD ="123456";
private Connection conn = null;
public DatabaseConnection() {
try {
Class.forName(DRIVER);
this.conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
}
public Connection getConnetion(){
return conn;
}
public void close(){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String args[]) throws SQLException{
//获取Connecction
Connection conn = new DatabaseConnection().getConnetion();
//编写sql
String sql = "insert into person(id,name,age) value(?,?,?)";
//获取pstmt
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 2);
pstmt.setString(2, "美少男");
pstmt.setInt(3, 18);
//执行
pstmt.execute();
//关闭资源
pstmt.close();
conn.close();
}
}