?? acceptinsertusertable.jsp
字號(hào):
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%!
public String codeToString(String str)
{//處理中文字符串的函數(shù)
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%//接收客戶端提交的數(shù)據(jù)
String username=codeToString(request.getParameter("username"));
if(username==null)//無內(nèi)容則設(shè)為空串
username="";
String password=codeToString(request.getParameter("password"));
if(password==null)//無內(nèi)容則設(shè)為空串
password="";
String usertruename=codeToString(request.getParameter("usertruename"));
if(usertruename==null)//無內(nèi)容則設(shè)為空串
usertruename="";
String age=codeToString(request.getParameter("age"));
int ageint;
try
{
ageint=Integer.parseInt(age.trim());
}
catch(Exception e)
{
ageint=0; //沒有輸入年齡或輸入的年齡不是數(shù)字則值為0
}
String sex=codeToString(request.getParameter("sex"));
if(sex==null)//無內(nèi)容則設(shè)為空串
sex="";
String address=codeToString(request.getParameter("address"));
if(address==null)//無內(nèi)容則設(shè)為空串
address="";
String telephone=codeToString(request.getParameter("telephone"));
if(telephone==null)//無內(nèi)容則設(shè)為空串
telephone="";
%>
<%//構(gòu)造追加記錄SQL語句
String sqlString=null;//SQL語句
sqlString="insert into userTable(user_name,user_password,user_true_name,user_age,user_sex,user_address,user_telephone)"+
" values('"+username+"','"+password+"','"+usertruename+"',"+ageint+",'"+sex+"','"+address+"','"+telephone+"')";
%>
<%//執(zhí)行SQL語句
try
{ Connection con;
Statement sql;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql.executeUpdate(sqlString);
con.close();
}
catch(SQLException e1)
{
out.print("SQL異常！");
}
%>
<head>
<title>用戶注冊(cè)程序</title>
</head>
<body>
<center>
<table border="1" width="700">
<tr>
<td width="100%" colspan="2" align="center">用戶注冊(cè)程序</td>
</tr>
<tr>
<td width="100%" colspan="2">追加用戶成功！</td>
</tr>
</table>
</center>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -