我帖错了
这个才是:
import java.sql.*;public class socialBean {
String DDriver="sun.jdbc.odbc.IdbcOdbcDriver";
String CStr="jdbbc:odbc:socialex";
Connection conn=null;
ResultSet rs=null; public socialBean() {
try{
Class.forName(DDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("socialex():"+e.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(CStr);
Statement jdbcs=conn.createStatement();
rs=jdbcs.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.xecuteQuery:"+ex.getMessage());
}
return rs;
}}
这个才是:
import java.sql.*;public class socialBean {
String DDriver="sun.jdbc.odbc.IdbcOdbcDriver";
String CStr="jdbbc:odbc:socialex";
Connection conn=null;
ResultSet rs=null; public socialBean() {
try{
Class.forName(DDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("socialex():"+e.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(CStr);
Statement jdbcs=conn.createStatement();
rs=jdbcs.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.xecuteQuery:"+ex.getMessage());
}
return rs;
}}
String DDriver="sun.jdbc.odbc.IdbcOdbcDriver";
~~~~~Jdbc???
String CStr="jdbbc:odbc:socialex";
~~~~~~~~jdbc?
Connection conn=null;
ResultSet rs=null; public socialBean() {
try{
Class.forName(DDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("socialex():"+e.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(CStr);
Statement jdbcs=conn.createStatement();
rs=jdbcs.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.xecuteQuery:"+ex.getMessage());
}
return rs;
}}
最前面的是调用Javabean
第二个是Bean本身
//这句不需要用户名和密码的吗??我用的是oracle,一定要不知access要不要?
类似delphi的datasource&query.
<jsp:useBean id="ds" scope="session" class="pack.DataSource"/>
<jsp:useBean id="query" scope="session" class="pack.Query"/〉
ds.readConfigData(request.getRealPath("/")+"/qqjsp/config.txt");
ds.open();
query.setDataSource(ds);
query.executeQuery("select * from tablename");
String str=query.getString(0,0);