db.jsp

来自「网上书店网站源代码」· JSP 代码 · 共 41 行

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<% 
String name=(String)session.getAttribute("name");
String pass=(String)session.getAttribute("pass");
String pass1=(String)session.getAttribute("pass1");
String sex=(String)session.getAttribute("sex");
String birthday=(String)session.getAttribute("birthday");
String mail=(String)session.getAttribute("mail");
String address=(String)session.getAttribute("address");
String phone=(String)session.getAttribute("phone");
       Connection con;
		Statement st;
		try
		{
		System.out.println("正在连接数据库");
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:book");
		st=con.createStatement();
		String sql="insert into b_user values('   "+name+"   ',' "+pass+"','"+sex+"',' "+birthday+"',' "+mail+"',' "+address+"',' "+phone+"')";
		st.executeUpdate(sql);
		System.out.println("已经成功的插入了一条记录");
		st.close();
		con.close();
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
%>
<style type="text/css">
<!--
.style1 {
	font-size: 18px;
	color: #0000FF;
	font-weight: bold;
}
-->
</style>

<span class="style1">恭喜<%=name%>注册成功！！！</span>