JSP:
<html>
<head>
<title>登录</title>
<style type="text/css">
table{
color: blue;
font-weight: bold;
text-align: center;
border-color: #C1DCF9;
}
</style>
</head>
<body>
<form action="<%=request.getContextPath()%>/equipOut.do" method="post">
<table border="1">
<tr>
<td>客户编号</td>
<td><input type="text" name="userno"></td>
<td>客户名称</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>经办人</td>
<td><input type="text" name="people"></td>
<td>出库日期</td>
<td><input type="text" name="date"></td>
</tr>
<tr>
<td>设备编号</td>
<td>设备种类</td>
<td>备注</td>
<td>操作</td>
</tr>
<tr>
<td><input type="text" name="equipno"/></td>
<td></td>
<td><input type="text" name="beizhu"></td>
<td><a href="#">删除</a></td>
</tr>
<tr>
<td colspan="3"></td>
<td><a href="#">添加</a></td>
</tr>
<tr>
<td colspan="4" class="a"><input type="submit" value="保存">
</td>
</tr>
</table>
</form>
</body>
</html>
DAO:
public class EquipOutDao extends BaseDao{
public int insertout(EquipOut e){
String select="insert into outku values(?,?,?,?,?,?)";
List<Object> params=new ArrayList<Object>();
params.add(e.getUserno());
params.add(e.getUsername());
params.add(e.getPeople());
params.add(e.getOutdate());
params.add(e.getEquipno());
params.add(e.getBeizhu());
return this.executeUpdate(select, params);
}
}
实体类：
public class EquipOut {
private String userno;
private String username;
private String people;
private String outdate;
private String equipno;
private String beizhu;
public String getUserno() {
return userno;
}
public void setUserno(String userno) {
this.userno = userno;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPeople() {
return people;
}
public void setPeople(String people) {
this.people = people;
}
public String getOutdate() {
return outdate;
}
public void setOutdate(String outdate) {
this.outdate = outdate;
}
public String getEquipno() {
return equipno;
}
public void setEquipno(String equipno) {
this.equipno = equipno;
}
public String getBeizhu() {
return beizhu;
}
public void setBeizhu(String beizhu) {
this.beizhu = beizhu;
}
public EquipOut(String userno, String username, String people, String outdate,
String equipno, String beizhu) {
super();
this.userno = userno;
this.username = username;
this.people = people;
this.outdate = outdate;
this.equipno = equipno;
this.beizhu = beizhu;
}
public EquipOut() {
super();
// TODO Auto-generated constructor stub
}
SERVICE:
public class EquipOutService {
EquipOutDao eod=new EquipOutDao();
public int insertout(EquipOut e){
return eod.insertout(e);
}
}
SERVLET:
public class EquipOutServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
String userno=req.getParameter("userno");
String username=req.getParameter("username");
String people=req.getParameter("people");
String outdate=req.getParameter("outdate");
String equipno=req.getParameter("equipno");
String beizhu=req.getParameter("beizhu");
EquipOutService eos=new EquipOutService();
EquipOut eo=new EquipOut(userno, username, people, outdate, equipno, beizhu);
int a=eos.insertout(eo);
if(a>0){
resp.sendRedirect(req.getContextPath()+"/tiaozhuan/Success.jsp");
}else{
resp.sendRedirect("http://www.baidu.com");
}
}
}