第一页面为录入页面,第二页面取得值
具体代码如下
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html;charset=GBK"%>
<jsp:useBean id="num" scope="page" class="com.css.test.GetSerialNo"/>
<jsp:useBean id="conn" scope="page" class="com.css.test.bondcategory" /><%
String Problem_ID=num.getSerialNo(9);
String duty=
request.getParameter("duty")==null?"":request.getParameter("duty").trim();
String Branch_No = request.getParameter("Branch_No")==null?"":request.getParameter("Branch_No").trim();String address = request.getParameter("address")==null?"1":request.getParameter("address").trim();
String Com_Name = request.getParameter("Com_Name")==""?"不详":request.getParameter("Com_Name").trim();
String Telephone = request.getParameter("Telephone")==null?"":request.getParameter("Telephone").trim();
String Nick_Name = request.getParameter("Nick_Name")==null?"":request.getParameter("Nick_Name").trim();
String Type = request.getParameter("Type_Name_1")==null?"":request.getParameter("Type_Name_1").trim();
String Kind = request.getParameter("Kind_No")==null?"":request.getParameter("Kind_No").trim();
String Moudl = request.getParameter("Moudl")==null?"":request.getParameter("Moudl").trim();
String Mangage_Time = request.getParameter("Mangage_Time")==null?"":request.getParameter("Mangage_Time").trim();
String Description = request.getParameter("Description")==null?"":request.getParameter("Description").trim();
String Equipment_No = request.getParameter("Equipment_No")==null?"":request.getParameter("Equipment_No").trim();
String Tran_No = request.getParameter("Tran_No")==null?"":request.getParameter("Tran_No").trim();
String Tailor_No = request.getParameter("Tailor_No")==null?"":request.getParameter("Tailor_No").trim();
String Error_No = request.getParameter("Error_No")==null?"":request.getParameter("Error_No").trim();
String sql = "insert Problem values('"+Problem_ID+"',getdate(),'"+address+"','"+Branch_No+"','"+Com_Name+"'";
sql=sql+",'"+Telephone+"','"+duty+"','"+Nick_Name+"','"+Type+"','"+Kind+"','"+Moudl+"','"+Mangage_Time+"','"+Description+"'";
sql=sql+",'"+0+"','"+"','"+"','"+"','"+"','"+"','"+Equipment_No+"','"+Tran_No+"','"+Tailor_No+"','"+ Error_No+"')";int n = conn.execSql(sql);if(n == 0){
out.println(sql);//测试 //response.sendRedirect("../error.jsp");
}else{
out.println(sql);//测试 //response.sendRedirect("inputerror.jsp");
}
%><HTML>
<HEAD>
<META name="GENERATOR" content="IBM WebSphere Studio">
</HEAD>
</HTML>