1.JDBC (Java DataBase Connectivity)
是使用java存取数据库系统的标准解决方案,它将不同数据库间各自差异API与标准SQL语句分开看待,实现数据库无关的java操作接口。
2.JDBC 程序访问数据库的步骤:
步骤一:加载JDBC驱动程序
步骤二:提供连接参数
步骤三:建立一个数据库连接
步骤四:创建一个statement
步骤五:执行SQL语句
步骤六:处理结果
步骤七:关闭JDBC对象
代码示例:
package com.terminater.dbutils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
public class JdbcUtils {
private final String USERNAME = "root";
private final String PASSWORD = "admin";
private final String DRIVER = "com.mysql.jdbc.Driver";
private final String URL = "jdbc:mysql://localhost:3306/dbname";
private Connection connection;
private PreparedStatement pstmt;
private ResultSet resultSet;
public JdbcUtils() {
try {
Class.forName(DRIVER);
System.out.println("注册驱动成功!");
} catch (Exception e) {
// TODO: handle exception
}
}
public Connection getConnection() {
try {
connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (Exception e) {
// TODO: handle exception
}
return connection;
}
public boolean updateByPreparedStatement(String sql, List<Object> params)
throws SQLException {
pstmt= connection.prepareStatement(sql);
int result = -1;//执行SQL后影响的行数
int index = 1;
if(params != null && !params.isEmpty()){
for(int i = 0; i< params.size(); i ++){
pstmt.setObject(i, params.get(i));
}
}
result = pstmt.executeUpdate();
return result > 0;
}
}