Package testweb;
Import java.sql. *;
/ ** *
Title: Connection database *
Description: Connect the database class *
Copyright: Copyright (c) froggroup 2004 *
Company : Froggroup * @Author Zorro.x * @version 0.1 * /
public class DbConn {private Connection con; private Statement stmt; // Statement object is used to send SQL statements to the DBMS private boolean inited = false; private String localhost = "jdbc: mysql: // localhost: 3306 /"; private String dbDriver = "Org.gjt.mm.mysql.driver";
Public dbconn () {this ("TestWeb", "XXX", "");
Public dbconn (String ODBC, String Uid, String PWD) {// inInited = true; // has initialized try {class.forname (dbdriver); // loaded Mysql driver CON = DriverManager.getConnection (localhost ODBC, UID , PWD); // Connect the mysql database STMT = con.createstatement (ResultSet.Type_forward_only, resultset.concur_read_only); // Connect} catch (Exception EX) {Errreport (EX, "DBCONN: Database connection creation failed"); InInited = False; // Initialization failed}}
// Error Report Private Void Errreport (Exception EX, String Position) {system.out.print ("---- ====" POSITION "==== ----"); system.out. Println ("---- ====" (new java.util.date (). TOSTRING ()) "==== ----"); System.out.Println (ex.getMessage ));
Public java.sql.connection getConnection () {returncon;
Public java.sql.Statement getStatement () {// Returns SQL statement Return Stmt;}
}
