关于prepareStatement的参数问题
import day614.JdbcUtil;
public class TestPs {
public static void main(String[] args) throws SQLException {
int id=Integer.parseInt(args[0]);//请问这句话该怎么理解,输入参数该输入什么,为什么运行时候会异常呢
Connection con = null;
PreparedStatement ps=null;
ResultSet rs = null;
con = JdbcUtil.getConnection();
String sql="select*from test_all"
+ "where id>?";
ps=con.prepareStatement(sql);
ps.setInt(1,id);
rs=ps.executeQuery(sql);
StringBuffer sb=new StringBuffer();
if(rs!=null){
while(rs.next()){
sb.append("id="+rs.getInt(1)+" ");
sb.append("name="+rs.getString(2)+"\n");
}
}
System.out.println(sb.toString());
JdbcUtil.release(rs, ps, con);
}
}
输入"test_all"时候的异常:
Exception in thread "main" java.lang.NumberFormatException: For input string: "test_all"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
at day614.TestPs.main(TestPs.java:10)