刘明中期课件jsp课第8天

1、 A value=(publicclasshainextendsHttpServletthrowsServletException,IOExceptionList names=getList();String url=/drdp.forward(request, response);new String4; strs0=; /returnListListlist=newArrayList(); returnreturn%pagelanguage=javaimport=java.util.*List names=(List)request.ge!DOCTYPEHTMLPUBLIC-/W3C/DT

2、DHTML4.01取数据链上的复杂数据对象hri=0;icities.length;i+)out. hri=0;inames.size();i+)1java8 Chactereger1java8 Chactereger 类名称=数据表名称publicserRegPOcreatetableUSER_REG USER_IDVARCHAR2(20)primary NAME PASSWORD USER_TYPE publicpublicclass private String claprivate Date startTime; private Date endTime; public ClassRe

3、gPO() /TODOAuto-generatedconstructorcreatetableCLASS_REG CLASS_IDCHAR(7)primary START_TIME END_TIMEprivate String userId; private String name; privateStringpassword; privateStringpublicUserRegPO()/TODOAuto-generatedconstructorpublic UserRegtringuserId,Stringname,Stringpassword, String userType) this

4、.userId = userId; = name; this.password=password; this.userType=public tring cla,public tring cla,DatestartTime,DateendTime)= clathis.startTime=startTime; this.endTime = endTime;s数据 存取s数据 存取4、 示例如下public serReg insert(StringuserId,Stringname,Stringpassword,String returninsert(UserRegPOreturnupdate(S

5、tringuserId,Stringname,Stringpassword,String returnupdate(UserRegPOreturndelete(StringreturnListreturnpublicclassinsert(String,DatestartTime,Datereturninsert(ClassRegPOreturnupdate(String,DatestartTime,Datereturnupdate(ClassRegPOreturndelete(StringreturnListreturn=Data=Datapublicclassinsert(String c

6、la,Date startTime,Date endTime) String sql=insertoclass_reg an=DbUtil.update(sql, params);returninsert(ClassRegPOString sql=insertoclass_regvalues(?,?,?); returnupdate(String,DatestartTime,DateStringsql=updateclass_regsetstart_time=?,end_time=?where an=DbUtil.update(sql, params);returnupdate(ClassRe

7、gPOStringsql=updateclass_regsetstart_time=?,end_time=?where returndelete(StringStringsql=deletefrom class_reg whereclass_id=?; returnclassGetClassRegPOextendsclassGetClassRegPOextendspublicObjectgetOnePojo(ResultSetrecIndex)ExceptionClassRegPOp Stringcla =rs.getString(class_id); DatestartTime=rs.get

8、Date(start_time); Date endTime=rs.getDate(end_time);returnListStringsql=select* from class_reg; DbUtil obj=new GetClassRegPO(); Listlist=obj.search(sql,params); return list;publicicvoidmain3(StringStringDate startTime=new Date(110,4,22); /2010-5-22 DateendTime=newDate(110,10,22); /2010-11-22 =new Cl

9、assRegpublicicvoidmain4(StringStringDate startTime=new Date(110,4,22); /2010-5-22 DateendTime=newDate(110,10,22); /2010-11-22 =new ClassRegpublicicvoidpublicicvoidmain9(String String cla=new ClassRegpublicicvoidmain2(StringStringDate startTime=new Date(112,5,17); /2010-6-17 DateendTime=newDate(112,1

10、1,26); /2012-12-26ClassRegPO p,startTime,endTime); =new ClassRegpublicicvoidmain8(StringStringDate startTime=new Date(112,5,17); /2010-6-17 DateendTime=newDate(112,11,26); /2012-12-26ClassRegPO p,startTime,endTime); =new ClassRegpublicicvoidmain(String ClassReg=new ClassRegList list= .getClasses();

11、for(ClassRegPO po:list)public serReg insert(StringuserId,Stringpublic serReg insert(StringuserId,Stringname,Stringpassword,String String sql=insertouser_regvalues(?,?,?,?); an=DbUtil.update(sql,returninsert(UserRegPOString sql=insertouser_regvalues(?,?,?,?); returnupdate(StringuserId,Stringname,Stri

12、ngpassword,String Stringsql=update user_regsetname=?,password=?,user_type=? where user_id=?;an=DbUtil.update(sql, params);returnupdate(UserRegPOStringsql=update user_regsetname=?,password=?,user_type=? where user_id=?; returndelete(StringStringsql=deletedelete(StringStringsql=deletefrom user_regwher

13、euser_id=?; returnListStringsql=select*fromuser_regorderbyuser_id; DbUtil obj=new GetUserRegPO(); Listlist=obj.search(sql,params); return list;classGetUserRegPOextendspublicObjectgetOnePojo(ResultSetrecIndex)ExceptionUserRegPO p;returnpublicicvoidmain(String UserReg=new UserRegListlist= .getUsers();

14、 for(UserRegPO po:list)publicicvoidmain2(Stringpublicicvoidmain2(String=newpublicicvoidmain3(String=newUserRegPO pUserRegPO(aTest2,检测2,2222,讲师); publicicvoidmain4(String=newpublicicvoidmain5(String=newpublicicvoidmain6(String UserReg=new UserReg 1、客户端 服务器(端) CS=C/S/S,简称 CS 1、客户端 服务器(端) CS=C/S/S,简称 C

15、S 3JavaCS MyEclipse下,编辑窗口，右键，java 1BSBrowser浏览器 服务器(端BS B/S/S/S-简称 B/S,BSB/App S/DB S- 十一、 关于 BS1jsp2jspformaction=./servlet/UserRegAdd 用户inputtype=textname=userId tdinputtype=textname=name tdwidth=150inputtype=textname=password 用户类型tdwidth=250selectname=userType option 师师 public serRegAdd extends HttpServlet public serRegAdd extends HttpServlet throwsServletException,IOExceptionString name=request.getParameter(name);=new.insert(userId,name,password,userType); Writerout=response.getWriter(); ln(!DOCTYPEHTMLP