conn = DriverManager.getConnection("jdbc:odbc:stu", "system",
"oracle");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String ID = null;
String password; if (e.getSource().equals(OK)) {
ID = IDText.getText();
password = String.valueOf(passwordText.getPassword());
String sqlID = "select * from Admin where Aid = " + "'" + ID
+ "'";
rs = stmt.executeQuery(sqlID);//rs是空的?
rs.last();
int nowRow = rs.getRow();
//System.out.println(""+nowRow);//nowRow=0?要求查找一个ID,当找到时成功。到了rs这步为什么rs是空的?
然后再试试
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class TestJdbc {
public static void main(String[] args) throws Exception{
/*
* 加载驱动
* */
String strDriver="oracle.jdbc.OracleDriver";
Class.forName(strDriver);
/*
* 建立连接
* */
String url ="jdbc:oracle:thin:@192.168.1.251:1521:ORCL";
Connection conn=DriverManager.getConnection(url,"scott","123");
/*
* 查询数据库,执行查询语句
* */
Statement stmt=conn.createStatement();
String sql="select * from emp order by empno";
ResultSet rs=stmt.executeQuery(sql);
/*
* 遍历结果集
* */
while(rs.next()){
System.out.println(rs.getInt("empno"));
}
/*
* 关数据库连接
* */
rs.close();
stmt.close();
conn.close();
}
}
不知道你要连接的数据库是什么,我这是连接orcal数据库的,只需改一下驱动就行了!
请依据3楼的代码改正你自己的。
Access数据库用的jdbc:odbc:stu.