weiyong
/
201906G103


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
							<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <meta name="viewport" content="width=device-width,initial-scale=1.0, 
              minimum-scale=1.0, maximum-scale=1.0, user-scalable=no"/>
        <title>修改员工信息</title>

    </head>
    
    <body>
    
     <%
     String driver = "com.mysql.cj.jdbc.Driver";
     String url = "jdbc:mysql://localhost:3306/edu?characterEncoding=utf-8"
             + "&serverTimezone=UTC";
     String usr = "root";
     String password = "1234";

     Class.forName(driver);
     Connection conn = DriverManager.getConnection(url, usr, password);
     String sqlString = "select * from manager1 where count=?";
     PreparedStatement pstmt = conn.prepareStatement(sqlString);
     pstmt.setString(1, request.getParameter("count"));
     ResultSet rs = pstmt.executeQuery();
     String a="a";
     String b="b";
     String c="b";
     String d="b";
     String e="b";
     String f="b";
     String g="b";
     while (rs.next()) {
    	 a=rs.getString("name");
    	 b=rs.getString("gender");
    	 c=rs.getString("telephone");
    	 d=rs.getString("mailbox");
    	 e=rs.getString("age");
    	 f=rs.getString("department");
     }
     
     
     
     String count =request.getParameter("count");
     String name =request.getParameter("name");
     String gender =request.getParameter("gender");
     String telephone =request.getParameter("telephone");
     String mailbox =request.getParameter("mailbox");
     String age =request.getParameter("age");
     String department =request.getParameter("department");
            
        %>
        <h2 align="center">修改员工信息</h2>
        <div style="width:100%;text-align:center">
            <form action="../change?count=<%=request.getParameter("count")%>">
 <table align="center" border="1" width="600" cellpadding="10">
 <tr>
 <td>序号</td>
 <td>
 <input type="text" name="count" value=<%=count %>>
 </td>
 </tr>
  <tr>
   <td>用户名</td>
   <td>
    <% %><input type="text" name="name" id="name" value=<%=a %>>
   </td>
  </tr>
  <tr>
   <td>性别</td>
   <td id="gender" name="gender" value=<%=b %>>
    <input type="radio" name="gender" value="男" checked="checked">男
    <input type="radio" name="gender" value="女"/>女
   </td>
  </tr>
  <tr>
   <td>电话</td>
   <td>
    <input type="text" name="telephone" id="telephone" value=<%=c %>>
   </td>
  </tr>
  <tr>
   <td>邮箱</td>
   <td>
    <input type="text" name="mailbox" id="mailbox" value=<%=d %>>
   </td>
  </tr>
  <tr>
   <td>年龄</td>
   <td>
    <input type="text" name="age" id="age" value=<%=e %>>
   </td>
  </tr>
  <tr>
   <td>部门</td>
   <td>
    <select name="department" id="department" value=<%=f %>>
     <option value="人力部">人力部</option>
     <option value="生活部">生活部</option>
     <option value="活动部">活动部</option>
     <option value="财务部">财务部</option>
    </select>
   </td>
  </tr>
  <tr align="center">
   <td colspan="2">
    <input type="submit" value="修改" onclick="update(this)"/>
   </td>
  </tr>
 </table>
	</form>
        </div>
    </body>
</html>