?? regist.jsp
字號:
<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*,java.lang.Double.*"%>
<%@include file="comm.jsp"%>
<HTML>
<head>
<title>注冊</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div>
<%
String customerID=request.getParameter("CustomerID").trim();
String customerName=request.getParameter("CustomerName").trim();
String pwd=request.getParameter("password");
String repwd=request.getParameter("repassword");
String idCard=request.getParameter("IDCard");
String address=request.getParameter("address").trim();
String province=request.getParameter("Province");
String zipCode=request.getParameter("zipcode");
String phone=request.getParameter("phone");
strSql = "{call dbo.sp_insertcustomer(?,?,?,?,?,?,?,?,?)}";
cstmt = conn.prepareCall(strSql);
// Register the Output Parameter
cstmt.registerOutParameter(9, java.sql.Types.INTEGER);
//Set Input Parameters
cstmt.setString(1,customerID);
cstmt.setString(2,customerName);
cstmt.setString(3,pwd);
cstmt.setString(4,idCard);
cstmt.setString(5,address);
cstmt.setString(6,province);
cstmt.setString(7,zipCode);
cstmt.setString(8,phone);
cstmt.executeUpdate();
int iR=cstmt.getInt(9);
if(iR==0)
{
session.putValue("user",customerID);
%>
<jsp:forward page="CustomerInfo.jsp?action=view"/>
<%
}
else if(iR==1)
{
%>
<jsp:forward page="regist.htm"/>
<%
}
rs.close();
cstmt.close();
conn.close();
%>
</div>
</body>
</HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -