12.15-526互联

今日学习内容

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>查看出差申请</h1>
<hr>
<%
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
}
request.setCharacterEncoding("utf-8");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/2023shenpi", "root", "123456");
Statement stat = null;
stat = conn.createStatement();
String sql = "SELECT * FROM chuchai" ;
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String column1 = rs.getString("name");
String column2 =rs.getString("department");
String column3 = rs.getString("destination");
String column4 = rs.getString("departuredate");
String column5 = rs.getString("returndate");
String column6 = rs.getString("Type");
String column7 = rs.getString("Typecontent");
String column8 = rs.getString("Reason");
String column9 = rs.getString("State");

// 其他处理...

// 在页面上显示数据
%>
出差人姓名: <%= column1 %>
 
部门: <%= column2 %>
 
目的地: <%= column3 %>
 
出发日期: <%= column4 %>
 
返回日期: <%= column5 %>
 
出差类别: <%= column6 %>
 
其他类别内容: <%= column7 %>
 
出差事由: <%= column8 %>
 
申请状态: <%= column9 %>
 
 
<hr>
<%
}
%>
</body>
</html>

12.15

12.15 12 15