java SQL连接执行类

package com.zxh.servlet; import java.sql.DriverManager; import java.sql.SQLException; import com.mysql.jdbc.Connection; import com.mysql.jdbc.PreparedStatement; import com.mysql.jdbc.ResultSet; import com.mysql.jdbc.Statement; public class SQLBean { String dbDriver; String connectionString; String userName; String password; Connection connection = null; Statement statement = null; PreparedStatement preparedStatement = null; ResultSet resultSet = null; public SQLBean() { dbDriver = "com.mysql.jdbc.Driver"; connectionString = "jdbc:mysql://localhost/said"; userName = "root"; password = "123456"; } public Connection getConnection() { try { Class.forName(dbDriver); System.out.println("Success loading MySQl driver"); } catch (ClassNotFoundException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } try { connection = (Connection) DriverManager.getConnection( connectionString, userName, password); System.out.println("Success connection MySQL Database"); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return connection; } public void executeInsert(String sqlString) { connection = this.getConnection(); try { statement = (Statement) connection.createStatement(); statement.executeUpdate(sqlString); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } public void executeUpdate(String sqlString) { connection = this.getConnection(); try { statement = (Statement) connection.createStatement(); statement.executeUpdate(sqlString); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } // String sql = "select * from student"; } public ResultSet executeQuery(String sqlString) { connection = this.getConnection(); try { statement = (Statement) connection.createStatement(); resultSet = (ResultSet) statement.executeQuery(sqlString); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return resultSet; } public void executeDelete(String sqlString) { connection = this.getConnection(); try { statement = (Statement) connection.createStatement(); resultSet = (ResultSet) statement.executeQuery(sqlString); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } public PreparedStatement getPreparedStatement(String sqlString) { connection = this.getConnection(); try { preparedStatement = (PreparedStatement) connection .prepareStatement(sqlString); } catch (SQLException e) { // TODO 自动生成 catch 块 System.out.println("sqlBean connection error"); } return preparedStatement; } public void close() { try { if (statement != null) statement.close(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } try { if (connection != null) connection.close(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } public String getDbDriver() { return dbDriver; } public void setDbDriver(String dbDriver) { this.dbDriver = dbDriver; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getConnectionString() { return connectionString; } public void setConnectionString(String connectionString) { this.connectionString = connectionString; } }