62,614
社区成员
发帖
与我相关
我的任务
分享
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
//获取发送对象
ment=conn.createStatement();
//String sql="select * from t_user where "+"u_name='"+name+"' and u_pwd='" + pwd+"'";
String sql="select * from t_user";
re=ment.executeQuery(sql);
int count=0;
//获取数据行数
while(re.next()){
count++;
}
System.out.println(count);
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
//获取发送对象
ment=conn.createStatement();
//String sql="select * from t_user where "+"u_name='"+name+"' and u_pwd='" + pwd+"'";
String sql="select * from t_user";
re=ment.executeQuery(sql);
int count=0;
//获取数据行数
while(re.next()){
count++;
System.out.println(count);
}
看一下变化. Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
//获取发送对象
ment=conn.createStatement();
//String sql="select * from t_user where "+"u_name='"+name+"' and u_pwd='" + pwd+"'";
String sql="select * from t_user";
PreparedStatement ps = conn.prepareStatement(sql);
re=ps.executeQuery();
int count=0;
//获取数据行数
while(re.next()){
count++;
}
System.out.println(count);