1、com.jq92.bean.JavaBean% 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
2、=Delete?id=删除 SearchById?更新/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
3、 对不起,您0) url= elseError.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
4、(); /性别 String sex= String 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 /获取前台
5、页面信息 /封装到JavaBean对象中 com.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=s
6、Bean.getDelete(sql, id);删除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
7、setId(int id) this.id = 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.s
8、ex = sex;SqlBean.javaimport 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 Sql
9、Bean() try Class.forName(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,Ja
10、vaBean jBean) int count=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
11、.printStackTrace(); return 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();
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1