📄 modify.jsp

📁 j2ee实现简单的bbs功能
💻 JSP
字号:
<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id = "dBean" scope="session" class="BeanLink.DBBean"/>
<html>
<head>
<title>修改用户注册信息</title>
</head>
<body>
<%
String sdriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sconn="jdbc:odbc:mydb";
String suser="";
String spass="";
String tablename="user";

String sql ="";
String username ="";
String password ="";
String email ="";
int purview = -1;
String idStr = request.getParameter("id");
long id = Long.parseLong(idStr);
String loginSign = (String)session.getValue("loginSign");
if(loginSign!=null&&loginSign.equals("ADMINOK"))
{
	sql = "select * from "+ tablename+" where id="+id;
	dBean.openConn(sdriver,sconn,suser,spass);
	ResultSet rs = dBean.executeQuery(sql);
	if(rs.next())
	{
		username = rs.getString("username");
		password = rs.getString("password");
		email = rs.getString("email");
		purview = rs.getInt("purview");
	}
	if(rs!=null)
		rs.close();
	dBean.closeConn();
}
%>
<script language="JavaScript">
function isValid(form1)
{
	if(!checkpass(form1.mypass.value,form1.mypass2.value))
	{
		form1.mypass.focus();
		return false;
	}
	if(!email(form1.email.value))
	{
		alert("email格式不对！");
		form1.email.focus();
		return false;
	}
	if(!isNum(form1.purview.value))
	{
		alert("权限必须是数字！");
		form1.purview.focus();
		return false;
	}
	return true;
}
function checkpass(pass1,pass2)
{
	if(pass1=="")
	{
		alert("密码不能为空！");
		return false;
	}
	else if(pass1!=pass2)
	{
		alert("两次口令不同");
		return false;
	}
	else
		return true;
}
function email(email)
{
	if(email.indexOf('@',0)==-1)
		return false;
	else if(email.indexOf('.',0)==-1)
		return false;
	else if(email.length<6)
		return false;
	else
		return true;
}
function isNum(numvalue)
{
	if(numvalue.length==0)
		return false;
	for(i=0;i<numvalue.length;i++)
	{
		if(numvalue.charAt(i)<"0")
			return false;
		else if(numvalue.charAt(i)>"9")
			return false;
	}
	return true;
}
</script>
<CENTER>
<br>
用户注册修改
</CENTER>
<form name = form1 method="POST" onSubmit="return isValid(this)" action="dealmodify.jsp?id=<%=id%>">
<div align = "center">
<table width = "60%" border = "1" height = "197" bordercolorlight="#99ccff" cellspacing = "1" bordercolordark = "#99ccff">
<tr>
<td align="right" width = "596" height="23" colspan = "2">请修改您的个人信息（标注‘*’的内容必须填写）</td>
</tr>

<tr>
<td align="right" width = "298" height="17">用户名：</td>
<td align="right" width = "298" height="17"><%=username%></td>
</tr>

<tr>
<td align="right" width = "298" height="23">密码：</td>
<td align="right" width = "298" height="23"><INPUT TYPE = "password" size="8" maxlength="8" NAME ="mypass" value="<%=password%>">*</td>
</tr>

<tr>
<td align="right" width = "298" height="23">确认密码：</td>
<td align="right" width = "298" height="23"><INPUT TYPE = "password" size="8" maxlength="8" NAME ="mypass2">*</td>
</tr>

<tr>
<td align="right" width = "298" height="23">Email：</td>
<td align="right" width = "298" height="23"><INPUT TYPE = "text" NAME="email" value="<%=email%>" size="30" maxlength="30">*</td>
</tr>

<tr>
<td align="right" width = "298" height="23">权限：</td>
<td align="right" width = "298" height="23"><INPUT TYPE = "text" NAME="purview" value="<%=purview%>" size="30" maxlength="30">*</td>
</tr>
</table>
<br>
<p><input type="submit" value="提交" name="B1">
<input type="reset" value="全部重写" name="B2"></p>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -