A Java Bean that operates a database ...

Data | Database A Java Bean that operates a database, interested friends take a look at it ~ ~





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.ClassNotFoundException 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.executequery:" + ex.getmessage ());


}


}





public void closestmt ()


{


Try


{


Stmt.close ();


}catch (SQLException ex) {


System.err.println ("aq.executequery:" + ex.getmessage ());


}


}





public void Closeconn ()


{


Try


{


Conn.close ();


}catch (SQLException ex) {


System.err.println ("aq.executequery:" + ex.getmessage ());


}


}


}