Jsp宠物医院实训小结1、兽医信息的查询用到的是将输入的兽医姓名或者专业通过Searchdocservlet得到在Searchdocservlet调用查询方法得到list再转发到页面。
Servlet代码如下：public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, lOException {response.setContentType( "text/html;charset=GBK" );String name3=request.getParameter( "name1");String name4=request.getParameter( "name2");if (name3!= null &&!name3.equals( "" )){byte str[]=name3.getBytes( "ISO-8859-1" );String strname= new String(str, "GBK");Getvets ve = new Getvets();List list=ve.getvets1(strname);request.setAttribute( "temp",list);request.getRequestDispatcher( "vetsresult.jsp" ).forward(request, response);}else if (name4!= null &&!name4.equals( "" )){byte str1[]=name4.getBytes( "ISO-8859-1" );String strname1 =new String(str1, "GBK");Getvets ve = new Getvets();List list=ve.getvets2(strname1);request.setAttribute( "temp",ist);request.getRequestDispatcher( "vetsresult.jsp" ).forward(request, response);}} 数据库操作方法如下：public class Getvets {当用户只输入兽医姓名public List getvets1(String Name){List list= new ArrayList(); DBConnect co= new DBConnect(); Connection conn=co.getConnection();String sql= "select s1.id, pets, pos from vets s1,specialtiess2,vet_specialtiess3 where s1.id=s3.vet_idand s2.id=s3.specialty_idtry {Statement st=conn.createStatement(); ResultSet rs=st.executeQuery(sql); while (rs.next()){ Vets vet= new Vets(); vet.setld(rs.getlnt("id"));vet.setName(rs.getString( "pets" )); vet.setSname(rs.getString( "pos"));list.add(vet); }} catch (SQLException e){e.printStackTrace();}return list;}当用户只输入兽医专业public List getvets2(String Name){List list= new ArrayList(); DBConnect co= new DBConnect(); Connection conn=co.getConnection();String sql= "select s1.id, pets, pos from vets s1,specialtiess2,vet_specialtiess3 where s1.id=s3.vet_idand s2.id=s3.specialty_idand ='"try {System. out .print(sql);Statement st=conn.createStatement(); ResultSet rs=st.executeQuery(sql); while (rs.next()){ Vets ss= new Vets(); ss.setld(rs.getlnt("id"));ss.setName(rs.getString( "pets")); ss.setSname(rs.getString( "pos"));list.add(ss);} } catch (SQLException e){e.printStackTrace();}return list;查询结果是:and ='"+Name+"'"+Name+"'"姓名专业马上奸放射科马上好內科I垂新世询7善医信息查询成功2、查询所有主人信息宠物主人信息查询主人编号主人名字主人地址主人城帀王人电话1GectEE Franklin110险・常州6085551023^-改册1除Liberty St-2王先生&38 Cardinal6085551749^ 改删除Ave.首页前一贝后一页当前第顶总计5頁题用到的是用servlet :Fengyeserv调用Feng Ye中的分页方法得到list显示在页面viewallowners.jsp上Servlet代码如下：public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, lOException {response.setContentType( "text/html;charset=GBK" );PrintWriter out = response.getWriter();FengYe dao= new FengYe();int intpage=Integer. parseInt (request.getParameter( "page"));Fengye pagebean=dao.getit(intpage);request.setAttribute( "bean" ,pagebean);}分页方法如下:public class FengYe {public Fengye getit( int page){List list= new ArrayList();Fengye pagebean= new Fengye();int maxrows= this .getcount();pagebean.setMaxRowCount(maxrows);int maxpages=0;if (maxrows%pagebean.getRowsPerPage()==0)maxpages=maxrows/pagebean.getRowsPerPage();else {maxpages=maxrows/pagebean.getRowsPerPage()+1;}pagebean.setMaxPage(maxpages);pagebean.setCurPage(page);//listDBConnect dbconn= new DBConnect();Connection conn=dbconn.getConnection();int rowBegin=pagebean.getRowsPerPage()*(page-1);String sql = "select top " +pagebean.getRowsPerPage()+ top " + rowBegin +" id from owners)" ;try {Statement stam=conn.createStatement();from owners where id not in(selectResultSet rs=stam.executeQuery(sql);while (rs.next()){Owners bean= new Owners();bean.setld(rs.getlnt( "id" bean.setName(rs.getString( bean.setAd dress(rs.getString( bean.setCity(rs.g etString( bean.setTelephone(rs.getStr ing( ));"name"));"address")); "city"));"telephone" ));list.add(bean);pagebean.setList(list);} } catch (SQLException e) {e.printStackTrace();} return pagebean;}public int getcount(){int result=0;DBConnect dbconn= new DBConnect();Connection conn=dbconn.getConnection();try {String sql= "select count(*)as sum from owners"Statement stm=conn.createStatement();ResultSet rs=stm.executeQuery(sql); while (rs.next()){result=rs.getlnt( "sum");}} catch (SQLException e){e.printStackTrace();}return result;3、增加宠物主人爱心宠物诊所用到的是InsertOwnerservlet调用Insertowners中的方法，将填入的数据插到数据库中Servlet代码如下：public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType( "text/html;charset=GBK" );PrintWriter out = response.getWriter();String name=request.getParameter( "owname");byte str[]=name.getBytes(String ow= new String(str,String add=request.getParameter( byte str1[]=add.getBytes(String addr= new String(str1, String city=request.getParameter( byte str2[]=city.getBytes(String cityt= new String(str2, String tele=request.getParameter( byte str3[]=tele.getBytes( "ISO-8859-1" ); "GBK");"address"); "ISO-8859-1" );"GBK");"city");"ISO-8859-1" );"GBK");"telephone" ); "ISO-8859-1" );String telet= new String(str3, "GBK");Owners owe= new Owners(ow,addr,cityt,telet);Insertowners in= new Insertowners();if (in.inowners(owe)>0)request.setAttribute(elserequest.setAttribute( reques t.getRequestDispatcher( }插入数据库方法如下：public class Insertowners {"temp","宠物主人信息添加成功！”)；"temp","宠物主人信息添加失败！”)；"Fengyeserv?page=1" ).forward(request, response);public int inowners(Owners pag){int temp=0;String sql= "insert into owners values(?,?,?,?)"DBConnect dbconn= new DBConnect();Connection conn=dbconn.getConnection();try {PreparedStatement stm=conn.prepareStatement(sql);stm.setString(1,pag.getName());stm.setString(2,pag.getAddress());stm.setString(3,pag.getCity());stm.setString(4,pag.getTelephone());temp=stm.executeUpdate();} catch (SQLException e){e.printStackTrace();}return temp;插入数据如下图所示:爱心宠物诊所插入数据结果如下图所示:4、修改宠物主人点击修改后到OwnerListservlet调用GetownerbyName中的方法，根据指定的姓名查找到相应的主人信息，用list保存，并转发到ownerinformation.jsp 页面显示出来Servet OwnerListservlet 代码如下：public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType( "text/html;charset=GBK" );PrintWriter out = response.getWriter();String Name=request.getParameter( "name");byte str[]=Name.getBytes( "ISO-8859-1" );String strname= new String(str, "GBK");GetownerbyName go= new GetownerbyName。
