📄 work_rate query.txt
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<style type="text/css">
<!--
.style1 {
font-size: 24px;
font-weight: bold;
}
-->
</style>
<body>
<p>
<%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
try{
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=WEBOA";
Connection conn = DriverManager.getConnection(url,"sa","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM work_rate");
out.println("用户表："+"<br>");
out.print("<table border=5>");
out.print("<tr><td><font color=red>员工编号</font></td><td><font color=red>员工姓名</font></td><td><font color=red>部门编号</font></td><td><font color=red>部门名称</font></td><td>工作标题</font></td><td>工作内容</font></td><td>开始时间</font></td><td><font color=red>结束时间</font></td><td><font color=red>公司要求时间</font></td><td><font color=red>员工完成时间</font></td><td>备注</font></td></tr>");
while(rs.next()){
out.print("<tr><td>");
out.print(rs.getString(1));
out.print("</td><td>");
out.print(rs.getString(2));
out.print("</td><td>");
out.print(rs.getString(3));
out.print("</td><td>");
out.print(rs.getString(4));
out.print("</td><td>");
out.print(rs.getString(5));
out.print("</td><td>");
out.print(rs.getString(6));
out.print("</td><td>");
out.print(rs.getString(7));
out.print("</td><td>");
out.print(rs.getString(8));
out.print("</td><td>");
out.print(rs.getString(9));
out.print("</td><td>");
out.print(rs.getString(10));
out.print("</td><td>");
out.print(rs.getString(11));
out.print("</td><td>");
}
out.print("</table>");
stmt.close();
conn.close();
}
catch(Exception ex){
out.print(ex);
}
%>
</p>
<p align="right" class="style1"> </p>
<p align="right" class="style1"> </p>
<p align="right" class="style1"><a href="work_index.jsp">[返回]</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -