?? do_register.jsp
字號:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.Date" errorPage="" %>
<!-- 惲奚皓 -- 運(yùn)氣好 -->
<html>
<head>
<title>注冊成功</title>
<link rel=stylesheet href="style.css" type="text/css">
</head>
<body>
<%
String name=request.getParameter("name");
String pwd=request.getParameter("password");
String e_mail=request.getParameter("e_mail");
String telephone=request.getParameter("telephone");
String address=request.getParameter("address");
java.util.Date regTime=new java.util.Date();
String register_Time=regTime.toString();
String query="insert into customer_info(Name,Telephone,Email,Address,Login_Time,Passwd)values('"+name+"','"+telephone+"','"+e_mail+"' ,'"+address+"','"+register_Time+"','"+pwd+"')";
//try
//{
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sDBDriver);
String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Web";
String username="sa";
String pwd1="";
Connection connWeb=DriverManager.getConnection(sConnStr,username,pwd1);
Statement stmt=connWeb.createStatement();
stmt.executeUpdate(query);
stmt.close();
connWeb.close();
out.println("恭喜!注冊成功!您注冊的信息已經(jīng)寫進(jìn)數(shù)據(jù)庫!");
//}
//catch (SQLException e)
//{
// out.println(e.getMessage());
//}
%>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -