package cgrs.robinson;
import java.sql.*;
import java.io.*;
public abstract class sqlBean{
private String myDriver="org.gjt.mm.mysql.Driver";
private String host="localhost";
private String database="forum";
private String user="";
private String pass="";
protected Connection myConn;
public sqlBean(){}
public void makeConnection() throws Exception{
Class.forName(myDriver);
myConn=DriverManager.getConnection("jdbc:mysql://"+host+"/"+database,user,pass);
}
public abstract void cleanup() throws Exception;
public void makeDown() throws Exception{
cleanup();
myConn.close();
}
}
package cgrs.robinson;
import java.sql.*;
import java.io.*;
public class forumBean extends sqlBean{
ResultSet myResultSet=null;
Statement stmt=null;
public forumBean() {
super();
}
public boolean getNext() throws Exception{
return myResultSet.next();
}
public String getString(String fieldName) throws Exception{
return myResultSet.getString(fieldName);
}
public int getInteger(String fieldName) throws Exception{
return myResultSet.getInt(fieldName);
}
public java.util.Date getDate(String fieldName) throws Exception{
return myResultSet.getDate(fieldName);
} public boolean ExecuteQuery(String strSql) throws Exception{
stmt= myConn.createStatement();
myResultSet=stmt.executeQuery(strSql);
return (myResultSet!=null);
}
public void ExecuteUpdate(String strSql) throws Exception{
stmt= myConn.createStatement();
stmt.executeUpdate(strSql);
}
public void cleanup() throws Exception{
stmt.close();
}
}
import java.sql.*;
import java.io.*;
public abstract class sqlBean{
private String myDriver="org.gjt.mm.mysql.Driver";
private String host="localhost";
private String database="forum";
private String user="";
private String pass="";
protected Connection myConn;
public sqlBean(){}
public void makeConnection() throws Exception{
Class.forName(myDriver);
myConn=DriverManager.getConnection("jdbc:mysql://"+host+"/"+database,user,pass);
}
public abstract void cleanup() throws Exception;
public void makeDown() throws Exception{
cleanup();
myConn.close();
}
}
package cgrs.robinson;
import java.sql.*;
import java.io.*;
public class forumBean extends sqlBean{
ResultSet myResultSet=null;
Statement stmt=null;
public forumBean() {
super();
}
public boolean getNext() throws Exception{
return myResultSet.next();
}
public String getString(String fieldName) throws Exception{
return myResultSet.getString(fieldName);
}
public int getInteger(String fieldName) throws Exception{
return myResultSet.getInt(fieldName);
}
public java.util.Date getDate(String fieldName) throws Exception{
return myResultSet.getDate(fieldName);
} public boolean ExecuteQuery(String strSql) throws Exception{
stmt= myConn.createStatement();
myResultSet=stmt.executeQuery(strSql);
return (myResultSet!=null);
}
public void ExecuteUpdate(String strSql) throws Exception{
stmt= myConn.createStatement();
stmt.executeUpdate(strSql);
}
public void cleanup() throws Exception{
stmt.close();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货