|
采用Java Web编写项目的时候遇到了这个问题,写下来!
<%@ page language="java" import="java.util.*,cn.qm.db.*,java.sql.*" pageEncoding="GB2312"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>My JSP 'adduser.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!--<link rel="stylesheet" type="text/css" href="styles.css">--><style type="text/css">.adduser{text-align:center; font-size:12px; line-height:30px; color:#5A5A5A;position:absolute; top:20px; left:30px; width:600px;}.table{text-align:center; font-size:12px; line-height:30px; color:#5A5A5A;position:absolute; top:50px; left:30px; width:600px;}.user{text-align:center; font-size:12px; line-height:30px; color:#5A5A5A;position:absolute; left:50px;top:20px; }.info{text-align:center; font-size:12px; line-height:30px; color:#5A5A5A;position:absolute; left:50px;top:100px;}.table2{text-align:center; font-size:12px; line-height:30px; color:#5A5A5A;position:absolute; top:120px; left:30px; width:600px;}.STYLE3 {font-size: 12px}.STYLE9 {color: #FF0000; font-size: 12; }.STYLE10 {font-size: 10} </style><script type="text/javascript" src="JQuery/jquery-1.5.2.min.js"></script><%DataBase db = new DataBase();ResultSet rs; %> </head> <body> <form action="adduser.do" method="post"><div id="lee" class="adduser"><div class="user">用户登录信息</div><div class="table"><hr><table cellpadding="0" cellspacing="0" border="0"><tr><!-- 用户名采用输入框的形式 --><td width="100"><div align="center"><span class="STYLE3">用户名:</span></div></td><td width="100"><input name="username" type="text"></td><td width="100"><div align="center"><span class="STYLE3">默认密码:</span></div></td><td width="100">123456</td></tr><tr></table></div><div class="info">用户个人信息</div><div class="table2"><hr><table border="0" align="center" cellpadding="0" cellspacing="0"><tr><td height="30" width="50"><span class="STYLE3">员工号:</span></td><td width="100"><input name="eno" type="text"></td><td width="100"><span class="STYLE9">*必填</span></td><td width="150"><span class="STYLE3"></span></td></tr><!-- 用户名采用输入框的形式 --><tr><td height="30" width="50"><span class="STYLE3">姓名:</span></td><td width="100"><input name="name" type="text"></td><td width="100"><span class="STYLE9">*必填</span></td><td width="150"><span class="STYLE3"></span></td></tr><tr><!-- 用户名采用输入框的形式 --><td height="30"><span class="STYLE3">性别:</span></td><td> <span class="STYLE3"> <input type="radio" name="sex" value="man" checked>男 <input type="radio" name="sex" value="woman"> 女 </span></td><td>&nbsp;</td><td><span class="STYLE3"></span></td></tr><tr><!-- 用户名采用输入框的形式 --><td height="30"><span class="STYLE3">年龄:</span></td><td><input name="age" type="text"></td><td><span class="STYLE9">*必填</span></td><td><span class="STYLE3"></span></td></tr><tr><!-- 用户名采用输入框的形式 --><td height="30"><span class="STYLE3">电话:</span></td><td><input name="telephone" type="text"></td><td><span class="STYLE10"></span></td><td><span class="STYLE3"></span></td></tr><tr><!-- 用户名采用输入框的形式 --><td height="30"><span class="STYLE3">地址:</span></td><td><input name="address" type="text"></td><td><span class="STYLE9">*必填</span></td><td><span class="STYLE3"></span></td></tr><tr><!-- 用户名采用输入框的形式 --><td height="30"><span class="STYLE3">部门号:</span></td><td> <span class="STYLE3"> <%String si = "select BMBH,BMMC from BMB"; %><select name="bmh" size="1"> <%rs = db.resultset(si);while(rs.next()){ %> <option value="<%=rs.getString("BMBH") %>"><%=rs.getString("BMBH") %> <%}; %> </select> </span></td><td><span class="STYLE9">*必选</span></td><td><span class="STYLE3"></span></td></tr><tr><td><input type="submit" value="添加"></td><td></td><td><input type="reset" value="清空"></td><td></td></tr></table> </div></div><script type="text/javascript">var target = $("#lee");target.height(400) .width(1000) .css("border" , "1px solid black")</script></form> </body></html>
package cn.qm.actionform;import org.apache.struts.action.ActionForm;public class adduseractionform extends ActionForm {private String username;private String eno;private String name;private String sex;private int age;private String telephone;private String address;private String bmh;public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}public String getBmh() {return bmh;}public void setBmh(String bmh) {this.bmh = bmh;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getEno() {return eno;}public void setEno(String eno) {this.eno = eno;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public String getTelephone() {return telephone;}public void setTelephone(String telephone) {this.telephone = telephone;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}}
package cn.qm.action;import java.sql.PreparedStatement;import java.sql.ResultSet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import cn.qm.actionform.adduseractionform;import cn.qm.db.DataBase;public class adduseraction extends Action{public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception {adduseractionform uaf = (adduseractionform)form;String username = uaf.getUsername();String eno = uaf.getEno();String name = new String(uaf.getName().getBytes("iso8859-1"),"gbk");//String name = uaf.getName();String sex = uaf.getSex();if(sex.equals("man")){sex = "男";}else{sex = "女";}int age = uaf.getAge();String telephone = uaf.getTelephone();String address = new String(uaf.getAddress().getBytes("iso8859-1"),"gbk");String bmh = uaf.getBmh();System.out.println(name+" "+address);DataBase db = new DataBase();PreparedStatement pstmt;ResultSet rs;String si = "Select id from YGXXB";rs = db.resultset(si);int number = 0;while(rs.next()){number = rs.getInt("id");}String sql = "insert into YGXXB values(?,?,?,?,?,?,?,?)";String check = "feild";if(username.length()==0||eno.length()==0||name.length()==0||telephone.length()==0||address.length()==0){request.setAttribute("check", check);return mapping.findForward("add");}else{pstmt = db.preparedstatement(sql);pstmt.setInt(1, number+1);pstmt.setString(2, eno);pstmt.setString(3, name);pstmt.setString(4, sex);pstmt.setInt(5, age);pstmt.setString(6, telephone);pstmt.setString(7, address);pstmt.setString(8, bmh);pstmt.execute();check = "success";request.setAttribute("check", check);return mapping.findForward("add");}}} |
|