📄 modiuser3.jsp

📁 此资源是jsp应用开发邓子云等编写的一书里的源代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.DataSource" %>
<html>
  <body bgcolor="#DCDADA">
  当前位置：用户管理-->修改用户信息<br>
  <%//------接收请求参数------
  	String oaUserId=request.getParameter("oaUserId");
  	String oaUserName=request.getParameter("oaUserName");
  	String oaUserPassword=request.getParameter("oaUserPassword");
  	String oaUserTrueName=request.getParameter("oaUserTrueName");
  	String department=request.getParameter("department");
  %>
  <%//------如果接收数据有误------
  	if(oaUserName==null||oaUserPassword==null||
  	   oaUserTrueName==null||department==null||
  	   oaUserId==null||
  	   oaUserName.length()==0||oaUserPassword.length()==0||
  	   oaUserTrueName.length()==0||department.length()==0||
  	   oaUserId.length()==0)
  	   response.sendRedirect("modiUser1.jsp");
  %>
  <%//------构造将数据插入到数据库的SQL语句-----
  	String sqlStr=new String("update oaUser set oaUserName=?,"+
  		"oaUserPassword=?,oaUserTrueName=?,departmentId=? where "+
  		"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();
  %>
  <%//------将数据更新到数据库------
  	PreparedStatement preSQLupdate=conn.prepareStatement(sqlStr);
  	oaUserName=new String(oaUserName.getBytes("ISO-8859-1"));
  	preSQLupdate.setString(1,oaUserName);
  	oaUserPassword=new String(oaUserPassword.getBytes("ISO-8859-1"));
  	preSQLupdate.setString(2,oaUserPassword);
  	oaUserTrueName=new String(oaUserTrueName.getBytes("ISO-8859-1"));
  	preSQLupdate.setString(3,oaUserTrueName);
  	preSQLupdate.setInt(4,Integer.parseInt(department));
  	preSQLupdate.setInt(5,Integer.parseInt(oaUserId));
  	int i=preSQLupdate.executeUpdate();
  	if(i==0)//更新失败
  		response.sendRedirect("modiUser1.jsp");
  	else
  		out.print("更新用户数据成功！");
  	if(conn!=null)
  		conn.close();
  %>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -