团队成员档案
<%@ include file="module/sidebar.jsp"%>
<%@ include file="module/footer.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,empname,empjob FROM tb_docfile";
rs = sql.executeQuery(condition);
//String k1=rs.getString(1);
out.print("");
out.print("
");
con.close();
sql.close();
rs.close();
} catch (SQLException e1) {
out.print("无法查询记录");
}
%>
<%
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 * FROM tb_docfile";
rs = sql.executeQuery(condition);
while (rs.next()) //输出查询结果
{
%>
| 姓名 | "); out.print("岗位 | "); out.print(""); out.print(" |
|---|---|---|
" + rs.getString(2) + " | ");
out.print("" + rs.getString(3) + " | ");
out.print(
""); out.print(" |
-example-modal-lg"
tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel">
<%
}
con.close();
sql.close();
rs.close();
} catch (
SQLException e1) {
out.print("无法查询记录");
}
%>
<%=rs.getString("empjob")%>
| 个人档案 | ||||||
| 工号 | <%=rs.getString("empid")%> | 职务 | <%=rs.getString("empjob")%> | <%-- |
||
| 姓名 | <%=rs.getString("empname")%> | 性别 | <%=rs.getString("empsex")%> | |||
| 民族 | <%=rs.getString("empnation")%> | 籍贯 | <%=rs.getString("empnative")%> | |||
| 学校 | <%=rs.getString("empschool")%> | 学院 | <%=rs.getString("empdept")%> | |||
| 专业 | <%=rs.getString("empmajor")%> | 出生年月 | <%=rs.getString("empbirthday")%> | |||
| 社交信息 | ||||||
| <%=rs.getString("empQQ")%> | 邮箱 | <%=rs.getString("empemail")%> | ||||
| 电话 | <%=rs.getString("empPhoneNum")%> | 住址 | <%=rs.getString("empadress")%> | |||
| 简历 | ||||||
| <%=rs.getString("empResume")%> | ||||||
| 备注 | ||||||
| <%=rs.getString("empremark")%> | ||||||