Java Bean in another operational database

Java bean in a manipulation database, you are interested in friends look ~~

Package dbconnect;

Import java.sql. *;

Public class sqlconnection {

String sDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc: odbc: sqlconnect"; // sqlconnect data source name; private Connection conn = null; private Statement stmt = null; ResultSet rs = null;

Public SqlConnection () {Try {class.forname (sdbdriver);} catch (java.lang.classnotnetfoundexception e) {system.err.println ("sqlConnection (): E.getMessage ());}

public ResultSet executeQuery (String sql) {rs = null; try {conn = DriverManager.getConnection (sConnStr); stmt = conn.createStatement (); rs = stmt.executeQuery (sql);} catch (SQLException ex) {System.err .println ("AQ.ExecuteQuery:" EX.GetMessage ());} Return RS;

public void executeUpdate (String sql) {stmt = null; rs = null; try {conn = DriverManager.getConnection (sConnStr); stmt = conn.createStatement (); stmt.executeQuery (sql); stmt.close (); conn. CLOSE ();} catch (sqlexception ex) {system.err.println ("aq.executequence:" ex.getMessage ());}}

Public void closest () {Try {stmt.close ();} catch (sqlexception ex) {system.err.println ("AQ.ExecuteQuery:" ex.getMessage ());}}

Public void closeconn ()} catch (sqlexception ex) {system.err.println ("AQ.ExecuteQuery:" ex.getMessage ());}}}