练习使用servlet + jdbc完成数据库用户添加功能
创建工具类JdbcConnectionUtils,使用jdbc来实现连接数据库
package com.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class JdbcConnectionUtils {
String url = "jdbc:mysql://localhost:3306/mysql?characterEncoding=UTF-8&&useUnicode=true";
String user = "root";
String password = "root";
String driverClassName = "com.mysql.jdbc.Driver";
Connection conn = null;
//创建数据库连接的方法
public Connection getConnection() {
try {
Class.forName(driverClassName);
conn = DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
//关闭数据库连接的方法
public void closeAll(Connection _conn, Statement _st, ResultSet _rs) {
if(_conn != null) {
try {
_conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if(_st != null) {
try {
_st.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if(_rs !=