📄 do_register.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.Date" errorPage="" %>
<!-- 恽奚皓 -- 运气好 -->
<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("恭喜！注册成功！您注册的信息已经写进数据库！");
//}
//catch (SQLException e)
//{
// out.println(e.getMessage());
//}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -