项目实训课件第5天

5天课件121select*fromstudentwhereclass_id=?and=?andnamelike? andage>?andage<? phonelike?2POJOpublicclassStudentWherePOpublicclassStudentWherePOprivateString private;privateStringname;privateStringphone;privateIntegerage1;privateInteger3action4Liststuds;ListObc[]deId; //名称是固定的,数据类型依据主键随意定义，可以是整型/字符String publicclassStudentList3ActionextendspublicclassStudentList3ActionextendsS2SearchAction{privateListstuds;privateStudentWherePO 称pojoprivate privateString publicStringexecute()throwsExceptionStringhql="fromqh.student.Student";"namelike""phonelike:where.phone", studs=execute(hqlparams);//这一行完成：查询、翻页、删除return"input";}4jspincludejsp查询<link<linkrel="styleSheet"type="text/css"<s:formaction="StudentList3"<s:include<table<tdalign="rightwidth="100">班级号<s:select <tdalign="right" <s:select <tdalign="right" <s:textfieldname=""size="10"<tdalign="right" <s:textfieldname="where.age1"size="2"<tdalign="right" <s:textfieldname="where.age2"size="2"<tdalign="right" <s:textfieldname="where.phone"size="10"<div<table<tralign="center"<tdwidth="100">序号<tdwidth="100">学号<td <tdwidth="150">班级号<td <td <td <tdwidth="200">入学时间<tdwidth="300">住址 torvalue="studs"id="stud"<tr<td<s:checkboxlistname="delIds"<td>${stud.studId<td<td }</td><td <td>${stud.age ;':stud.phone<td>${stud.ruxueTime <buttononclick="delSelectIds();">删除<button excel2Hibernate3.2+Spring2.5+Struts2.1.xpoijar3yyyy-MM-dd2excel文件中，没有时间部分45createtableUSER_IDvarchar(20)primarykey,BIRTHDAYdatetime,ID_CARD )droptableTS_DATEUSER_IDvarchar(20)primarykey,BIRTHDAYdatetime,ID_CARDvarchar(20int，或字符中，则excel)select* fromts_datedeletefromts_date<beanid="impExcelNamedMode"<property 可以省略，默认为第0个页签propertyname="excelSheetName"<propertyname="impSQL"<value>insertintoTS_DATE(USER_ID,BIRTHDAY,ID_CARD)<property可以省略，开始导入行，默认为1，propertyname="startRowIndex"value="1"/-->value="-1"/-->publicstaticvoidmain(String[]args)throwsException{ApplicationContextctx=newImpExcelToDBobj=(ImpExcelToDB) ImpExcelToDBobj=(ImpExcelToDB)}6SVN122svn根2javaWeb项目3、自己可以建一个项目，进试SVN服务器的安装1 4、工 1Listpublicstaticpublicstaticvoidmain2(String[]args){List<Integer>list=newArrayList();for(inti=0;i<list.size();i++){Integerfor(intj=i+1;j<list.size();j++){Integerb=list.get(j);}}}for(inti=0;i<list.size();i++){Integera=list.get(i);}}publicstaticpublicstaticvoidmain(String[]args){List<Integer>list=newArrayList();SetSetset=newfor(inti=0;i<list.size();){Integera=list.get(i);}}for(inti=0;i<list.size();i++){Integera=list.get(i);}}publicclasspublicclass重新整理集合对象@paramstaticListstrToIntArray(Stringstr){inti1=Integer.parseInt(strs[0]);inti2=Integer.parseInt(strs[1]);Listlist=newArrayList();for(inti=i1;i<=i2;i++){}return}publicstaticvoidmain(String[]args){Listresult=newfor(intintcheck=strs[i].indexOf("-ListListlist=strToIntArray(strs[i]);}Integera=Integer.parseInt(strs[i]);}}for(inti=0;i<result.size();i++){}for(inti=0;i<nums.length;i++){}}publicstaticvoidmain2(String[]args){Listlist=strToIntArray("10-13");for(inti=0;i<list.size();i++){}}}1多级 的拷2publicclasspublicclass 拷贝*@param@paramdir2:目 staticvoidcopyDir(Stringdir1,StringFilef2=newFile(dir2); Filef1=newFile(dir1);for(inti=0;i<fileNames.length;i++){StringfileName=fileNames[i];StringsubFilePath=dir1+"\\"+fileName;FilesubFile=newFile(subFilePath);}elsecopyDir(subFilePath,}}}staticvoidcopyOneFile(Stringpath1,StringtryFilef=newFile(path1);StringfileName=f.getName();StringFileInputStreamfin=newFileInputStream(f);FileOutputStreamfout=newFileOutputStream(filePath2);b