本系列博客汇总在这里:企业信息管理系统汇总
用户保存
新建 add.jsp 文件
处理 toadd.jsp 表单传递过来的数据,源码见附件一。
修改数据库
对于之前我们建立的数据库需要做出一点点修改。
效果图
注意:生日必须按照日期格式录入,如:2001-1-1。
附件
附件一
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<%@page import="com.wyx.ces.*" %>
<%@page import="com.wyx.ces.model.*" %>
<%@page import="java.math.BigDecimal"%>
<%@page import="java.text.SimpleDateFormat"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
a
{
text-decoration: none;
}
body
{
font-size:12px;
color: #033D61;
}
.tableb
{
border-collapse: collapse;
width: 60%;
}
.tableb th, .tableb td
{
border: 1px solid #33A9D0;
height: 20px;
}
th
{
background-color: #E7F2FA;
}
</style>
</head>
<body>
<span>当前位置:用户管理>>用户添加</span>
<%
request.setCharacterEncoding("UTF-8");
//获得表单提交过来的参数
String username = request.getParameter("username");
String password = request.getParameter("password");
String gender = request.getParameter("gender");
String birthday = request.getParameter("birthday");
String address = request.getParameter("address");
String sal = request.getParameter("sal");
//把参数转换成相应的数据类型
Integer genderInt = null;
java.util.Date birthdayDate = null;
BigDecimal salBD = null;;
if(gender != null)
{
genderInt = new Integer(gender);
}
if(birthday != null)
{
try
{
birthdayDate = new SimpleDateFormat("yyyy-MM-dd").parse(birthday);
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
if(sal != null)
{
try
{
salBD = new BigDecimal(sal);
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
CSUsr user = new CSUsr();
user.setAddress(address);
user.setBirthday(birthdayDate);
user.setGender(genderInt);
user.setPassword(password);
user.setUsername(username);
user.setSal(salBD);
System.out.print(user);
//定义添加用户sql
String sql = "insert into cs_user(username, password ,gender, birthday, address, sal)values(?,?,?,?,?,?)";
PreparedStatement pstmt = null;
try
{
pstmt = DBUtil.getPstmt(sql);
pstmt.setString(1, user.getUsername());
pstmt.setString(2, user.getPassword());
pstmt.setInt(3, user.getGender());
pstmt.setDate(4, new java.sql.Date(user.getBirthday().getTime()));
pstmt.setString(5, user.getAddress());
pstmt.setBigDecimal(6, user.getSal());
pstmt.executeUpdate();
}
catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
DBUtil.closeResUpdate(pstmt);
}
//重定向到列表页面
response.sendRedirect("/ces/tab/tab.jsp");
%>
</body>
</html>
如有错误,欢迎指正!