jsp常用数据访问方法:

jsp常用数据访问方法:

1\statement

statement statement=con.crateStatement();
resultset rs=statement.excuteQuery(sql)

//
while(rs.next()){
//业务处理
}
 
2\prepareStatement
prepareStatement mystatement=con.PrepareStatement(sql);
Resultset rs=mystatement.executeQuery();
带有参数的情况
String  s="update authors set lastname=? where authid=?"
prepareStatement a=con.preparestatement();

3\调用存储过程:
无参数
CallableStatement call=com.prepareCall("(call procedureName)");
resultset rs=call.excuteQuery();
代有参数
CallableStatement call=com.prepareCall("(call procedureName(?,?))");
call.setint(1,3);
call.setint(2,1999)
resultset rs=call.excuteQuery();