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) { }}}