1、% String sql=select * from student order by id; java.util.List list=sBean.getSearch(sql); for(Iterator it=list.iterator();it.hasNext();) /获得JavaBean的一个对象 jBean=(com.jq92.bean.JavaBean)it.next(); % %=jBean.getName() %=jBean.getPassword() %=jBean.getSex() %=jBean.getAge() %a href=Delete?id=删除 Sea
2、rchById?更新/tableInsert.jsp返回Update.jsp font size=7 color=red您要更新的数据如下:form action=Update method=posttable border=1 readonly姓名:name密码:input type=password name=性别:radiosex男man男女woman女年龄:textagetd colspan=2submit更 新reset重 置/formSearchList.jsp查询Insert.jsp92期学院管理页面Insert提 交Error.jsp 对不起,您0) url= elseErro
3、r.jsp request.setAttribute(, 更新 request.getRequestDispatcher(url).forward(request, response); SearchById.java /获得idselect * from student where id=? JavaBean jBean=sBean.getSearchById(sql, id); /ID request.setAttribute(, jBean.getId(); /姓名,jBean.getName(); /密码, jBean.getPassword(); /性别 String sex= St
4、ring man= String woman= if(jBean.getSex()!=null) sex=jBean.getSex().trim(); if(sex.equals() man=checked else woman= ,man);,woman); /年龄, jBean.getAge(); /转发 request.getRequestDispatcher(Update.jsp).forward(request, response);Insert.java throws ServletException, IOException /获取前台页面信息 /封装到JavaBean对象中 c
5、om.jq92.bean.JavaBean jBean=new com.jq92.bean.JavaBean(); /调用模型层insert into student values(?,?) int count=sBean.getInsert(sql, jBean);,注册Delete.java /获得删除超链接传来的参数 String sId=request.getParameter( int id=Integer.parseInt(sId); /调用模型层删除方法delete from student where id=? int count=sBean.getDelete(sql, id
6、);删除JavaBean.javapackage com.jq92.bean;public class JavaBean private int id; private String name; private String password; private String sex; private int age; public int getAge() return age; public void setAge(int age) this.age = age; public int getId() return id; public void setId(int id) this.id
7、= id; public String getName() return name; public void setName(String name) this.name = name; public String getPassword() return password; public void setPassword(String password) this.password = password; public String getSex() return sex; public void setSex(String sex) this.sex = sex;SqlBean.javai
8、mport java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;public class SqlBean Connection con; PreparedStatement pre; ResultSet rs; public SqlBean() try Class.forNa
9、me(com.microsoft.jdbc.sqlserver.SQLServerDriver catch (ClassNotFoundException e) / TODO 自动生成 catch 块 e.printStackTrace(); con=DriverManager.getConnection(jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=jq92Model2sa catch (SQLException e) public int getInsert(String sql,JavaBean jBean) int coun
10、t=0; pre=con.prepareStatement(sql); pre.setString(1,jBean.getName(); pre.setString(2,jBean.getPassword(); pre.setString(3, jBean.getSex(); pre.setInt(4, jBean.getAge(); count=pre.executeUpdate(); finally try pre.close(); con.close(); catch (SQLException e) / TODO 自动生成 catch 块 e.printStackTrace(); re
11、turn count; public int getDelete(String sql,int id) pre.setInt(1, id); public JavaBean getSearchById(String sql,int id) rs=pre.executeQuery(); while(rs.next() jBean.setId(rs.getInt(); jBean.setName(rs.getString( jBean.setPassword(rs.getString( jBean.setSex(rs.getString( jBean.setAge(rs.getInt( return jBean; public int getUpdate(String sql,JavaBean jBean) pre.setString(2, jBean.getPassword(); pre.setInt(5, jBean.getId(); publ
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1