<%@page import="project.ConnectionProvider"%> <%@page import="java.sql.*"%> <%@include file="employeeHeader.jsp" %> Edit Employee Details

Back

<% String id = request.getParameter("payroll_id"); try { Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/CLINIHR", "root", "Clinica123"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from emp_payroll where payroll_id='" + id + "'"); while (rs.next()) { %>
<% } } catch (Exception e) { out.println(e); } %>