封裝的DBHelper（JAVA）

標籤：

JDBC+Mysql

public class DBHelper {private static String driver ="com.mysql.jdbc.Driver";private static String url ="jdbc:mysql://localhost:連接埠號碼(3306)/資料庫名"; private static String username ="帳號";private static String password ="密碼";//靜態， 串連public static Connection ToConnection(){Connection conn = null;try {Class.forName(driver);try {conn = DriverManager.getConnection(url, username, password);} catch (SQLException e) {e.printStackTrace();}} catch (ClassNotFoundException e) {e.printStackTrace();}return conn;}//關閉串連public static void CloseConnection(Connection conn){if(conn !=null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}//關閉結果集public static void CloseResultSet(ResultSet rs){if(rs!=null){try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs=null;}}//關閉statementpublic static void ClosePreparedStatement(PreparedStatement psmt){if(psmt!=null){try {psmt.close();psmt=null;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}public static void CloseStatement(Statement stmt){if(stmt!=null){try {stmt.close();stmt=null;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

 

封裝的DBHelper（JAVA）