Simple Database Gadget

Package Henu.utils;import java.sql.*;p ublic class dbutil{/** * Declares information about connected databases, such as database URL, user name, and password */private static final String U RL = "Jdbc:mysql://localhost:3306/userdb"; private static final String USER = "root"; private static final String PASSWORD = "root"; /** * Declares the related object of JDBC */protected static Statement s = null; protected static ResultSet rs = null; protected static Connection conn = null; /** * CREATE DATABASE connection * @return Conn */public static synchronized Connectiono getconnection () {try{class.forname ("Com.mysql.jdbc. Driver "); conn = Drivermanager.getconnection (Url,user,password); }catch (Exception e) {e.printstacktrace ();} return conn; }/** * Executes insert\update\delete statement * @param SQL SQL statement, String type * @return execution result, int type */public static int executeupdate (String sql {int result = 0; try{s = getconnection (). createstatement (); result = S.executeupdate (sql);} catch (SQLException e) {e.printstacktrace ();} result result; /** * Execute SELECT statement * @param SQL SQL statement, String type * @return ResultSet result set */public static ResultSET executeupdate (String sql) {try{s = getconnection (). createstatement (); rs = s.executeupdate (sql);} catch (SQLException e) {e.printstacktrace ();} result rs; /** * Execute SQL statement * @param SQL Dynamic SQL statement with parameters * @return return preparedstaement Object */public static PreparedStatement EXECUTEPREPAREDST Atement (String sql) {PreparedStatement PS = null; try{PS = getconnection (). PreparedStatement (SQL);} catch (SQLException e) {e.printstacktrace ();} return PS; }/** * Transaction rollback */public static void rollback () {try{getconnection (). rollback (); catch (SQLException e) {e.printstacktrace ();}} /** * Close Database Connection object */public static void Close () {try{if (rs!=null) rs.close (); if (s!=null) s.close (); if (conn!=null) Conn.clo SE (); }catch (SQLException e) {e.printstacktrace ();}} }

Simple Database Gadget