Writing SQL Server database connection classes with JavaBean

server|sql|sqlserver| Data | database | database connection

The following is a simple database connection tool class written in SQL Server, encapsulated in a WEB project (web-inf/classes/) directory, and introduced in Java or JSP pages.

ODBC name: MySQL;

User name: Dxaw;

Password: 123;

Method Executeupdate (): Update the database;

Method ExecuteQuery (): Returns a recordset through an SQL statement;

The code is as follows:

Class Conn.db.conndb.java

 
  
   
  Package Conn.db;import java.sql.*;p ublic class Conndb {Connection  conn;  ResultSet rs;  private int count;    Public conndb () {    try {        class.forname ("Sun.jdbc.odbc.JdbcOdbcDriver");    } catch (Exception ex) {}    } Public  ResultSet executequery (String sql) {    try {       conn=drivermanager.getconnection ("Jdbc:Odbc:mysql "," Dxaw "," 123 ");        Statement stat=conn.createstatement (resultset.type_scroll_sensitive,resultset.concur_updatable);        Rs=stat.executequery (SQL);    catch (Exception Ex1) {    } return  Rs.  } public void executeupdate (String sql) {     try {            conn = Drive Rmanager.getconnection ("Jdbc:Odbc:mysql", "Dxaw", "123");            Statement stat=conn.createstatement ();            Stat.executequery (SQL);        catch (Exception ex2) {    }}}