do_register.jsp
上传用户:sanhemotor
上传日期:2010-01-25
资源大小:381k
文件大小:1k
- <%@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>