关于jdbc的 无法得到resultset返回的结果 那为高手给看看
ljpro 2003-09-11 11:12:22 import java.awt.*;
import java.sql.*;
public class JDBCTest2 extends Frame{
TextArea txtArea;
public JDBCTest2(){
super("JDBCtest");
setLayout(new FlowLayout());
txtArea=new TextArea(30,80);
add(txtArea);
resize(500,500);
show();
txtArea.setText(".............\n");
}
public static void main(String[] args) throws SQLException,Exception{
String query="select * from Employees";
try{
JDBCTest myJDBCTest=new JDBCTest();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection mycnn=DriverManager.getConnection("jdbc:odbc:mdb");
if (mycnn!=null) System.out.println("database not null");
Statement mystmt=mycnn.createStatement();
if (mystmt!=null) System.out.println("stmt not null");
ResultSet myresults=mystmt.executeQuery(query);
if(myresults!=null) System.out.println("rs not null");
myJDBCTest.displayResults(myresults);
//close
myresults.close();
mystmt.close();
mycnn.close();
}
catch (SQLException ex) {
while(ex!=null){
System.out.println ("database: " +
ex.getSQLState ()+" "+ex.getErrorCode());
System.out.println ("Message: " +ex.getMessage ());
System.out.println ("Vendor: " +ex.getErrorCode ());
ex = ex.getNextException ();
System.out.println ("");
}
}
}
void displayResults(ResultSet rs)throws SQLException{
ResultSetMetaData rsmd=rs.getMetaData();
if (rsmd!=null) System.out.println("rsmd not null");
int cols=rsmd.getColumnCount();
if(cols!=0) System.out.println(cols);
txtArea.setText("");
while(rs.next()){
for(int i=1;1<=cols;i++){
if(i>1) txtArea.append("\t");
try{
txtArea.append(rs.getString(1));
}
catch(NullPointerException e){
}
}
txtArea.append("\n");
}
}
public boolean handleEvent(Event evt){
if(evt.id==Event.WINDOW_DESTROY){
System.exit(0);
return true;
}
return super.handleEvent(evt);
}
}
xp+sp1 odbc在系统中配的“mdb”在mssql中也是一样的结果 但mysql却可以正常连接用的是mysql的java驱动