领导信息的jsp怎么写
时间: 2024-05-07 15:11:31 浏览: 9
首先,在JSP页面上使用JSTL标签库来获取领导信息。例如:
```jsp
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<c:set var="leaderName" value="John Doe" />
<c:set var="leaderTitle" value="CEO" />
<c:set var="leaderEmail" value="john.doe@company.com" />
```
然后,在页面上展示领导信息。例如:
```jsp
<h2>领导信息</h2>
<p>姓名:${leaderName}</p>
<p>职位:${leaderTitle}</p>
<p>电子邮件:${leaderEmail}</p>
```
最后,可以将领导信息保存在数据库中,以便在需要时进行更新。可以使用Java Servlet和JDBC来实现这一点。例如:
```java
public class LeaderInfoServlet extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String leaderName = request.getParameter("leaderName");
String leaderTitle = request.getParameter("leaderTitle");
String leaderEmail = request.getParameter("leaderEmail");
// 将领导信息保存到数据库中
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "root", "password");
pstmt = conn.prepareStatement("INSERT INTO leader_info (name, title, email) VALUES (?, ?, ?)");
pstmt.setString(1, leaderName);
pstmt.setString(2, leaderTitle);
pstmt.setString(3, leaderEmail);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 重定向到领导信息页面
response.sendRedirect("leaderInfo.jsp");
}
}
```
在JSP页面上,可以使用表单来更新领导信息。例如:
```jsp
<form action="LeaderInfoServlet" method="post">
<label for="leaderName">姓名:</label>
<input type="text" name="leaderName" id="leaderName" value="${leaderName}" /><br />
<label for="leaderTitle">职位:</label>
<input type="text" name="leaderTitle" id="leaderTitle" value="${leaderTitle}" /><br />
<label for="leaderEmail">电子邮件:</label>
<input type="email" name="leaderEmail" id="leaderEmail" value="${leaderEmail}" /><br />
<input type="submit" value="保存" />
</form>
```