【JSP开源代码栏目提醒】:网学会员在JSP开源代码频道为大家收集整理了updateUser3.jsp提供大家参考,希望对大家有所帮助!
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%!
public String codeToString(String str)
{//处理中文字符串的函数
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%//接收要修改的用户ID号
long user_id=Long.parseLong(request.getParameter("user_id"));
%>
<%//接收客户端提交的数据
String username=codeToString(request.getParameter("username"));
if(username==null)//无内容则设为空串
username="";
String usertruename=codeToString(request.getParameter("usertruename"));
if(usertruename==null)//无内容则设为空串
usertruename="";
String age=codeToString(request.getParameter("age"));
int ageint;
try
{
ageint=Integer.parseInt(age.trim());
}
catch(Exception e)
{
ageint=0; //没有输入年龄或输入的年龄不是数字则值为0
}
String sex=codeToString(request.getParameter("sex"));
if(sex==null)//无内容则设为空串
sex="";
String address=codeToString(request.getParameter("address"));
if(address==null)//无内容则设为空串
address="";
String telephone=codeToString(request.getParameter("telephone"));
if(telephone==null)//无内容则设为空串
telephone="";
%>
<%//构造修改记录SQL语句
String sqlString=null;//SQL语句
sqlString="update userTable set user_name='"+username+"',user_true_name='"+usertruename+"',user_age="+
ageint+",user_sex='"+sex+"',user_address='"+address+"',user_telephone='"+telephone+
"' where user_id="+user_id;
%>
<%//执行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();
sql.executeUpdate(sqlString);
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常!");
}
%>
<head>
<title>修改用户资料程序</title>
</head>
<body>
<center>
<table border="1" width="700">
<tr>
<td width="100%" colspan="2" align="center">修改用户资料程序</td>
</tr>
<tr>
<td width="100%" colspan="2">修改用户资料成功!</td>
</tr>
</table>
</center>
</body>
</html>
上一篇:
updateUser2.jsp
下一篇:
加强公路桥梁施工质量、成本及进度的管理对策