封装DB
package com.zm.bbs;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DB {public static Connection getConn(){Connection conn=null;try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}try {conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","root");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static Statement getStmt(Connection conn){Statement stmt=null;try {stmt=conn.createStatement();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return stmt;}public static ResultSet getRs(Statement stmt,String sql){ResultSet rs=null;try {rs=stmt.executeQuery(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return rs;}public static void close(ResultSet rs){if(rs!=null){try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs=null;}}public static void close(Statement stmt){if(stmt!=null){try {stmt.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}stmt=null;}}public static void close(Connection conn){if(conn!=null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}conn=null;}}}?