JSP编程实战案例解析第316讲

code316.java

package pack08;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;//数据库DB类
public class code316
{public static Connection getConnection(){Connection conn &＃61; null;try{Class.forName("com.mysql.jdbc.Driver");String url &＃61; "jdbc:mysql://localhost:3306/test";String user &＃61; "root";String pwd &＃61; "mysql123";conn &＃61; DriverManager.getConnection(url,user,pwd);} catch (ClassNotFoundException e){e.printStackTrace();}catch (SQLException e) {e.printStackTrace();}return conn;}public static Statement getStatement(Connection conn){Statement stmt &＃61; null;try{if (conn !&＃61; null){stmt &＃61; conn.createStatement();}} catch (SQLException e){e.printStackTrace();}return stmt;}public static ResultSet getResultSet(Statement stmt,String sql){ResultSet rs &＃61; null;try{if(stmt !&＃61; null){rs &＃61; stmt.executeQuery(sql);}} catch (SQLException e){e.printStackTrace();}return rs;}public static void close(Connection conn){try{if (conn !&＃61; null){conn.close();conn &＃61; null;}} catch (SQLException e){e.printStackTrace();}}public static void close(Statement stmt){try{if (stmt !&＃61; null){stmt.close();stmt &＃61; null;}} catch (SQLException e){e.printStackTrace();}}public static void close(ResultSet rs){try{if (rs !&＃61; null){rs.close();rs &＃61; null;}} catch (SQLException e){e.printStackTrace();}}}