Writing SQL Server database connection classes with JavaBean

server|sql| 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.*; public 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 = drivermanager.getconnection ("Jdbc:Odbc:mysql", "Dxaw", " 123 "); Statement stat=conn.createstatement (); Stat.executequery (SQL); catch (Exception ex2) { }} }