java连接oracle数据库查不到数据
private static String dbDriver = "oracle.jdbc.driver.OracleDriver"; // 数据库的驱动
private static String url = "jdbc:oracle:thin:@192.168.1.199:1521:orcl"; // URL地址
public static Connection connection = null;
public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException {
MemberForm member = null;
try {
Class.forName(dbDriver).newInstance(); // 加载数据库驱动
connection = DriverManager.getConnection(url, "meip", "meip"); // 加载数据库
PreparedStatement ps = connection.prepareStatement("select * from tb_member where name=?");
ps.setString(1, "Tsoft");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
member = new MemberForm();
member.setId(Integer.valueOf(rs.getString(1)));
member.setName(rs.getString(2));
member.setPassword(rs.getString(3));
member.setReallyName(rs.getString(4));
member.setAge(Integer.valueOf(rs.getString(5)));
member.setProfession(rs.getString(6));
member.setEmail(rs.getString(7));
member.setQuestion(rs.getString(8));
member.setResult(rs.getString(9));
}
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
这是源码,能连接上,但是DEBUG跟踪查询出来的是空的,没有数据,SQL在数据库里面执行可以查询到数据