<%@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"%>
修改员工信息
<%
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");
%>
修改员工信息