Mysql java Programming Interface (for future reference)

Package com. xiecheng. util; import java. SQL. *; public class DB {public static Connection getConn () {Connection conn = null; try {Class. forName ("com. mysql. jdbc. driver "); conn = DriverManager. getConnection ("jdbc: mysql: // localhost/test? User = test & password = test & useUnicode = true & characterEncoding = UTF-8 ");} catch (ClassNotFoundException e) {e. printStackTrace ();} catch (SQLException e) {e. printStackTrace () ;}return conn;} public static PreparedStatement prepare (Connection conn, String SQL) {PreparedStatement pstmt = null; try {if (conn! = Null) {pstmt = conn. prepareStatement (SQL) ;}} catch (SQLException e) {e. printStackTrace ();} return pstmt;} public static PreparedStatement prepare (Connection conn, String SQL, int autoGenereatedKeys) {PreparedStatement pstmt = null; try {if (conn! = Null) {pstmt = conn. prepareStatement (SQL, autoGenereatedKeys) ;}} catch (SQLException e) {e. printStackTrace ();} return pstmt;} public static Statement getStatement (Connection conn) {Statement stmt = null; try {if (conn! = Null) {stmt = conn. createStatement () ;}} catch (SQLException e) {e. printStackTrace ();} return stmt;}/* public static ResultSet getResultSet (Connection conn, String SQL) {Statement stmt = getStatement (conn); ResultSet rs = getResultSet (stmt, SQL); close (stmt); return rs;} */public static ResultSet getResultSet (Statement stmt, String SQL) {ResultSet rs = null; try {if (stmt! = Null) {rs = stmt.exe cuteQuery (SQL) ;}} catch (SQLException e) {e. printStackTrace ();} return rs;} public static void executeUpdate (Statement stmt, String SQL) {try {if (stmt! = Null) Begin stmt.exe cuteUpdate (SQL) ;}} catch (SQLException e) {e. printStackTrace () ;}} public static void close (Connection conn) {try {if (conn! = Null) {conn. close (); conn = null ;}} catch (SQLException e) {e. printStackTrace () ;}} public static void close (Statement stmt) {try {if (stmt! = Null) {stmt. close (); stmt = null ;}} catch (SQLException e) {e. printStackTrace () ;}} public static void close (ResultSet rs) {try {if (rs! = Null) {rs. close (); rs = null ;}} catch (SQLException e) {e. printStackTrace ();}}}