mydb.java

关于论坛的用jsp开发具有删除回复

package dbcon;
import java.sql.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.*;
import javax.sql.*;

public class mydb {

String strUser="",strPassword="";
String strDbdriver="sun.jdbc.odbc.JdbcOdbcDriver";
String strConstring="jdbc:odbc:ibbs";
//String strDbdriver = "org.gjt.mm.mysql.Driver";
//String strConstring = "jdbc:mysql://localhost:3306/ibbs";


Connection conn = null;
ResultSet rs = null;

public mydb() {
try {//--read db info from config file-------------
             
Class.forName(strDbdriver); 
}
catch(Exception e) {
System.err.println("mydb(): " + e.getMessage());
}
}

//----query------------------
public ResultSet executeQuery(String sql)throws Exception {
rs = null;
conn = DriverManager.getConnection(strConstring,strUser,strPassword); 
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
if(rs==null){System.exit(1);}
return rs;
}
//---Update-------------------
public void executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(strConstring,strUser,strPassword); 
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
stmt.close();
conn.close();
} 
catch(SQLException ex) { 
System.err.println("aq.executeUpdate: " + ex.getMessage());
 }
}


}