JDBC数据库连接的实现
- 数据库的连接Jar包是数据库厂家提供的driver(驱动类),不同的厂家有不同的驱动类。
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/库名?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123456";
public Connection conn;
- 注册驱动
Class.forName("com.mysql.jdbc.Driver");
Connection connection=(Connection) DriverManager.getConnection(URL, USER, PASSWORD);
System.out.println("加载成功!");
- 创建执行的SQL语句
String sqlString="select * from user";
Statement statement = (Statement) connection.createStatement();
ResultSet re=(ResultSet) statement.executeQuery(sqlString);
- 处理结果
while(re.next()) {
String userNameString=re.getString("userName");
System.out.println(userNameString);
}
- 释放资源
- 如果不释放资源,会造成缓存过多,严重影响程序运行。
if(re!=null) {
re.close();
}
if(statement!=null) {
statement.close();
}
if(connection!=null) {
connection.close();
}
- 封装好的JDBC类
public class DBConnection {
public static void main(String[] args) {
}
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/fengye?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123456";
public Connection conn;
public DBConnection() {
try {
Class.forName(driver);
conn = (Connection) DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
}
public void close() {
try {
this.conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}