Calm公益车队爱心量化与点赞软件源代码修改——软著修改资料文档

第一部分客户端程序1源代码文件名\Fleet\src\czqy\Jdbc.java packageczqy;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import passenger.PassengerData;import com.mysql.jdbc.PreparedStatement;import com.mysql.jdbc.Statement;/**数据库管理类**/public classJdbc{//建立数据库连接public ConnectiongetConnection{String url二〃jdbc:String username二〃tudou〃；String password二〃tudoul23〃；Connection connection=null;try{Class.forName,com.mysql.jdbc.Driver;connection=DriverManager.getConnectionurl,username,password;System.err.print In〃数据库连接成功〃;}catch ClassNotFoundExceptione{e.printStackTrace;System,err.printin〃数据量连接失败〃;//TODO:handle exception}catch SQLExceptione{//TODO Auto-generated catchblock e.printStackTrace;System,err.printin〃数据库连接失败〃;return connection;//取得数据库数据总数public int findcount{int count=0;Connection connection=this.getConnection;String sql=select count*from driver”;try{Statement statement=Statement connection.createStatement;ResultSet resultSet=statement.executeQuerysql;public classDriverSelectData extends HttpServletpublic DriverSelectData{super;public voiddestroy{super.destroy;//Just putsdestroy“string in log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding，z gb2312z/;response.setCharacterEncoding/z gb2312/z;int currpage=1;if request.getParameterz，page，z!=null{currpage=Integer,parselnt request.getParameterz，page，z;System.err.printincurrpage=〃+currpage;Jdbc jdbc=new Jdbc;ListDriverData list=jdbc.findcurrpage;request.setAttribute〃list〃，list;int pages;int count二jdbc.findcount;if count%DriverData.size==0{pages二count/DriverData.size;System,err.printinz，DriverData.size=，/+DriverData.size;System.err.printinpages=〃+pages;}else{pages=count/DriverData.size+1;System,err.printinDriverData.size=/，+DriverData.size;System.err.printin，，pages=，，+pages;}StringBuffer stringBuffer=new StringBuffer;for int i=l;i=pages;i++{if i==currpage{stringBuffer.append〃[〃+i+〃]〃;System,err.printin〃i=〃+i;}else{stringBuffer.appendz，a href=，DriverSelectDatapage=zz+i+，z，〉〃+i+〃〈/a〉〃;stringBuffer.append〃〃;System.err.println〃i=〃+i;}request.setAttributez/bar，z,stringBuffer;request.setAttribute count”,count;request.setAttribute^pages,pages;request.getRequestDispatcherz，showDriverData.jsp〃・forward request,第10页，共61页response;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType，，text/htmr，;PrintWriter out=response.getWriterO;out.printin〃〈！DOCTYPE HTMLPUBLIC\〃-〃W3C//DTD HTML

4.01Transitional//EN\，//，;out.printin//HTML/，;out.printing HEADXTITLEA Servlet/TITLEX/HEAD〃;out.printinz，〈BODY〉“;out.printz，This is〃；out.print this.getClass;out.printinz，,using thePOST method;out.printinz，/B0DY〉〃;out.printinZ，/HTML Z，;out.flush;out.close;public voidinit throws ServletException{//Put yourcode herepublic classInsert extends HttpServlet{public Insert{super;}public voiddestroy{super.destroy;//Just putsdestroy〃string in log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setCharacterEncoding/z gb2312z/;SmartUpload smartUpload=new SmartUpload;String root=request.getSession.getServletContext.getRealPath^/^;String savpath=root+〃image\\〃；String filename二〃〃；Connection connection=Connection new Jdbc.getConnectionO;第11页，共61页String sql4二〃insert intopassenger p name,p phone,p driverid,p content,p datetime,p imagevalues,,,,,〃String p_name=null;int driverld=0;String pothers=null;long p phone=0;String df=null;try{smartUpload.initializegetServletConfig,request,response;smartUpload.setAllowedFi lesList，png,jpg,ico〃;smartUpload.upload;smartUpload.savesavpath;System,err.printinsavpath;filename=smartUpload.getFiles.getFile

0.getFilePathName;System.err.print In，/filename=//+fil ename;p name=smartUpload.getRequest.getParameter，z username z，;driverld=Integer.valueOf smartUpload.getRequest.getParameter/z driverld/z;p others=smartUpload.getRequest.getParameter/z p others;p_phone=Long.valueOf smartUpload.getRequest.getParameterz，phone/z;df=new SimpleDateFormat〃yyyy-MM-ddHH:nmi:ss〃.formatCalendar,getlnstance.getTime;System.out.printin df;System.err.printlnp_name+driverld+p_others+p_phone+df;}catch Exceptione{//TODO:handle exceptione.printStackTrace;try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql4;preparedStatement.setStringl,p name;preparedStatement.setLong2,p_phone;preparedStatement.setlnt3,driverld;preparedStatement.setString4,pothers;preparedStatement.setString5,df;preparedStatement.setString6,filename;int row=preparedStatement.executeUpdate;ifrow0{System,out.print In，/row=，/+row;}preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;response.sendRedirect，z thank

2.jsp〃;}public voidinitthrows ServletException{//Put yourcode here第12页，共61页public classSelectld extendsHttpServlet{public Selectld{super;}public voiddestroy{super.destroy;//Just putsdestroy“string in log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding，/gb2312/，;response.setCharacterEncoding，z gb2312/z;int id=Integer.valueOfrequest.getParameter^select^；Connection connection=new Jdbc.getConnection;try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementZ，SELECT a.d id,a.d image,a.d name,a.d_platenum,a.d_phone,b.f_name,b.f_company FROMdriver a,fleet bWHERE a.d fleetid=b.f id and a.d id=〃;preparedStatement.setlnt1,id;ResultSet resultSet=preparedStatement.executeQuery;ListDriverData list二new ArrayListDriverData;whileresultSet.next{DriverData driverData=new DriverDataO;driverData.setD_platenumresultSet.getString，，a.d_platenum，7;driverData.setD_idresultSet.getlnt〃a・d_id〃;driverData.setD_imageresultSet.getString，z a.d image;driverData.setD_name resultSet.getStringCa.d_name，z;driverData.setD_phone resultSet.getLong，z a.d_phone z，;driverData.setF_name resultSet.getStringC^b.f_name z，;driverData.setF companyresultSet.getStringC^b.f company;list,adddriverData;}request.setAttribute〃list2〃，list;resultSet.close;preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃查询模块出错〃;request.getRequestDispatcher，z f irst.jsp〃・forward request,response;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType，，text/htmr，;第13页，共61页PrintWriter out=response.getWriterO;out.printin，z!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01z/，z Transitional//EN\;out.printin〈HTML〉“;out.printing HEADXTITLEA Servlet/TITLE/HEAD，Z;out.printin〃BODY/，;out.print CThis is〃；out.print this.getClass;out.printin〃，using thePOST method;out.printinz，〈/BODY〉“;out.printin/，/HTML/，;out.flush;out.close;}public voidinitthrows ServletException{//Put yourcode here}public classSelectData extendsHttpServlet{int i;public SelectDataO{super;}public voiddestroy{super.destroy;//Just putsdestroy string in log//Put yourcode herepublic voiddoGetHttpServletRcquest request,HttpServletResponse responsethrows ServletException,lOExceptionrequest.setCharacterEncoding，，gb2312，/;，/，/response.setCharacterEncodinggb2312;String selectName=new Stringrequest.getParameter，，select，/.getBytes，/IS0-8859-r，,〃gb2312〃;Connection connection=new Jdbc.getConnection;tryPreparedStatement preparedStatement=PreparedStatement connection.prepareStatement，z SELECT a.d id,a.d image,a.d name,a.d_phone,b.f_name FROMdriver a,fleet bWHERE a.d_fleetid=b.f_idanda.d name=？;preparedStatement.setString1,selectName;ResultSet resultSet=preparedStatement.executeQuery;ListDriverData list=new ArrayListDriverData;while resultSet.next{DriverData driverData=new DriverDataO;driverData.setD_id resultSet.getlnt，z a.d_id〃;driverData.setD_image resultSet.getString/z a.d_image z，;driverData.setD_name resultSet.getString/z a.d_name，/;driverData.setD_phone resultSet.getLong z，a.d_phone，z;第14页，共61页driverData.setF name resultSet.getStringC^b.f_name，/;list,adddriverData;PreparedStatement preparedStatementl=PreparedStatement，z connection.prepareStatementselect*from id〃；ResultSet resultSet3=preparedStatementl.executeQuery;while resultSet

3.next{z/，z i=resultSet

3.getlntid;System,out.print In〃测试的id:〃+i;}PreparedStatement preparedStatement2=PreparedStatement connection.prepareStatement select*from announcementwhere a_id=〃;preparedStatement

2.setlnt1,i;ResultSet resultSet4=preparedStatement

2.executeQuery;ListAdData2list2=new ArrayListAdData2;while resultSet

4.next{AdData2adData2=new AdData2;adData

2.setAnnouncement request.getParameter，，a_content，z;list

2.addadData2;}request.setAttribute，，listAd2，z,list2;request.setAttributelist;resultSet.close;PreparedStatement.close;connection.close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃查询模块出错〃;request.getRequestDispatcherz，showSelectData.jsp〃・forward request,response;}public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType，，text/htmr，;PrintWriter out二response.getWriterO;out.print InC\!DOCTYPE HTMLPUBLIC\，Z-//W3C//DTD HTML

4.01Transitional//EN\z，，z;out.printin〈HTML〉“;out.printing HEADXTITLEA Servlet/TITLEX/HEAD，Z;out.printinz，〈BODY〉“;第15页，共61页out.print CThis is〃；out.print this.getClass;out.printin/z,using thePOST method;out.printin〃/BODY〉〃;out.printin“〈/HTML〉”；out.flush;out.close;public voidinitthrows ServletException{//Put yourcode here2源代码文件名\Fleet\src\czqyl\DriverData.java public class DriverDataextendsHttpServlet{private String a_content;inti;public intgetl{return i;public voidsetl inti{this,i=i;public intgetSelect_id{return Select_id;public voidsetSelect_idint select_id{Select_id=select_id;private intSelect id;public Stringgetacontent{return a_content;public voidseta contentStringa content{this.a_content=a_content;public DriverData{Connection connection=null;tryClass,for Name，z com.mysql.jdbc.Driver;connection=Connection new Jdbc.getConnectionO;PreparedStatement preparedStatement1=PreparedStatement connection.prepareStatement select*from id〃;ResultSet resultSet3=preparedStatement

1.executeQuery;while resultSet

3.next{i=resultSet

3.getlnt〃id〃;第16页，共61页System.out.printin〃测试的id:〃+i;}PreparedStatement preparedStatement2=PreparedStatement connection.prepareStatementz，select*from announcementwhere a_id=，/;PreparedStatement

2.setlnt1,i;ResultSet resultSet4=preparedStatement

2.executeQuery;whileresultSet

4.next{acontent=resultSet

4.getString，，a_content，/;System.out.printina_content;System.out.printin〃链接成功〃;//System.out.printing成功〃;resultSet

3.close;PreparedStatement

2.close;connection,close;}catch Exceptione{//TODO:handle exceptionSystem.out.printin〃失败〃;}}public classGetld extendsIlttpServlet{public Getld{super;public voiddestroy{super.destroy;//Just putsdestroy string in log//Put yourcode herepublic voiddoGetHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{int selected=Integer.valueOf request.getParameter C，select，/;new DriverDataO.setSelect_idselect_id;System,err.printin，/select_id=//+new DriverDataO.getSelect_id;response.sendRedirect，z first.jsp〃;}public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType/，text/html/，;PrintWriter out=response.getWriterO;out.print In/z!DOCTYPE HTMLPUBLIC\〃-〃W3c7/DTD HTML

4.01Transitional//EN\，，z，;out.printinZ，HTML Z，;out.printing HEADXTITLEA Servlet〈/TITLEX/HEAD〃;out.printinz，BODY Z，;out.print，z This is〃；第17页，共61页out.print this.getClass;out.printinz，,using thePOST method;out.printinz，〈/BODY〃;out.printin/，/HTML/，;out.flush;out.close;public voidinit throws ServletException{//Put yourcode here2源代码文件名\Fleet\src\fleet\FleetAddData.java packagefleet;import java.io.lOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet,http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public classFleetAddData extendsHttpServlet{public FleetAddData{super;}public voiddestroy{super.destroy;//Just putsdestroy string in log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding/z gb2312，z;response.setCharacterEncoding/z gb2312/z;String f_name=new Stringrequest.getParameter〃f name〃・getBytes〃1$0-8859—1〃,〃gb2312〃;String f_company=new Stringrequest.getParameter，，f_company，.getBytes ISO-8859—1〃,〃gb2312〃;int f_person=Integer.valueOfrequest.getParameter Cf-person;System,err.print Inf_company+f_name-i-f_person;JdbcFleet jdbcFleet=new JdbcFleet;jdbcFleet.insertfname,fcompany,f_person;response.sendRedirect C，FleetSelectData2，/;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType〃text/html〃;PrintWriter out=response.getWriterO;第18页，共61页out.print Inr!DOCTYPE HTMLPUBLIC\〃-〃W3C//DTD HTML

4.01z//，Transitional//EN\;out.printin〈HTML〉“;out.printin〃HEADXTITLEA Servlet〈/TITLEX/HEAD〃；out.printinz，〈BODY〉“;out.print/z This is〃；out.print this.getClass;out.printin，z,using thePOST method;out.printin〃〈/BODY〉“;out.printinZ，/HTML Z，;out.flush;out.close;public voidinitthrows ServletException{//Put yourcode here}public classFleetData{private int fid;private String f_name;private String f company;private String f_dname;private int f_person;public intgetF_person{return f_person;public voidsetF_personint f_person{this.f_person二f_person;}public intgetF_id{return f_id;public voidsetF_idint f_id{this.f_id=f_id;一public StringgetF_name{return f_name;public voidsetFnameString fname{this,f name=f name;}public StringgetF_company{return f company;public voidsetFcompanyString fcompany{this.f_company=f_company;一public StringgetF_dname{return f_dname;第19页，共61页if resultSet.next{count=resultSet.getlntl;}resultSet.close;statement,close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System.err.printin〃获取总数块儿出错〃;System.err.printincount=〃+count;return count;//分页查找public ListDriverDatafindint page{Connection connection=this.getConnection;String sql=SELECT a.d_id,a.d_image,a.d name,a.d_phone,b.f_id,b.f_name,b.f_company,a.d_platenum FROMdriver a,fleet bWHERE a.d_fleetid=b.f_id ORDER BY a.d id limit,〃；ListDriverData list=new ArrayListDriverData;tryPreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setlntl,page-1*DriverData.size;preparedStatement.setlnt2,DriverData.size;System,err.println，/a，/+page-1*PassengerData.size;System,err.println〃b〃+PassengerData.size;ResultSet resultSet=preparedStatement.executeQuery;while resultSet.next{DriverData driverData=new DriverData;driverData.setD_id resultSet.getlnt，z a.d_id〃;driverData.setD_image resultSet.getString z，a.d_image z，;driverData.setD name resultSet.getString//a.d_name〃;driverData.setD_phone resultSet.getLong z，a.d_phone/z;driverData.setF_nameresultSet.getString，z b.f_name，z;driverData.setD_platenumresultSet.getString，，a.d_platenum，z;driverData.setF idresultSet.getlntz，b.f_id〃;driverData.setF_company resultSet.getString z，b.f_company，/;System,err.print InresultSet.getString〃b・f_company z，;list.adddriverData;resultSet.close;preparedStatement.close;connection,close;}catch Exceptione{第2页，共61页public voidsetF_dnameString f_dname{this.fdname=fdname;~~public longgetF dphoneO{return f_dphone;}public voidsetF_dphonelong f_dphone{this.f_dphone=fdphone;1private longf dphone;public staticfinal intsize=4;public FleetDataO{public classFleetDelete extendsHttpServlet{public FleetDelete{super;public voiddestroy{super.destroy;//Just putsdestroy string in log//Put yourcode herepublic voiddoGetHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{int id二Integer.valueOf request.getParameter，z id，z;String sql=delete from fleet where f_id二？〃；JdbcFleet jdbcFleet=new JdbcFleet;Connection connection=new Jdbc.getConnection;try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatement sql;preparedStatement.setlnt1,id;int row=preparedStatement.executeUpdate;if row!=0{System.err.print In〃车队删除成功〃;}preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printing车队删除失败〃;response.sendRedirect，，FleetSelectData2,，;第20页，共61页public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType z，text/html z/;PrintWriter out=response.getWriterO;out.printin〃!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01Transitional//EN\，，/，;out.printin，HTML/，;out.printin〃HEADXTITLEAServlet/TITLEX/HEAD Z，;out.printinz，〈BODY〃;out.print，z This is〃；out.print this.getClass;out.printin〃，using thePOST method;out.printinz，/BODY〉〃;out.printin〃〈/HTML〃;out.flush;out.close;public voidinit throws ServletException{//Put yourcode herepublic classFleetSelectData2extendsHttpServlet{public FleetSelectData2{super;public voiddestroy{super.destroy;//Just puts〃destroy〃string in log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding/，gb2312，/;response.setCharacterEncoding z，gb2312/z;int currpage=1;if request.getParameterz/page z/!=null{currpage=Integer,parselntrequest.getParameter^page^;System.err.printin，，currpage=，，+currpage;}JdbcFleet jdbcFleet=new JdbcFleet;ListFleetData list2=jdbcFleet.findcurrpage;request.setAttributeC zlistFleet z，,list2;int pages;第21页，共61页int count=jdbcFleet.findcountFleet;if count%FleetData.size=0{pages=count/FleetData.size;}else{pages=count/FleetData.size+1;}StringBuffer stringBuffer=new StringBuffer;for inti=l;i=pages;i++{ifi==currpage{stringBuffer.append〃[〃+i+〃]〃;}else{stringBuffer.append，a href=，FleetSelectData2page=/，+i+，/，〉〃+i+〃〈/a〉〃;stringBuffer.append〃〃;request.setAttribute/z barFleet，/,stringBuffer;request.setAttribute/，countFleet z，,count;request.setAttribute，，pagesFleet，z,pages;request.getRequestDispatcher，z showFleetData.jsp〃・forward request,response;public voiddoPostHttpServletRequest request,IlttpServletResponse responsethrows ServletException,lOException{response.setContentType，，text/html/，;PrintWriter out=response.getWriterO;out.print In!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01Transitional//EN\，，/，;，，/，out.printinHTML;out.printin〃HEADXTITLEAServlet〈/TITLEX/HEAD〃；out.printinz，〈BODY〉“;out.print/z This is〃；out.print this.getClass;out.printin，z,using thePOST method;out.printinz，/B0DY〉〃;out.printin/，/HTML/，;out.flush;out.close;public voidinitthrows ServletException{//Put yourcode here第22页，共61页public classFleetUpdata extendsHttpServlet{public FleetUpdataO{super;public voiddestroy{super.destroy;//Just putsdestroy stringin log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding，z gb2312z/;response.setCharacterEncoding/z gb2312/z;intf_id=Integer.valueOf request.getParameter，z id，z;Stringf_name=newString request.getParameterz/f_namez/.getBytes〃IS0-8859-l〃，〃gb2312;Stringf_company=new Stringrequest.getParameter，，f_company，/.getBytes〃150—8859—1〃,〃gb2312〃;intf_person=Integer.valueOf request.getParameter^f-person^;System,err.printInf_company+f_name+f_person+f_id;new JdbcFleet.updataf_id,f_person,f_name,f_company;response.sendRedirect，z FleetSelectData2z，;}public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{z，z，response.setContentType text/html;PrintWriter out=response.getWriterO;out.print In，z!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01z/z，Transitional//EN\;out.printin/，HTML/，;out.printin〃HEADXTITLEAServlet/TITLE/HEAD，Z;out.printinz，BODY〉〃;out.printz，This is〃；out.print this.getClass;out.printin〃，using thePOST method;out.printin，〈/BODY〃;out.printinZ，/HTML Z，;out.flush;out.close;第23页，共61页public voidinit throws ServletException{//Put yourcode herepublic classJdbcFleet{public intfindcountFleet{int count=0;Connection connection=new Jdbc.getConnection;String sql=select count*fromfleet”;tryStatement statement=Statement connection.createStatement;ResultSet resultSet=statement.executeQuerysql;if resultSet.next{count=resultSet.getlntl;}resultSet.close;statement,close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃获取总数块儿出错〃;System,err.printincount=〃+count;return count;public ListFleetDatafindint page{Connection connection=new Jdbc.getConnection;String sql=SELECT a.f id,a.f company,a.f name,a.f person,b.d name,b.d_phone FROMfleet a,driver bWHERE a.f person=b.d idORDERBYa.f_idlimit,〃;ListFleetData list=new ArrayListFleetData;try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setlnt1,page-1WriverData.size;preparedStatement.setlnt2,DriverData.size;ResultSet resultSet=preparedStatement.executeQuery;whileresultSet.next{FleetData fleetData=new FleetDataO;f leetData.setF idresultSet.getlnt，z a.f_id〃;fleetData.setF_company resultSet.getString，z a.f_company z，;fleetData.setF nameresultSet.getString z，a.f name;fleetData.setF_person resultSet.getlntz，a.f_person，z;fleetData.setF_dname resultSet.getString〃b・d_name，/;fleetData.setF_dphone resultSet.getLong，z b.d_phone〃;list,addfleetData;第24页，共61页resultSet.close;preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃分页查询块儿出错〃;return list;public voidinsertString f_name,Stringf_company,intf_person{Connection connection=new Jdbc.getConnection;int row=0;try{PreparedStatement preparedStatement二PreparedStatement connection.prepareStatement insert into fleetf_name,f_company,f_person values,,〃；preparedStatement.setStringd,f_name;preparedStatement.setString2,f_company;preparedStatement.setlnt3,f_person;row=preparedStatement.executeUpdate;ifrow!=0{System.err.printin〃插入成功〃;}else{System.err.printin〃插入失败〃;}preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃车队插入模块出错〃;System,err.printInf_company+f_name+f_person;}public voidupdataint f_id,int person,String name,String company{//TODO Auto-generated methodstub Connection connection=new Jdbc.getConnection;String sql=update fleetset fname=,fcompany=,f person=wheref_id=〃；try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setString1,name;preparedStatement.setString2,company;preparedStatement.setlnt3,person;preparedStatement.setlnt4,f_id;第25页，共61页int row=preparedStatement.executeUpdate;第25页，共61页if row!=0{System.err.print In〃车队更新成功〃;}else{System.err.printin〃车队更新失败〃;}preparedStatement.close;connection.close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃车队更新模块出错〃;}public classJdbcpassenger{public intfindcountPassenger{int count=0;Connection connection=new Jdbc.getConnection;String sql=select count*from passenger”;try{Statement statement=Statement connection.createStatement;ResultSet resultSet=statement.executeQuerysql;if resultSet.next{count=resultSet.getlnt1;}resultSet.close;statement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System,err.printin〃获取总数块儿出错〃;System.err.printincount=〃+count;return count;public ListPassengerDatafindint page{Connection connection=new Jdbc.getConnection;String sql=SELECTa.d name,b.p_id,b.p name,b.p phone,b.p content,b.p datetime,b.p_image FROMdriver a,passenger bWHERE a.d id=b.p driveridlimit,〃；ListPassengerData list=new ArrayListPassengerData;try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setlnt1,page-1*PassengerData.size;第26页，共61页preparedStatement.setlnt2,PassengerData.size;第26页，共61页System,err.print In，，a，，+page-1*PassengerData.size;System,err.printin/b^+PassengerData.size;ResultSet resultSet=preparedStatement.executeQuery;whileresultSet.next{PassengerData passengerData=new PassengerDataO;passengerData.setlmage resultSet.getString z，b.p_image〃;passengerData.setP_idresultSet.getlnt^b.p_id〃;passengerData.setD nameresultSet.getString，/a.d name;passengerData.setP_nameresultSet.getString，z b.p_name〃;passengerData.setP phoneresultSet.getLong/z b.pphone;passengerData.setP_content resultSet.getString，z b.p content;passengerData.setDateresultSet.getStringCb.p datetime;System.err.print InresultSet.getlnt〃b・p id，z+resultSet.getStringz，a.d name〃；System,err.print InresultSet.getStringz，b.p image;list,addpassengerData;}resultSet.close;preparedStatement.close;connection.close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;return list;public classPassengerData{private String dname;private intp_id;private String image;public Stringgetlmage{return image;public voidsetlmageString image{this,image=image;}public intgetP_id{return p_id;public voidsetP_idint p_id{this.p id=p id;private Stringp_name;private longp_phone;private Stringp_content;private String date;第27页，共61页//TODO:handle exceptione.printStackTrace;System.err.printin〃分页查询块儿出错”;return list;public voidinsertString d_image,String d_name,long d_phone,int d_fleetid,String d_platenum{Connection connection=this.getConnection;int row=0;try{PreparedStatement preparedStatement二PreparedStatementconnection.prepareStatementInsert intodriverd_name,d_phone,d_fleetid,d_image,d_platenumvalues,,,,〃;preparedStatement.setStringl,d_name;preparedStatement.setLong2,d_phone;preparedStatement.setlnt3,d_fleetid;preparedStatement.setString4,d_image;preparedStatement.setString5,d_platenum;row=preparedStatement.executeUpdate;if row!=0{System.err.printin〃插入成功〃;}else{System.err.printin〃插入失败〃;}preparedStatement.close;connection.close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System.err.printin〃插入模块出错〃;public voidupdataint fid,int id,String name,long phone,String platenum,Stringimage{//TODO Auto-generated methodstub Connection connection=new Jdbc.getConnection;String sql=update driverset d name=,d_phone=,d fleetid=,d image=,d platenum=where did二？〃；try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setString1,name;preparedStatement.setLong2,phone;preparedStatement.setlnt3,fid;preparedStatement.setString4,image;preparedStatement.setString5,platenum;preparedStatement.setlnt6,id;int row=preparedStatement.executeUpdate;第3页，共61页public StringgetDate{return date;}public voidsetDateString date{this.date=date;}public staticfinal intsize=5;public StringgetD name{return dname;一public voidsetD nameString d name{this.d name=d name;}public StringgetP name{return p name;public voidsetP_nameString p_name{this.pname=pname;public longgetP_phone{return p_phone;public voidsetP_phonelong p_phone{this.p_phone=p_phone;}public StringgetPcontent{return p_content;public voidsetP_contentString p_content{this.pcontent=pcontent;}public PassengerDataO{public classPassengerDelete extendsHttpServlet/***Constructor ofthe object.*/public PassengerDelete{super;/***Destruction ofthe servlet.br*/第28页，共61页public voiddestroy{super.destroy;//Just putsdestroy stringin log//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{int id=Integer.valueOfrequest.getParameter^id^;String sql=delete frompassenger wherep_id二？〃；Jdbcpassenger jdbcpassenger=new Jdbcpassenger;Connection connection=Connection new Jdbc.getConnection;tryPreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setlnt1,id;int row=preparedStatement.executeUpdate;if row!=0{System,err.printin〃车队删除成功〃;}preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System.err.printin〃车队删除失败〃;response.sendRedirect^PassengerSelectData77;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType/，text/htmr，;PrintWriter out=response.getWriterO;out.print InC!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01Transitional//EN\，z/z;out.printin/，HTML/，;out.printing HEADXTITLEAServlet/TITLEX/HEAD〉〃;out.printin，z BODY;out.print，z This is〃；out.print this.getClass;out.printin，z,using thePOST method;out.printin C/BODY〃;out.printin，，/HTML，/;out.flush;out.close;}public voidinit throws ServletException{//Put yourcode here第29页，共61页public classPassengerSelectData extendsHttpServlet{public PassengerSelectData{super;}public voiddestroy{super.destroy;//Just putsdestroy“stringinlog//Put yourcode herepublic voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding/z gb2312/z;response.setCharacterEncodingC z gb2312，z;int currpage=1;if request.getParameter^page^!=null{currpage=Integer,parselnt request.getParameterz/page，z;System.err.printin/z currpage=/z+currpage;Jdbcpassenger jdbcpassenger二new Jdbcpassenger;ListPassengerData list二jdbcpassenger.findcurrpage;request.setAttribute〃listPassenger〃，list;int pages;int count=jdbcpassenger.findcountPassenger;ifcount%PassengerData.size=二0{pages=count/PassengerData.size;}else{pages=count/PassengerData.size+1;StringBuffer stringBuffer=new StringBuffer;for inti=l;i=pages;i++{if i==currpage{stringBuffer.append〃[〃+i+〃]〃;}else{stringBuffer.append/z a href=PassengerSelectDatapage=/z+i+z/，〃+i+〃〈/a〃;}stringBuffer.append〃〃;}request.setAttribute/z barPassenger/z,stringBuffer;request.setAttribute CcountPassenger,,count;request.setAttribute pagesPassenger^,pages;第30页，共61页request.getRequestDispatcher，z showPassenger.jsp〃・forward request,response;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType/，text/html/，;PrintWriter out=response.getWriterO;out.printin〃!DOCTYPE HTMLPUBLIC\〃-〃W3C//DTD HTML

4.01Transitional//EN\，//，;out.printin，，HTML/，;out.printing HEADXTITLEAServlet/TITLE/HEAD，/;out.printin〃BODY〉〃;out.printz，This is〃；out.print this.getClass;out.printinz，,using thePOST method;out.printinz，〈/BODY〉“;out.printinZ，/HTML Z，;out.flush;out.close;public voidinit throws ServletException{//Put yourcode herepublic classaddUse extendsHttpServlet{public addUse{super;public voiddestroy{super.destroy;//Just putsdestroy stringinlog//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding//utf-8，/;response.setCharacterEncoding，z utf-8z，;String name=new Stringrequest.getParameter^name^.getBytesISO-8859—1〃,〃utf-8〃;String use二new Stringrequest.getParameter，z a_content/z.getBytes ISO-8859—1〃,〃utf-8〃;String passwordnew Stringrequest.getParameter，，a_content/，.getBytes〃1$0-8859—1〃,〃utf-8〃;new JdbcUse.insertname,use,password;第31页，共61页response.sendRedirectz，UseSelectData，z;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType，，text/htmr，;PrintWriter out=response.getWriterO;out.printin〃〈！DOCTYPE HTMLPUBLIC\〃-〃W3C//DTD HTML

4.01Transitional//EN\，//，;out.printin〃HTML〉〃;out.printing HEADXTITLEAServlet/TITLEX/HEAD〃;out.printinz，〈BODY〉“;out.printz，This is〃；out.print this.getClass;out.printinz，,using thePOST method;out.printinz，/B0DY〉〃;out.printinZ，/HTML Z，;out.flush;out.close;public voidinit throws ServletException{//Put yourcode herepublic classJdbcUse{public intfindcountPassenger{int count=0;Connection connection=new Jdbc.getConnection;String sql=select count*from usename”;tryStatement statement=Statement connection.createStatement;ResultSet resultSet=statement.executeQuerysql;if resultSet.next{count=resultSet.getlntl;}resultSet.close;statement,close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;System.err.printin〃获取总数块儿出错〃;System,err.printincount=〃+count;return count;第32页，共61页public ListUseDatafindint page{Connection connection=new Jdbc.getConnection;String sql=SELECT*FROM usenamelimit ListUseData list=new ArrayListUseData;try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setlnt1,page-l*UseData.size;preparedStatement.setlnt2,UseData.size;ResultSet resultSet=preparedStatement.executeQuery;while resultSet.next{UseData useData=new UseData;useData.setU_idresultSet.getlnt〃u id〃;useData.setU nameresultSet.getString z，u name;useData.setU passwordresultSet.getString//u_password/，;useData.setU usenameresultSet.getString/z u usename，z;list,adduseData;}}catch Exceptione{//TODO:handle exceptione.printStackTrace;return list;}public voidinsert Stringname,String use,String password{Connection connection=new Jdbc.getConnection;String sql=insertintousename u name,u_password,u usenamevalues9Q〃・try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatement sql;preparedStatement.setStringd,name;preparedStatement.setString2,password;preparedStatement.setString3,use;preparedStatement.executeUpdate;preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;}public classUseData{private intu_id;public intgetU_id{return u_id;第33页，共61页public voidsetU_idint u_id{this.u_id=u_id;}~private Stringuname;private Stringupassword;private Stringu usename;public finalstatic intsize=3;public UseDataO{public StringgetU name{return uname;public voidsetU nameStringu name{this.u name=uname;1public StringgetU_password{return upassword;public voidsetU passwordStringu_password{this.u_password=u_password;}public StringgetU_usename{return u_usename;public voidsetU_usenameString uusename{this,uusename=u_usename;}}public classUseDelete extendsHttpServlet{public UseDelete{super;*Destruction ofthe servlet.br*/public voiddestroy{super.destroy;//Just putsdestroy stringinlog//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{int id=Integer.valueOf request.getParameterz，id z/;String sql=delete fromusename whereu_id二？〃；Connectionconnection=new Jdbc.getConnection;tryPreparedStatement preparedStatement=PreparedStatement第34页，共61页connection.prepareStatementsql;preparedStatement.setlnt1,id;preparedStatement.executeUpdate;preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;response.sendRedirect，z UseSelectData z，;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType，，text/html/，;PrintWriter out=response.getWriterO;out.print In/z!DOCTYPE HTMLPUBLIC\ZZ-//W3C//DTD HTML

4.01Transitional//EN\，zz，;out.printinZ，HTML Z，;out.printing HEADXTITLEAServlet/TITLEX/HEAD，/;out.printinz，BODY〃;out.print，z This is〃；out.print this.getClass;out.printinz，,using thePOST method;out.printin，z/B0DY〃;out.printin，，/HTML/，;out.flush;out.close;/***Initialization ofthe servlet.br**©throws ServletExceptionif anerror occurs*/public voidinit throws ServletException{//Put yourcode herepublic classUseSelectData extendsHttpServlet{/***Constructor ofthe object.*/public UseSelectData{super;/**第35页，共61页*Destruction ofthe servlet.br*/public voiddestroy{super.destroy;//Just putsdestroy stringinlog//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncodingz，gb2312，z;response.setCharacterEncoding z，gb2312/z;int currpage=1;if request.getParameterpage!=null{currpage=Integer,parselnt request.getParameter/z page/z；System,err.printinz，currpage=，/+currpage;}JdbcUse jdbcUse=new JdbcUse;ListUseDatalist=jdbcUse.findcurrpage;request.setAttribute〃listUse〃，list;int pages;int count=jdbcUse.findcountPassenger;ifcount%UseData.size==0{pages二count/UseData.size;System.err.printin/DriverData.size=，，+UseData.size;System,err.printin，z pages=/，+pages;}else{pages=count/UseData.size+1;System.err.printin/z DriverData.size=〃+UseData・size;System,err.printin，，pages=/，+pages;}StringBuffer stringBuffer=new StringBuffer;for inti=l;i=pages;i++{if i==currpage{stringBuffer.append〃[〃+i+〃]〃;System,err.printin〃i=〃+i;}else{stringBuffer.appendz，a href=，DriverSelectDatapage=//+i+，/，〉〃+i+〃/a〉〃;stringBuffer.append〃〃;System,err.printin〃i=〃+i;}request.setAttribute^barUse^,stringBuffer;request.setAttributecountUse”,count;request.setAttribute，，pagesUse，/,pages;request.getRequestDispatcherzz showUseData.jsp〃・forward request,response;第36页，共61页public voiddoPostHttpServletRequest request,HttpServletResponse responsethrows ServletException,lOException{response.setContentType〃text/html〃;PrintWriter out=response.getWriterO;out.print In!DOCTYPE HTMLPUBLIC\〃-〃W3C〃DTD HTML

4.01Transitional//EN\，//，;out.printin，，HTML/，;，/out.printing HEADXTITLEAServlet/TITLE/HEAD;out.printin〃〈BODY〉“;out.printz，This is〃；out.print this.getClass;out.printinz，,using thePOST method;out.printinz，〈/BODY〉“;out.printinZ，/HTML Z，;out.flush;out.close;/***Initialization ofthe servlet.br**©throws ServletExceptionif anerror occurs*/public voidinit throws ServletException{//Put yourcode here第二部分:服务器端媒体服务程序1源代码文件名\Fleet\WebRoot\addDriver.jsp，，，%@page language二〃java〃import二〃java・util・*〃pageEncoding=gb2312%%String path=request.getContextPath;String basePathrequest.getScheme+〃://〃+request・getServerName+〃:〃+request,getServerPort+p ath+7〃;%!DOCTYPE HTMLPUBLIC-//W3C//DTD HTML

4.01Transitional//EN Z，html head base href=〃〈％=basePath%〉”〉title6«/m公益车队爱心量化与点赞软件〈/title〉meta http-equiv二〃pragma content=〃no-cache〃meta http-equiv=〃cache-control content=〃no-cache”〉meta http-equiv=〃expires content=〃0〃〉meta http—equiv二〃keywords content=keywordl,keyword2,keywords z，第37页，共61页if row!=0{System,err.printin〃更新成功〃;}else{System,err.print In〃更新失败〃;}preparedStatement.close;connection.close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;public classDriverSe1ectData extendsHttpServlet{/***Constructor ofthe object.*/public DriverSelectDataO{super;/***Destruction ofthe servlet.br*/public voiddestroy{super.destroy;//Just puts“destroy stringinlog//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrows ServletException,lOException{request.setCharacterEncoding，z gb2312z，;response.setCharacterEncoding〃gb2312〃;int currpage=1;if request.getParameterzz pagez/!=null{currpage二Integer,parselntrequest.getParameter^page^;System.err.printincurrpage=〃+currpage;Jdbc jdbc二new Jdbc;ListDriverData list=jdbc.findcurrpage;request.setAttribute z，list z/,list;int pages;int count二jdbc.findcount;if count%DriverData.size==0{pages=count/DriverData.size;System,err.printin/z DriverData.size=，，+DriverData.size;System.err.printin，，pages=，，+pages;}else{第4页，共61页meta http-equiv=〃description content=〃This ismy page〃〈!一link rel=，，stylesheet z，type二〃text/css〃href二〃styles.css〃一link href=〃css/adddriver.css〃rel=stylesheet“type二〃text/css〃〉script src=〃js/show.js^X/script/head bodydiv id=/，mainDiv，，div id二〃topDiv〃h2^/m公益车队爱心量化与点赞软件/h2div align二〃right〃form action二〃SelectData method二〃get”input type二〃text“name二〃select/〉input type二〃submit value=〃查询〃/〉/form/div div id二〃tmenu〃!一表格上方--/div/div div id=/，centerDiv，zdiv id二〈table width=〃165〃height=〃100%〃border=〃0〃cellpadding=〃20〃cellspacing=〃0〃tr td height=〃28〃background二〃images/main

40.gif〃table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td width=〃19%〃nbsp;〈/td td width=〃81%height=〃20〃Xspan class二〃STYLE1〃管理菜单/spanX/td/tr/table/td/tr tr td valign二〃top〃align二〃center”〉table width=〃151〃border=〃0〃cellpadding=〃0〃cellspacing=〃0〃tr tdtable width=〃100%〃border—0〃cellspacing=0〃cellpadding=〃0〃〉tr td height=〃23〃background=77images/main_

47.gif〃id=〃imgmenul”class=〃menutitle”onMouse0ver=，，this.className=，menu_title2，;，z onClick-〃showsubmenu⑴〃onMouse0ut=，，this.className=，menu_title，;〃style=cursor:hand〃table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td width=〃18%”nbsp;/td td width=〃82%〃class二〃STYLE/〉信息管理/td第38页，共61页/tr/table/td/tr tr td background=，z images/main_

51.gif〃id=，/submenul z，div class二〃secmenu”table width=〃100%〃border=〃0〃cellspacing=0〃cellpadding=〃0〃tr tdtable width=〃90%〃border二〃0〃align二〃center cellpadding二〃0〃cellspacing=〃0〃tr td width=〃16%〃height=〃25〃Xdiv align二〃center”〉img src=/，images/left.gif z，width=〃10〃height=〃10〃//div/td td width=〃84%〃height=〃23〃〉table width=〃95%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉trtd height=〃20〃style=〃cursor:hand〃onmouseover二〃this・style.borderStyle=solid，;this,style.borderWidth=，;borderColor=，#7bc4d3，;“onmouseout=〃this,style.borderStyle=none，〃span class二〃STYLE3〃Xa href=〃DriverSelectData〃司机信息/a〈/span/td/tr/table/td/tr trtd height=〃23〃〉div align二〃center”〉img src=/，images/left.gif z/width=〃10〃height=10〃//div/tdtd height=〃23〃〉〈table width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=//0，/tr td height=〃20〃style=cursor:hand”onmouseover=/z this.style.borderStyle=solid，;this,style.borderWidth=f;borderCo lor=，#7bc4d3，;“onmouseout二〃this・style.borderStyle=none，〃span class二〃STYLE3〃Xa href=，/FleetSelectData2，z车队信息/a/span/td/tr/table/td/tr trtd height=〃23〃div align=〃center〃=/，zzimg srcimages/left.gif width=〃10〃height=〃10〃//div/tdtd height=〃23〃Xtable width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=，，0，，第39页，共61页tr td height=〃20〃style二〃cursor:hand”onmouseover=，，this.style.borderStyle=，solid，;this,style.borderWidth=，V jborderCo lor=，#7bc4d3，;“onmouseout二〃this,style.borderStyle=，none，〃〈span class二〃STYLE3〃a href=PassengerSelectData〃乘客信息/a〈/span/td/tr/table/td/tr trtd height=〃23〃〈div align二〃center”〉img src=z，images/left.gif width=〃10〃height=〃10〃//div/tdtd height=〃23〃table width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr td height=〃20〃style=cursor:hand”onmouseover=z，this.style.borderStyle=solid，;this.style.borderWidth=’1jborderCo lor=#7bc4d3,;“onmouseout二〃this・style.borderStyle=，none〃span class二〃STYLE3〃a href二〃UseSelectData”管理员信息〈/aX/span/td/tr/table/td/tr/table/td/tr tr td height=〃5〃〈inig src=/，images/main

52.gif〃width=〃151〃height=〃5〃//td/tr/table/div/td/tr/table/td/tr tr tdtable width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td height=〃23〃background二〃images/niain_

47.gif〃id=〃imgmenu2〃class=，，menu_title，z onmouseover=z，this.className=，menu_title2，;〃onclick=〃showsubmenu⑵〃onmouseout=〃this.className=，menu_title，;〃style=〃cursor:hand〃table width=〃100%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr td width=18%”nbsp;/td第40页，共61页td width=〃82%〃class=〃STYLEl〃发布公告/td/tr/table/td/tr tr td background=〃images/main

51.gif〃id=〃submenu2〃div class二〃secmenu”table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉tr tdtable width=〃90%〃border=〃0〃align二〃center”cellpadding二〃0〃cellspacing=〃0〃tr td width=〃16%〃height=〃25〃〉div align二〃center”〉img src=，z images/left.gif，z width=〃10〃height=〃10〃//div td width=〃84%〃height=〃23〃Xtable width=〃95%〃border二〃0〃cellspacing=〃0〃cellpadding=〃0〃〉tr td height=〃20〃style=cursor:hand”onmouseover=，，this.style.borderStyle=，solid;this.style.borderWidth=，1jborderCo lor=，#7bc4d3，;，，onmouseout=/，this.style.borderStyle=，none〃span class二〃STYLE3〃Xa href二〃AdSelectData”显示/a〈/spanX/td〉/tr/tableX/td/tr tr td height=〃23〃Xdiv align二〃center”〉img src二〃images/left.gif〃width=〃10〃height=〃10〃//div/td td height二〃23〃〉〈table width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr td height=〃20〃style二〃cursor:hand〃onmouseover二〃this,style.borderStyle=，solid;this,style.borderWidth=P;borderColor=，#7bc4d3，;“onmouseout二〃this・style.borderStyle=none，〃span class二〃STYLE3〃Xa href=addAd.jsp〃〉添加公告/aX/sparX/td/tr/table/td/tr/table/td/tr tr td height=〃5〃Ximg src=，，images/main_

52.gif，z width=〃151〃height二〃5〃//td/tr/table/div/td/tr/table/td第41页，共61页/tr tr tdtable width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td height=〃23〃background=，/images/main_

47.gif〃id=，/imgmenu3，/class=〃menu titleonmouseover二〃this.className=，menu_title2，;〃onclick=/，showsubmenu3，z onmouseout=，，this.className=，menu_title，;〃style=〃cursor:hand〉table width=〃100%〃border=〃0〃cellspacing=0〃cellpadding二〃0〃〉tr td width=〃18%〃nbsp;〈/td td width=82%class二〃STYLElXa href二〃Login.jsp〃〉退出登录/a/td/tr/table/td/tr tr td background二〃images/main_

51.gif〃id=〃submenu3〃style二〃DISPLAY:none/z Xdiv class=〃sec_menu〃table width=〃100%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr tdtable width=〃90%〃border=〃0〃align二〃center”cellpadding=〃0〃cellspacing=〃0〃/table/td/tr tr td height=〃5〃Ximg src=/，images/main_

52.gif〃width=〃151〃height=〃5〃//td/tr/table/div/td/tr/table/td/tr/table/td/tr tr td height=〃18〃background二〃images/main

58.gif〃table width=〃100%〃border二〃0〃cellspacing二〃0〃cellpadding=〃0〃tr td height=〃18〃valign二〃bottonTXdiv align二〃center〃class二〃STYLE3〃版本20xxV

1.0/divX/td/tr/table/td/tr/table/div div id二〃right”〉车队id1爱心车队第42页，共61页3牛逼车队第42页，共61页%request.setCharacterEncoding〃gb2312〃;%form action=〃DriverAddIata〃method=post enctype=，，multipart/form-data，/table width=〃60%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr td height=〃30〃background二〃images/tab

05.gif〃〈table width=〃100%border二〃0〃cellspacing二〃0〃cellpadding=〃0〃tr td width=〃12〃height=〃30〃〉img src=//images/tab

03.gif”width=〃12〃height=〃30〃//td tdtable width=〃90%〃border=〃0〃cellspacing=0〃cellpadding=，z0，ztr td width=〃55%〃valign=/，middle//table width=〃100%〃border二〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td width=〃5%〃〉div align二〃center〃Ximg src=〃images/tb.gif〃width=〃16〃height=〃16〃//div/td td width=〃75%〃c1ass=z，STYLEl，z span class=〃STYLE3〃〉你当前的位置/span［添加司机/td/tr/table/td tdwidth=〃80%〃〉〈table border=〃0〃align二〃right”cellpadding二〃0〃cellspacing=〃0〃〉tr/tr/table/td/tr/table/td=，/，z tdwidth=〃16〃Ximg srcimages/tab_

07.gif width=〃16〃height=〃30〃//td/tr/table/td/tr tr tdtable width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉tr tdwidth=〃8〃background=z，images/tab_

12.gif，z nbsp;/td tdtable width=〃100%〃border=〃0〃cellpadding=〃0〃cellspacing二〃1〃bgcolor=〃b5d6e6〃onmouseover=〃changeto〃onmouseout二〃changeback〃tr tdwidth=〃15%〃height=〃22〃background二〃images/bg.gif〃第43页，共61页bgcolor=，，#FFFFFF，，div align=，z center，z span class二〃STYLE1〃照片/span〈/divX/td tdwidth=/z100，input type=file name=〃file〃/〈/td/tr tr tdwidth=〃12%〃height=〃22〃background二〃images/bg.gif〃bgcolor=，z#FFFFFF，zdiv align=center〃Xspan class二〃STYLE1〃司机姓名/spanX/divX/td tdwidth=〃100〃Xinput type二〃text“name=〃d_name〃//td/tr trtdwidth=〃12%〃background二〃images/bg.gif〃bgcolor=〃#FFFFFF〃〉div align二〃center〃Xspan class=〃STYLEl〃联系电话〈/span〉/divX/tdtdwidth=，，100，z input type=〃text〃name=〃d_phone〃//td/tr trtdwidth=〃12%〃background=，z images/bg.gif〃bgcolor=〃#FFFFFF〃div align=，，center z/span class二〃STYLEl〃车牌号/span/divX/tdtdwidth=〃100〃〉input type二〃text“name=〃d_platenunT//td/tr trtdwidth=〃12%〃background二〃images/bg.gif〃bgcolor=〃#FFFFFF〃div align二〃center〃Xspan class二〃STYLE1〃车队编号/spanX/divX/tdtdwidth=〃100〃〉〈input type=text name=，，d_fleetid，z//td/trtr align=〃center”〉td colspan=〃2〃a href=，，Dri verSelectDataz，id=/，first/zinput type二〃button value=〃首页〃/〈/a〈/tdtd colspan=〃2〃b style=margin-right:100px;〃id=〃submit〉input type二〃submit〃//bX/td〉/tr/tableX/td tdwidth二〃8〃background二〃images/tab_

15.gif〃nbsp;/td/tr/table/td/tr/table/form/div/div/div/body/html%@page language二〃java〃import二〃java・util・*〃pageEncoding=〃gb2312〃%%第44页，共61页String path=request.getContextPath;第44页，共61页String basePath=request.getScheme+〃://z，+request.getServerName+〃:〃+request・getServerPort+p ath+”/〃;%!DOCTYPE HTMLPUBLIC〃-〃W3C〃DTD HTML

4.01Transitional//EN Z，html headbase href=，，%=basePath%z，title6,«/m公益车队爱心量化与点赞软件〈/title〉meta http-equiv二〃pragma〃content=//no-cache z，meta http-equiv=〃cache-control content=〃no-cache〃meta http-equiv二〃expires content=〃0〃meta http-equiv=〃keywords content=〃keywordl,keyword2,keyword3，zmeta http-equiv=〃description content=〃Thisismy page〃〈！一link rel二〃stylesheet“type二〃text/css〃href二〃styles.css〃一〉link href二〃css/addad.css〃rel二〃stylesheet“type二〃text/css〃，z z，script src=js/show.js X/script/head bodydiv id二〃mainDiv〃div id二〃topDiv〃h2Cai^公益车队爱心量化与点赞软件/h2〉div align二〃right”〉form action=z/SelectData，z method二〃get”input type二〃text“name=〃select/〉input type二〃submit value=〃查询〃/〉/form/div div id=z，tmenu z，!—表格上方—/div/div div id二〃centerDiv〃divid二〃left〃table width=〃165〃height=〃100%〃border=〃0〃cellpadding=〃20〃cellspacing=〃0〃tr td height=〃28〃background二〃images/main_

40.gif〃table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr tdwidth=“19%〃〉nbsp;/td tdwidth=81%height=〃20〃span class=STYLE1〃管理菜单/span〉/td/tr/table/td/tr tr td valign二〃top align二〃center”〉第45页，共61页pages=count/DriverData.size+1;System,err.printinDriverData.size=/，+DriverData.size;System.err.printin，，pages=z，+pages;}StringBuffer stringBuffer=new StringBuffer;for inti=l;i=pages;i++{if i==currpage{stringBuffer.append〃[〃+i+〃]〃;System.err.printin〃i=〃+i;}else{stringBuffer.append z，a href=，DriverSelectDatapage=〃+i+〃〃+i+〃〈/a〉〃;stringBuffer.append〃〃;System.err.printin〃i=〃+i;}request.setAttributez，bar/z,stringBuffer;request.setAttributecount”,count;request.setAttributepages”,pages;z，request.getRequestDispatchershowDriverData.jsp〃・forward request,response;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrowsServletException,lOException{response.setContentType〃text/html〃;PrintWriter out=response.getWriterO;out.println，z!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01Transitional//EN\，，/，;out.printin〈HTML〉“;out.printin〃HEADXT1TLEAServlet〈/TITLE〈/HEAD〃;out.printinz，BODY;out.printz/Thisis〃；out.print this.getClass;out.printinz，,using thePOST method;out.printin〃/B0DY〉〃;out.printin“〈/HTML〉“;out.flush;out.close;public voidinitthrowsServletException{//Put yourcode herepublic classDriverAddData extendsIlttpServlet{第5页，共61页table width=〃151〃border=〃0〃cellpadding=〃0〃cellspacing=〃0〃tr tdtable width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr=，/td height=〃23〃background images/main_

47.gif〃id=〃imgmenul〃class二〃menu title”onMouseOver二〃this.className=，menu_title2，;，z onClick二〃showsubmenu⑴〃onMouseOut=，，this.className=，menu_title，;〃style=cursor:hand〃table width=〃100%〃border=0〃cellspacing=〃0〃cellpadding=〃0〃tr tdwidth=“18%〃nbsp;/td tdwidth=〃82%〃class二〃STYLE/〉信息管理/td/tr/table/td/tr trtd background=〃images/main_

51.gif〃id=〃submenul”〉div class=〃sec_menu〃table width-100%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃〉tr tdtable width=〃90%〃border=〃0〃align=〃center〃cellpadding二〃0〃cellspacing=〃0〃〉tr tdwidth=〃16%〃height=〃25〃Xdiv align=，，center，，img src=，z images/left.gif〃width=〃10〃height=〃10〃//div/td tdwidth=〃84%〃height=〃23“〉table width=〃95%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉trtd height=〃20〃style二〃cursor:hand〃onmouseover=〃this,style.borderStyle=，solid，;this,style.border\Vidth=，1;borderColor=，#7bc4d3，;“onmouseout二〃this,style.borderStyle=，none〃span class二〃STYLE3〃Xa href二〃DriverSelectData〃司机信息/a〉〈/span/td/tr/table/td/tr trtd height=〃23〃div align二〃center”〉img src=/z images/left.gif，z width=〃10〃height=〃10〃//div/tdtd height=〃23〃〉（table width—95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃trtd height=〃20〃style二〃cursor:hand〃onmouseover二〃this style.borderStyle=，solid，;this,style.borderWidth=，T;borderColor=，#7bc4d3，;“onmouseout=〃this,style.borderStyle=，none〃第46页，共61页span class=/，STYLE3，，Xa href=，，FleetSelectData2z/车队信息/a/span/td/tr/tableX/td/tr trtd height=〃23〃〉〈div align二〃center”〉z，，zimg src=images/left.gif width=〃10〃height=〃10〃//div/tdtd height=〃23〃〉table width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃trtd height=〃20〃style二〃cursor:hand〃onmouseover二〃this・style.borderStyle=，solid，;this,style.borderWidth=1;borderColor=，#7bc4d3，;“onmouseout二〃this,style.borderStyle=none，〃Xspan class=〃STYLE3〃〉a href二〃PassengerSelectData〃乘客信息/a〈/spa,n/td/tr/table/td/tr trtd height=〃23〃div align二〃center”〉img src=/，images/left.gif width=〃10〃height=〃10〃//div/tdtd height=〃23〃table width=〃95%〃border二〃0〃cellspacing二〃0〃cellpadding=〃0〃trtd height=〃20〃style二〃cursor:hand〃onniouseover二〃this,style.borderStyle=，solid，;this,style.borderWidth=1;borderColor=，#7bc4d3，;“onmouseout二〃this・style.borderStyle=none，〃span class二〃STYLE3〃〈a href二〃UseSelectData”〉管理员信息/a/span/td/tr/table/td/tr/table/td/tr tr td height=〃5〃〈img src=，z images/main_

52.gif〃width=〃151〃height=5〃//td/tr/table/div/td/tr/table/td/tr tr第47页，共61页tdtable width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td height=〃23〃background=〃images/main_

47.gif〃id=〃imgmenu2〃class=〃menu_title〃onmouseover=，，this.className=，menu_title2，;〃one1i ck=，/showsubmenu⑵〃onmouseout=，，this.className=，menu_title，;〃style=cursor:hand〃table width=〃100%〃border二〃0〃cellspacing二〃0〃cellpadding=〃0〃tr tdwidth=18%”nbsp;/td tdwidth=〃82%〃class二〃STYLE/〉发布公告/td/tr/table/td/tr tr td background二〃images/main_

51.gif〃id=〃submenu2〃div class=〃sec_menu〃table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr tdtable width=〃90%〃border=〃0〃align二〃center”cellpadding=〃0〃cellspacing=〃0〃tr tdwidth=〃16%height=〃25〃〉div align二〃center”〉img src=，，images/left.gif，z width=〃10〃height=〃10〃//div tdwidth=“84%〃height=〃23〃Xtable width=〃95%border二〃0〃cellspacing=〃0〃cellpadding=〃0〃tr td height=〃20〃style二〃cursor:hand”onmouseover=//this.style.borderStyle=，solid，;this,style.borderWidth=，1;borderCo lor=，#7bc4d3;“onmouseout二〃this,style.borderStyle=，none，〃Xspan class二〃STYLE3Xa href=AdSelectData”〉显示/a〉/spanX/td/tr/table/td/tr tr td height=〃23〃Xdiv align二〃center”〉img src=z，images/left.gif z，width=〃10〃height=〃10〃//div/td td height=〃23〃Xtable width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃trtd height=〃20〃style=〃cursor:hand〃onniouseover二〃this,style.borderStyle=，solid，;this,style.borderWidth=，1;borderColor=，#7bc4d3;onmouseout=，，this.style.borderStyle=，none，z，Xspan class二〃STYLE3〃〈a href=，，addAd.jsp〃〉添加公告〈/a〉/span/td/tr/tableX/td/tr/table/td第48页，共61页/tr tr td height=〃5〃img src=/z images/main_

52.gif〃width=〃151〃height二〃5〃//td/tr/table/div/td/tr/table/td/tr tr tdtable width=〃100%〃border=0〃cellspacing=〃0〃cellpadding=〃0〃〉tr td height=〃23〃background二〃images/main_

47.gif〃id=〃imgnienu3〃class=〃menu titleonmouseover=，/this.className=，menu title2，;〃onclick=〃showsubmenu⑶〃onmouseout=，/this.className=，menu title，:style二〃cursor:hand〃table width=〃100%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr tdwidth=〃18%〃nbsp;〈/td〉tdwidth=〃82%〃class=〃STYLEl〃Xa href=Login.jsp〃〉退出登录/a/td/tr/table/td/tr tr td background=/，images/main_

51.gif〃id=〃submenu3〃style二〃DISPLAY:none〃〉〈div class=〃sec_menu〃table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉tr tdtable width=〃90%border』al ign=center”cellpadding二〃0〃cellspacing二〃0〃〉/table/td/tr tr td height=〃5〃〉inig src=z，images/main_

52.gif〃width=〃151〃height=〃5〃//td/tr/table/div/td/tr/table/td/tr/table/td/tr tr td height=〃18〃background二〃images/main_

58.gif〃table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉tr第49页，共61页tdheight=〃18〃valign=，，bottom，，Xdiv align二〃center〃class二〃STYLE3〃版本20xxV

1.0/divX/td/tr/tableX/td/tr/table/div divid二〃right〃负责人id为司机id%request.setCharacterEncoding（，，gb2312，/）;%form action=AdAddData method二〃get〃〉table width=〃60%〃border二〃0〃cellspacing=0〃cellpadding=〃0〃tr tdheight=〃30〃background=，z images/tab_

05.gif z，Xtable width=〃100%border二〃0〃cellspacing=〃0〃celIpadding=〃0”tr tdwidth=〃12〃height=〃30〃〉img src=z，images/tab_

03.gif/z width=〃12〃height=30〃//td tdtable width=100%border=0〃cellspacing=0〃cellpadding=〃0〃tr tdwidth=〃55%〃valign=，/middle，，Xtable width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr tdwidth=〃5%〃〉div align二〃center〃Ximg src=，，images/tb.gif，z width=〃16〃height=〃16〃//div/td z，tdwidth=〃95%〃class=STYLETXspan class=〃STYLE3〃〉你当前的位置〈/span〉［公告发布/td/tr/table/td tdwidth=“80%〃Xtable border=〃0〃align二〃right”cellpadding=0〃cellspacing=〃0〃〉tr/tr/table/td/tr/table/td tdwidth=〃16〃Ximg src二〃images/tab

07.gif〃width=〃16〃height=〃30〃//td第50页，共61页/tr第50页，共61页/table/td/tr tr tdtable width=〃100%〃border=〃0〃cel〔spacing二〃0〃cellpadding=〃0〃tr tdwidth二〃8〃background=/，images/tab_

12.gif z，nbsp;/td tdtable width=〃100%〃border=〃0〃cellpadding=〃0〃cellspacing二〃1〃bgcolor=〃b5d6e6〃onmouseover=/z changeto〃onmouseout=/，changeback“〉tr tdwidth=〃15%〃height=22〃background=images/bg.gif〃bgcolor=〃#FFFFFF〃div align=centerXspan class二〃STYLE].”〉公告标题〈/span〈/divX/td tdwidth=〃100〃Xinput type二〃text“name二〃//td/tr trtdwidth=〃12%〃height=〃22〃background=〃images/bg.gif〃bgcolor=〃#FFFFFF〃div align二〃center〃Xspan class二〃STYLE1〃〉公告内容/spanX/divX/td〉tdwidth=100textarea rows=〃5〃cols=〃20〃name=〃a_content〃/textarea/td/tr tralign二〃center”〉td colspan=〃2〃a href二〃AdSelectData id二〃first〃〈input type=button”value=〃首页〃/〈/a〉〈/td tdcolspan=〃2〃b style二〃margin-right:lOOpx;〃id=〃submit〉input type二〃submit7〈/bX/td〉/tr/table/td tdwidth=〃8〃background二〃images/tab_

15.gif〃〉nbsp;/td/tr/table/td/tr/table/form/div/div/div/body/html2源代码文件名\Fleet\WebRoot\addFleet.jsp import=passenger.PassengerData/z%%@page language二〃java〃import二〃java・util.*〃pageEncoding=，，gb2312，/%%String path=request.getContextPath;String basePath二request.getScheme+〃//z，+request.getServerName+〃:〃+request・getServerPort+p ath+〃/〃;%!DOCTYPE HTMLPUBLIC-//W3C//DTD HTML

4.01Transitional//EN/Zhtml第51页，共61页head第51页，共61页base href=，，%=basePath%z，title6,«/m公益车队爱心量化与点赞软件〈/title》meta http-equiv=〃pragma〃content=〃no-cache”〉meta http-equiv=cache-control content=〃no-cache”meta http-equiv二〃expires〃content=0〃〉meta http-equiv二〃keywords content=keywordl,keyword2,keyword3，zmeta http-equiv二〃description content二〃Thisismy page”〉〈!一link rel二〃stylesheet“type=text/css“href=styles.css〃〉一link href=，/css/showpassenger.css zzrel=〃stylesheet“type=〃text/css〃script src=/，js/show.js，z/script/head bodydivid二〃mainDiv〃divid二〃topDiv〃h2CH3公益车队爱心量化与点赞软件/h2div align二〃right〃form action二〃SelectData“method二〃get〃input type=〃text〃name二〃select/〉inputtype=〃submit value=〃查询〃/〉/form/div divid二〃tmenu〃〉!—表格上方—/div/div divid二〃centerDiv”〉divid=left〉〈table width=〃165〃height=〃100%〃border二〃0〃cellpadding=〃20〃cellspacing=〃0〃〉tr tdheight=〃28〃background二〃images/main

40.gif〃table width=〃100%〃border二〃0〃cellspacing二〃0〃cellpadding=〃0〃tr tdwidth=〃19%〃nbsp;〈/td tdwidth=“81%〃height=〃20〃span class二〃STYLE1〃管理菜单/spanX/td/tr/table/td/tr tr td valign=，，top，z align=center”〉table width=〃151〃border=〃0〃cellpadding=〃0〃cellspacing=〃0〃tr tdtable width=“100%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃tr tdheight=〃23〃background=〃images/main_

47.gif“id=〃imgmenul”class二〃menu title”onMouseOver二〃this.className=，menu_title2，;〃第52页，共61页onClick=，，showsubnienu1，z onMouseOut=，，this.className=，menu_title，;〃style二〃cursor:hand〃table width=，，100%z，border=〃0〃cellspacing=〃0〃cellpadding=〃0〃tr=，，z，tdwidth18%nbsp;/td tdwidth=〃82%〃class二〃STYLE/〉信息管理/td/tr/table/td/tr tr td background二〃images/main_

51.gif〃id=〃submenu1〃〉div class二〃secjnenu”table width=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdtable width=〃90%〃border=〃0〃align=〃center cellpadding=〃0〃cellspacing=〃0〃trtdwidth=〃16%〃height=〃25〃Xdiv align二〃center”〉img src=，，images/left.gif z，width=〃10〃height=〃10〃//div/td tdwidth=〃84%〃height=〃23〃table width=〃95%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃20〃style=cursor:hand”onmouseover=，/this.style.borderStyle=，solid，;this,style.borderWidth=，1;bordcrCo lor=，#7bc4d3，;，，onmouseout=，/this.style.borderStyle=，none〃span class二〃STYLE3〃Xa href=DriverSelectData〃司机信息/a〉/span/td/tr/table/td/tr trtdheight=〃23〃〉div align二〃center”〉img src二〃images/left.gif〃width=〃10〃height=〃10〃//div/tdtdheight=〃23〃Xtable width=〃95%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃20〃style二〃cursor:hand”onmouseover=，，this.style.borderStyle=，solid;this.style.borderWidth=，V jborderCo lor=，#7bc4d3，;“onmouseout二〃this,style.borderStyle=，none〃span class二〃STYLE3〃〈a href=，/FleetSelectData2，，车队信息/a/span/td/tr/table/td第53页，共61页public DriverAddDataO{super;}public voiddestroy{super.destroy;//Just puts〃destroy〃stringinlog//Put yourcode here}public voiddoGetHttpServletRequest request,HttpServletResponse responsethrowsServletException,lOException{response.setContentType〃text/html〃;PrintWriter out=response.getWriterO;out.print InC!DOCTYPE HTMLPUBLIC\〃-//W3C〃DTD HTML

4.01Transitional//EN\，zz，;out.printinZ，HTML Z，;out.printing HEADXTITLEAServlet/TITLE/HEAD，/;out.printinz，BODY〃;out.print/z Thisis〃；out.print this.getClass;out.printinz，,using theGET method;out.printin/z〈/B0DY〃;out.printin，，/HTML/，;out.flush;out.close;}public voiddoPostHttpServletRequest request,HttpServletResponse responsethrowsServletException,lOException{request.setCharacterEncoding，，gb2312，z;response.setCharacterEncoding，，gb2312/，;SmartUpload smartUpload=new SmartUploadO;Jdbc jdbc=new Jdbc;String root=request.getSession.getServletContext.getRealPath〃/〃;String savePath=root+〃image\\〃；String filename=null;try{smartUpload.initializegetServletConfig,request,response;smartUpload.setAllowedFilesListz，png,jpg,ico〃;smartUpload.upload;smartUpload.savesavePath;filename=smartUpload.getFiles.getFile

0.getFilePathName;System.err.print Inz，f i lename^^+f ilename;Stringdname=smartUpload.getRequest.getParameterz，dname;long z，z，d_phone=Long.valueOf smartUpload.getRequest.getParameterd_phoneInt d_fleetid=Integer.valueOf smartUpload.getRequest.getParameter，z d_f leetid，z;S tringd_platenum=smartUpload.getRequest.getParameter//d_platenum，/;第6页，共61页/tr trtdheight=〃23〃div align二〃center”〉img src=z images/left.gif，z width=〃10〃height=〃10〃//div/tdtdheight=〃23〃〉〈tablewidth=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃trtdheight=〃20〃style=cursor:hand”onmouseover=/，this.style.borderStyle=，solid，;this,style.borderWidth=，1;borderColor=，#7bc4d3;，/onmouseout=z/this.style.borderStyle=，none，，z span class二〃STYLE3〃a href二〃PassengerSelectData”〉乘客信息/a〉〈/span/td/tr/table/td/tr trtdheight=〃23〃div align二〃center”〉img src=z，images/left.gif z，width=〃10〃height=〃10〃//div/tdtdheight=〃23〃〈tablewidth=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃〉trtdheight=〃20〃style=cursor:hand”onmouseover=，/this.style.borderStyle=，solid，;this,style.borderWidth=，1;borderColor=，#7bc4d3，;，/onmouseout=，，this.style.borderStyle=，none，z，Xspan class二〃STYLE3〃a href二〃UseSelectData”〉管理员信息/a〈/span/td/tr/table/td/tr/tableX/td/tr trtdheight=〃5〃〉〈inig src=/z images/main_

52.gif〃width=〃151〃height=5〃//td/tr/table/div/td/tr/table/td/tr trtdtable width=，，100%z，border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃23〃background=〃images/main_

47.gif〃id=〃imgmenu2〃class=//menu_title，z第54页，共61页onmouseover=，，this.className=，menu_title2，;〃one1i ck=z/showsubmenu⑵〃onmouseout=，，this.className=，menu_title，;〃style=〃cursor:hand〃tablewidth=“100%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃trtdwidth=“18%〃nbsp;/td〉tdwidth=〃82%〃州5二欠丁丫1^1〃〉发布公告/1€1/tr/table/td/tr trtd background=〃images/main_

51.gif〃id=〃submenu2〃divclass=〃sec_menu〃tablewidth=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdtablewidth=〃90%〃border=〃0〃align二〃center”cellpadding=〃0〃cel1spacing=〃0〃〉trtdwidth=〃16%〃height=25div align二〃center”〉img sre二〃images/left.gif〃width=〃10〃height=〃10〃//div tdwidth=“84%〃height=〃23〃Xtable width=〃95%border二〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃20〃style=cursor:hand”onmouseover=，/this.style.borderStyle=，solid，;this,style.borderWidth=，1;bordcrCo lor=，#7bc4d3，;“onmouseout二〃this,style.borderStyle=，none，〃span class二〃STYLE3”〈a href=AdSelectData〃显示/a〉/span〉〈/td/tr/table/td/tr trtdheight=〃23〃Xdiv align二〃center”〉img sre二〃images/left.gif〃widlh=〃10〃height=〃10〃//div/td tdheight=〃23〃Xtable width=〃95%〃border=〃0〃cellspacing二〃0〃cellpadding=〃0〃trtdheight=〃20〃style二〃cursor:hand”onmouseover=，，this.style.borderStyle=，solid，;this.style.borderWidth=，V jborderColor=#7bc4d3;“onmouseout=〃this,style.borderStyle=，none〃〈span class二〃STYLE3〃Xa href二〃addAd.jsp〃添加公告/a/spanX/td〉/tr/tableX/td/tr/table/td/tr trtdheight二〃5〃Ximg sre二〃images/main

52.gif“width=〃151〃height二〃5”第55页，共61页//td/tr/table/div/td/tr/table/td/tr trtdtablewidth=〃100%〃border=0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃23〃background二〃images/main_

47.gif〃id=〃imgmenu3〃class=〃menu titleonmouseover=this.className=，menu title2，;〃one1ick=/，showsubmenu⑶〃onmouseout=this.className=，menu title，;〃style二〃cursor:hand〃tablewidth=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdwidth=〃18%〃nbsp;〈/td〉tdwidth=82%class二〃STYLEl〃Xa href=Login.jsp〃退出登录/a/td/tr/table/td/tr trtd background=/，images/main_

51.gif〃id=〃submenu3〃style二〃DISPLAY:none^Xdiv class=〃sec_menu〃tablewidth=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉trtdtablewidth=〃90%〃border=〃0〃align=center”cellpadding=〃0〃cellspacing=〃0〃/table/td/tr trtdheight=〃5〃Xinig src=//images/main_

52.gif〃width=〃151〃height=〃5〃//td/tr/table/div/td/tr/table/td/tr/table/td/tr trtdheight=〃18〃background二〃images/main

58.gif〃〉tablewidth-100%〃border二〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃18〃valign二〃bottom〃〉〈div align二〃center〃class=〃STYLE3〃版本20xxV

1.0/divX/td/tr/table/td第56页，共61页/tr/table/div divid二〃right〃tablewidth=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdheight=〃30〃background=，，images/tab_

05.gif^Xtable width=〃100%border二〃0〃cellspacing二〃0〃cellpadding=〃0〃trtdwidth=〃12〃height=〃30〃〉img src=//images/tab

03.gif”width=〃12〃height=30〃//td tdtablewidth=〃100%〃border=〃0〃cellspacing二〃0〃cellpadding=//0，ztrtdwidth=〃20%valign=//middle，，Xtable width=〃100%”border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdwidth=〃5%〃〉div align二〃center〃Ximg src=z，images/tb.gif z，width=16〃height=〃16〃//div/td tdwidth=〃95%〃class二〃STYLEl〃Xspan class二〃STYLE3〃你当前的位置/span［乘客信息］〈/td/tr/table/td tdwidth=〃80%〃〈table border=〃0〃align=right”cellpadding=〃0〃cellspacing=〃0〃trtdwidth=/，60，，Xtable width=〃90%〃border二〃0〃cellpadding=〃0〃cellspacing=〃0〃tr/tr/table/td/table/td/table/td/tr/table/td/tr/table/td/tr/table/td/tr trtdtablewidth=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃trtdwidth=〃8〃background二〃images/tab_

12.gif〃〉nbsp;〈/td tdtablewidth=〃100%〃border=〃0〃cellpadding=〃0〃cellspacing二〃1〃bgcolor=〃b5d6e6〃onmouseover二〃changeto〃onmouseout二〃changeback〃〉trtdwidth=〃12%〃height=〃22〃background二〃images/bg.gif〃bgcolor=〃#FFFFFF〃div align^^center^Xspan class=〃STYLE1〃司机〈/spanX/div/td tdwidth=〃15%〃height=〃22〃background=〃images/bg.gif〃第57页，共61页bgcolor=，，#FFFFFF，，div align=，，center，z span:1@55=〃5丁丫［^1〃〉乘客姓名/spanX/div/td tdwidth=“15%〃height=〃22〃background=images/bg.gif〃bgcolor=/z#FFFFFF，zdiv align=，z centerzz span class二〃STYLE1〃乘客照片/span〉〈/div〈/td tdwidth=〃12%〃height=〃22〃background=7images/bg.gif〃bgcolor=〃#FFFFFF〃div align=/z center，z span class二〃STYLE!.”〉乘客电话〈/span/div/td tdwidth=〃12%〃background二〃images/bg.gif〃bgcolor=/，#FFFFFF，，div align=center〃Xspan class二〃STYLE1/》事件描述/span〈/divX/tdtdwidth=〃12%〃height=〃22〃background二〃images/bg.gif〃/z/z bgcolor=#FFFFFFdiv align=center〃Xspan class二〃STYLE!/〉提交时间/span〈/divX/tdtdwidth=〃15%〃height=〃22〃background=〃images/bg.gif〃bgcolor=〃#FFFFFF〃class=〃STYLE1〃div align=“©611161〃》基本操作《/3爪〉/1!/tr%ListPassengerData list二ListPassengerData»request.getAttribute，，listPassenger，/;if list!=null{forPassengerData passengerData:1ist{%trtdheight=50〃bgcolor=〃#FFFFFF〃div align二〃center”〉span class=z，STYLEl，，X%=passengerData.getD name%/span/div/tdtdheight=〃50〃bgcolor=/z#FFFFFF/zdiv align二〃center”〉span class二〃STYLE1〃X%=passengerData.getP_name%/span/div/td tdheight=〃50〃bgcolor=〃#FFFFFF〃〉div align二〃center”〉spanclass二〃STYLEl〃〉inig src=〃%〃width=〃160px〃height=〃150px〃/span/div/td tdbgcolor=〃#FFFFFF〃〉div align=center”〉spanclass=，，STYLEr，X%=passengerData.getP_phone%/span/div/td第58页，共61页tdheight=〃50〃bgcolor=z，#FFFFFF/，div align=〃center”〉textarea rows=〃8〃cols=，，28，，X%=passengerData.getP_content%/textarea/div/td tdheight=50〃bgcolor=/，#FFFFFF，，div align二〃center”〉spanclass=/，STYLEl z，%=passengerData.getDate%/span/div/td tdheight=〃50〃bgcolor=z/#FFFFFF z，div align二〃center”〉spanclass二〃STYLE4〃〉img src二〃images/del.gif〃width=〃16〃height=〃16〃/a href=//PassengerDeleteid=%=passengerData.getP id%”删除/a〉/span/div/td/tr%%/table/td tdwidth=〃8〃background=，/images/tab_

15.gif，z nbsp;/td/tr/table/td/tr trtdheight=〃35background二〃images/tab_

19.gif〃tablewidth=〃100%〃border=〃0〃cellspacing=〃0〃cellpadding=〃0〃〉trtdwidth=〃12〃height=〃35〃Xinig src=z images/tab_

18.gif z/width=〃12〃height=〃35//td tdtablewidth=〃100%〃border二〃0〃cellspacing=〃0〃cellpadding二〃0〃〉trtdclass二〃STYLE4〃nbsp;nbsp;共有%=request.getAttribute^countPassenger^%条记录，共^mrequest.getAttribute〃pagesPassenger〃%页/td tdtableborder二〃0〃align二〃right cellpadding=〃0〃cellspacing=〃0〃trtdwidth=〃40〃〈a href=/PassengerSelectData/z img src=/，images/first.gif/z width=〃37〃height=〃15//a/td tdwidth=〃45〃%=request.getAttribute/z barPassenger/z%/td tdwidth=〃100〃〉〈div align二〃center”〉第59页，共61页spanclass=〃STYLEl〃转到第input name二〃textfield〃type二〃text“size=4〃style=/，height:12px;width:20px;border:Ipx solid#999999;〃/页/span/div/td tdwidth=〃40〃imgsrc二〃images/go.gif〃width=〃37〃height=〃15〃//td/tr/table/td/tr/table/td tdwidth=〃16〃Ximg src=，/images/tab_

20.gif〃width=〃16〃height=〃35〃//td/tr/table/td/tr/table/div/div/div/body/html%@page language二〃java import二〃java・util・*〃pageEncoding=〃gb2312〃%〉%String path=request.getContextPath;String basePath=request.getScheme+〃://〃+request・getServerName+〃:〃+request・getServerPort+p ath+/〃；%!DOCTYPE HTMLPUBLIC，Z-//W3C//DTD HTML

4.01Trans itional//EN html headbase href=z/%=basePath%z/title6，am公益车队爱心量化与点赞软件〈/title》meta http-equiv=〃pragma content=〃no-cache〃meta http-equiv二〃cache-control〃content=〃no-cache〃meta http-equiv二〃expires content=〃0〃〉meta http-equiv二〃keywords content=〃keywordl,keyword2,keyword3〃meta http-equiv二〃description content二〃Thisismy page，z!一link rel二〃stylesheet“type二〃text/css〃href=styles.css〃〉一/head body%response.sendRedirect^DriverSelectData^;%import二〃czqy.DriverData，z%%@page language二〃java import二〃java・util・*〃import二〃czqyl.Alldata〃%%String path二request.getContextPath;String basePath=request.getScheme+〃〃〃+request.getServerName+〃:〃+request.getServerPort第60页，共61页+path+〃/〃；％!DOCTYPE HTMLPUBLIC〃-〃W3C〃DTD HTML

4.01Transitional//EN，，htmlheadbasehref=，，%=basePath%，ztitle6,^/m公益车队爱心量化与点赞软件meta name=〃viewport content=width=device-width,initial-scale=l〃meta http-equiv二〃pragma content=〃no-cache〃meta http-equiv二〃cache-control“content=〃no-cache〃meta http-equiv二〃expires content=〃0〃〉meta http-equiv二〃keywords content=〃keywordl,keyword2,keyword3z，meta http-equiv二〃cache-control content=〃no-cache〃meta http-equiv二〃description content=〃Thisismy page〃〈！一link rel二〃stylesheet“type二〃text/css〃href=styles.css〃〉一〉script src=/，js/news.js z，/script linkhref=〃css/style.css〃rel=〃stylesheet“type二〃text/css〃〉/head bodyjsp:useBean id二〃driver class=〃czqyl.DriverData scope=page〉/jsp:useBean divclass二〃gridContainer clearfix，zbr divid二〃title align二〃center”style二〃font-size:28px;color:red;font-weight:bold;〃信息已经提交！谢谢使用！/div brdivid二〃new style=font-size:20px;〃〉script language=〃JavaScript“type=/z text/JavaScript z，src=〃/divbr divstyle二〃font-size:20px〃〉br项目指导:〈a href二〃href二〃所属单位:ahref二〃id=version align二〃center〃style=〃padding-top:8px;〃〉Copyright©20x xCalmLab/div/div/body/html第61页，共61页System.err.printlnd_fleetid+d_name+d_phone+filename;//jdbc.insert filename,name,sex,age,address,fleet;//插入至ij数据库jdbc.insertfilename,d_name,d_phone,d_fleetid,d_platenum;}catch Exceptione{//TODO:handle exception}response.sendRedirect/，DriverSelectData，/;public voidinit throwsServletException{//Put yourcode herepublic classDriverDelete extendsHttpServlet{public DriverDelete{super;/***Destruction ofthe servlet.br*/public voiddestroy{super,destroy;//Just puts“destroy“stringinlog//Put yourcode here}public voiddoGetHttpServletRequest request,HttpServletResponse responsethrowsServletException,lOException{request.setCharacterEncoding，z gb2312，z;response.setCharacterEncoding z，gb2312z，;int id=Integer.valueOf request.getParameterz，id/z；Jdbc jdbc=newJdbc;String sql=delete fromdriver whered_id二？〃；Connectionconnection=jdbc.getConnectionO;/*try{PreparedStatement preparedStatement=PreparedStatement connection.prepareStatementsql;preparedStatement.setlnt1,id;preparedStatement.executeUpdate;System,err.printin〃删除成功〃;preparedStatement.close;connection,close;}catch Exceptione{//TODO:handle exceptione.printStackTrace;}//response.sendRedirect，z DriverSelectData z，;*/try{System.err.println/z ssz/;PreparedStatement preparedStatement第7页，共61页=PreparedStatement connection.prepareStatementsql;preparedStatement.setlnt1,id;int row=preparedStatement.executeUpdate;}catch Exceptione{//TODO:handle exceptione.printStackTrace;}System,err.printlnid;response.sendRedirectz，DriverSelectData，z;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrowsServletException,lOException{response.setContentType，，text/html/，;PrintWriter out=response.getWriterO;out.print In/z!DOCTYPE HTMLPUBLIC\ZZ-//W3C//DTD HTML

4.01Transitional//EN\，zz，;out.printinZ，HTML Z，;out.printing HEADXTITLEAServlet/TITLEX/HEAD，/;out.printinz，BODY〃;out.print，z Thisis〃；out.print this.getClass;out.printinz，,using thePOST method;out.printin，z/B0DY〃;out.printin，，/HTML/，;out.flush;out.close;}public voidinit throwsServletException{//Put yourcode herepublicclassDriverSave extendsHttpServlet{public DriverSave{super;}public voiddestroy{super.destroy;//Just putsdestroy“stringinlog//Put yourcode here}public voiddoGet HttpServletRequestrequest,HttpServletResponse responsethrowsServletException,lOException{response.setContentType〃text/html〃;PrintWriter out=response.getWriterO;out.print InC!DOCTYPE HTMLPUBLIC\Z，-//W3C//DTD HTML

4.01Transitional//EN\，zz，;第8页，共61页out.printin〈HTML〉“;out.printin〃HEAIXTITLEA Servlet/TITLEX/HEAD Z，;out.printin〃BODY;out.printz，Thisis〃；out.print this.getClass;out.printinz，,using theGET method;out.printin〃〈/BODY〉“;out.printin“〈/HTML〉“;out.flush;out.close;public voiddoPostHttpServletRequest request,HttpServletResponse responsethrowsServletException,lOException{/z/z request.setCharacterEncoding gb2312;response.setCharacterEncoding/zgb2312/z;SmartUpload smartUpload=new SmartUpload;Jdbc jdbc=newJdbc;String root=request.getSession.getServletContext.getRealPath^/^;String savePath=root+〃image\\〃；String filename=null;trysmartUpload.initializegetServletConfig,request,response;smartUpload.setAllowedFilesListz，png,jpg,ico〃;smartUpload.upload;smartUpload.savesavePath;filename二smartUpload.getFilesO.getFileO.getFilePathName;System,err.print In，z filename=/，+filename;Stringd_name二smartUpload.getRequest.getParameter，，d_name，/;long d_phone=Long.valueOf smartUpload.getRequest.getParameter，，d_phone,，int d_fleetid=Integer.valueOf smartUpload.getRequest.getParameter，，d_fleetid，z;Stringdplatenum=smartUpload.getRequest.getParameter/，d_platenu^l，，;int id=Integer.valueOf smartUpload.getRequest.getParameter;System,err.prin11nd_f1eetid+d_name+d_phone+fi1ename+id;newJdbc.updatad_fleetid,id,d_name,d_phone,d_platenum,filename;}catch Exceptione{//TODO:handle exceptione.printStackTrace;response.sendRedirect，z DriverSelectDataz/;}public voidinitthrowsServletException{//Put yourcode here第9页，共61页。