Chazan pruning MySQL database fixed mode

omit import of related packages ... Public classBase { Public StaticConnection Connection =NULL;  Public StaticPreparedStatement PreparedStatement =NULL;  Public StaticResultSet ResultSet =NULL;  Public Static intUpdaterows = 0;      PublicConnection tomcatgetconnection () {Try{Context Context=NewInitialContext (); DataSource DataSource= (DataSource) context.lookup ("Java:comp/env/jdbc/mysql"); Connection=datasource.getconnection (); } Catch(namingexception e) {e.printstacktrace (); } Catch(SQLException e) {e.printstacktrace (); }        returnconnection; }         PublicResultSet query (String sql, object[] param) {Try{PreparedStatement=connection.preparestatement (SQL);  for(inti = 0; i < param.length; i++) {Preparedstatement.setobject (i+ 1, Param[i]); } ResultSet=Preparedstatement.executequery (); } Catch(SQLException e) {e.printstacktrace (); }        returnResultSet; }         Public intUpdate (String sql, object[] param) {Try{PreparedStatement=connection.preparestatement (SQL);  for(inti = 0; i < param.length; i++) {Preparedstatement.setobject (i+ 1, Param[i]); } updaterows=preparedstatement.executeupdate (); } Catch(SQLException e) {e.printstacktrace (); }        returnupdaterows; }         Public voidClose () {if(ResultSet! =NULL) {            Try{resultset.close (); } Catch(SQLException e) {e.printstacktrace (); }        }        if(PreparedStatement! =NULL) {            Try{preparedstatement.close (); } Catch(SQLException e) {e.printstacktrace (); }        }        if(Connection! =NULL) {            Try{connection.close (); } Catch(SQLException e) {e.printstacktrace (); }        }    }    }

Chazan pruning MySQL database fixed mode