学生管理

<%@ include file="module/sidebar.jsp"%>

添加档案

<% try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { out.print("暂时无法访问"); } try { Connection con; Statement sql; ResultSet rs; con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/db_school?useUnicode=true&characterEncoding=utf-8", "root", ""); sql = con.createStatement(); String condition = null; condition = "SELECT empid FROM tb_docfile"; rs = sql.executeQuery(condition); while (rs.next()) //输出查询结果 { %> <% } con.close(); sql.close(); rs.close(); } catch ( SQLException e1) { out.print("无法查询记录"); } %> <% Class.forName(driverClass); try { ResultSet rs = null; Connection conn = null; PreparedStatement sql = null; conn = DriverManager.getConnection(url, user, password); Statement stmt = conn.createStatement(); sql = conn.prepareStatement("SELECT * FROM tb_docfile where edi_name=?;"); sql.setString(1, (String) user1); rs = sql.executeQuery(); while (rs.next()) { %> <% } sql.close(); rs.close(); conn.close(); stmt.close(); } catch ( SQLException e1) { out.print("无法查询记录"); } %>

个人档案
工号	" readonly>	职务
姓名	">	性别
民族	">	籍贯	">
学校	">	学院	">
专业	">	出生年月	">
社交信息
QQ	">	邮箱	">
电话	">	住址	">
简历
<%=rs.getString("empResume")%>
备注
<%=rs.getString("empremark")%>