?? db.jsp
字號:
<%@ 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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -