📄 modiuser2.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.DataSource" %>
<!------系统交互javascript----->
<script language="JavaScript">
<!--
function checkData() {
if(form1.oaUserName.value.length==0){
alert("用户名不能为空");
return false;
}
if(form1.oaUserPassword.value.length==0){
alert("密码不能为空");
return false;
}
if(form1.oaUserTrueName.value.length==0){
alert("用户真实姓名不能为空");
return false;
} else return true;
}
-->
</script>
<html>
<body bgcolor="#DCDADA">
当前位置：用户管理-->修改用户信息<br>
<%//------接收请求参数------
String oaUserId=request.getParameter("oaUserId");
%>
<%//------如果接收数据有误------
if(oaUserId==null||oaUserId.length()==0)
response.sendRedirect("modiUser1.jsp");
%>
<%//------构造将数据插入到数据库的SQL语句-----
String sqlStr=new String("select * from oaUser where oaUserId="+oaUserId);
%>
<%//------得到数据库连接------
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
Object obj = (Object) ctx.lookup("jdbc/sqlserver");
DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
%>
<%//------查询数据------
java.sql.Statement sql1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs1=sql1.executeQuery(sqlStr);
if(rs1!=null){
rs1.next();
%>
<table border="1" CELLSPACING=0 CELLPADDING=0>
<form name="form1" action="modiUser3.jsp" method="post" onsubmit="return checkData()">
<input type="hidden" name="oaUserId" value="<%=rs1.getString("oaUserId")%>">
<tr><td align="center" colspan="2">
修改系统用户信息
</td></tr>
<tr><td align="right">用户名：</td>
<td align="left">
<input type="text" size="36" name="oaUserName" value="<%=rs1.getString("oaUserName")%>">(*)
</td></tr>
<tr><td align="right">密码：</td>
<td align="left">
<input type="password" size="40" name="oaUserPassword" value="<%=rs1.getString("oaUserPassword")%>">(*)
</td></tr>
<tr><td align="right">用户真实姓名：</td>
<td align="left">
<input type="text" size="36" name="oaUserTrueName" value="<%=rs1.getString("oaUserTrueName")%>">(*)
</td></tr>
<tr><td align="right">所属部门：</td>
<td align="left">
<select name="department">
<%//------查询出部门数据------
//SQL查询语句
sqlStr="select * from department";
//通过查询得到记录集
java.sql.Statement sql2=conn.createStatement();
ResultSet rs2=sql2.executeQuery(sqlStr);
//显示数据
while(rs2.next()){
if(rs2.getInt("departmentId")!=1)//如果不系统管理员
if(rs1.getInt("departmentId")!=rs2.getInt("departmentId"))
out.print("<option value=\""+rs2.getInt("departmentId")+
"\">"+rs2.getString("departmentName")+"</option>");
else
out.print("<option value=\""+rs2.getInt("departmentId")+
"\" selected>"+rs2.getString("departmentName")+"</option>");
}
%>
</select>(*)
</td></tr>
<tr><td align="center" colspan="2">
<input type="submit" value="提交">
</td></tr>
</form>
</table>
<%}%>
<%
if(conn!=null)
conn.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -