执行返回ResultSet对象的SQL语句intexecuteUpdate：执行数据库.PPT

updateInfo.jsp代码 /head body bgcolor=#FFFFFF text=#000000 center divbfont color=#8A0000 face=华文隶书 size=5更新学生信息/font/b/div % String sql=null; sql=SELECT * from student; databean db = new databean(); db.setCon(); ResultSet rs = db.getSearchRs(sql); % table border=1 tr tdb序号/b/td tdb学号/b/td tdb姓名/b/td tdb性别/b/td tdb年龄/b/td tdb专业/b/td tdb平均成绩/b/td tdb系别/b/td tdb是否更新/b/td updateInfo.jsp代码 /tr % int n=0; while(rs.next()) //列出所有的记录 { String s_no=rs.getString(1); % tr td%=(++n)%/td td%=s_no%/td td%=rs.getString(2)%/td td%=rs.getString(3)%/td td%=rs.getDate(4)%/td td%=rs.getString(5)%/td td%=rs.getFloat(6)%/td td%=rs.getString(7)%/td tda href=updateop.jsp?s_no=%=s_no%更新/a/td updateInfo.jsp代码 /tr % } % /table /center br table width=532 border=0 align=center tr td width=526 div align=righta href=index.htm首页gt;gt;gt;/a/div /td /tr /table /body /html updateop.jsp代码 !--updateop.jsp文件-- %@ page language=java contentType=text/html; charset=gb2312% %@ page import=java.sql.*% %@ page import=ch9.databean% html head title更改学生记录/title meta http-equiv=Content-Type content=text/html; charset=gb2312 /head body bgcolor=#FFFFFF text=#000000 center divbfont color=#8A0000 face=华文隶书 size=5更改学生记录/font/b/div % String sql; String s_no=null; String s_name=null; String s_sex=null; String s_birthday=null; String s_speciality=null; String s_avgrade=null; String s_dept=null; updateop.jsp代码 s_nsql=Select * From student where s_no=+s_no+; //构造查询语句 databean db1 = new databean(); db1.setCon(); ResultSet rs = db1.getSearchRs(sql); //执行查询语句 int n=0; while(rs.next()) { s_no=rs.getString(1).trim(); s_name=rs.getString(2).trim(); s_sex=rs.getString(3).trim(); s_birthday=rs.getString(4).trim(); s_speciality=rs.getString(5).trim(); s_avgrade=rs.getString(6).trim(); s_dept=rs.getString(7).trim(); break; } db1.CloseDateBaseCon(); db1=null; o=request.getParameter(s_no); % updateop.jsp代码 form name=form1 meth