項目實訓(xùn)課件第5天

5天課件121select*fromstudentwhereclass_id=?and=?andnamelike? andage>?andage<? phonelike?2POJOpublicclassStudentWherePOpublicclassStudentWherePOprivateString private;privateStringname;privateStringphone;privateIntegerage1;privateInteger3action4Liststuds;ListObc[]deId; //名稱是固定的,數(shù)據(jù)類型依據(jù)主鍵隨意定義，可以是整型/字符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">學(xué)號<td <tdwidth="150">班級號<td <td <td <tdwidth="200">入學(xué)時間<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 可以省略，默認(rèn)為第0個頁簽propertyname="excelSheetName"<propertyname="impSQL"<value>insertintoTS_DATE(USER_ID,BIRTHDAY,ID_CARD)<property可以省略，開始導(dǎo)入行，默認(rèn)為1，propertyname="startRowIndex"value="1"/-->value="-1"/-->publicstaticvoidmain(String[]args)throwsException{ApplicationContextctx=newImpExcelToDBobj=(ImpExcelToDB) ImpExcelToDBobj=(ImpExcelToDB)}6SVN122svn根2javaWeb項目3、自己可以建一個項目，進(jìn)試SVN服務(wù)器的安裝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