javaweb名片管理系统代码实现
时间: 2023-09-19 11:08:05 浏览: 67
这里提供一个简单的JavaWeb名片管理系统的代码实现。
首先,我们需要创建一个名为CardManagementSystem的JavaWeb项目。在项目中创建一个名为Card的JavaBean,用于存储名片信息。
```
public class Card {
private String name;
private String phone;
private String email;
private String company;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
}
```
接下来,我们需要创建一个名为CardDao的Java类,用于操作名片信息的数据库。这里使用JDBC连接MySQL数据库。
```
public class CardDao {
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/card_db";
private static final String USERNAME = "root";
private static final String PASSWORD = "123456";
private Connection conn = null;
private PreparedStatement pstmt = null;
public CardDao() {
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
}
public boolean add(Card card) {
String sql = "INSERT INTO card (name, phone, email, company) VALUES (?, ?, ?, ?)";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, card.getName());
pstmt.setString(2, card.getPhone());
pstmt.setString(3, card.getEmail());
pstmt.setString(4, card.getCompany());
pstmt.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
public boolean delete(String name) {
String sql = "DELETE FROM card WHERE name=?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
public boolean update(Card card) {
String sql = "UPDATE card SET phone=?, email=?, company=? WHERE name=?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, card.getPhone());
pstmt.setString(2, card.getEmail());
pstmt.setString(3, card.getCompany());
pstmt.setString(4, card.getName());
pstmt.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
public Card find(String name) {
String sql = "SELECT * FROM card WHERE name=?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
Card card = new Card();
card.setName(rs.getString("name"));
card.setPhone(rs.getString("phone"));
card.setEmail(rs.getString("email"));
card.setCompany(rs.getString("company"));
return card;
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public List<Card> findAll() {
String sql = "SELECT * FROM card";
List<Card> list = new ArrayList<>();
try {
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Card card = new Card();
card.setName(rs.getString("name"));
card.setPhone(rs.getString("phone"));
card.setEmail(rs.getString("email"));
card.setCompany(rs.getString("company"));
list.add(card);
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
}
```
接下来,我们需要创建一个名为CardServlet的Java类,用于处理名片信息的请求。
```
public class CardServlet extends HttpServlet {
private CardDao dao = new CardDao();
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String action = request.getParameter("action");
if ("add".equals(action)) {
add(request, response);
} else if ("delete".equals(action)) {
delete(request, response);
} else if ("update".equals(action)) {
update(request, response);
} else if ("find".equals(action)) {
find(request, response);
} else if ("findAll".equals(action)) {
findAll(request, response);
}
}
private void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String name = request.getParameter("name");
String phone = request.getParameter("phone");
String email = request.getParameter("email");
String company = request.getParameter("company");
Card card = new Card();
card.setName(name);
card.setPhone(phone);
card.setEmail(email);
card.setCompany(company);
boolean result = dao.add(card);
if (result) {
response.getWriter().write("success");
} else {
response.getWriter().write("failed");
}
}
private void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String name = request.getParameter("name");
boolean result = dao.delete(name);
if (result) {
response.getWriter().write("success");
} else {
response.getWriter().write("failed");
}
}
private void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String name = request.getParameter("name");
String phone = request.getParameter("phone");
String email = request.getParameter("email");
String company = request.getParameter("company");
Card card = new Card();
card.setName(name);
card.setPhone(phone);
card.setEmail(email);
card.setCompany(company);
boolean result = dao.update(card);
if (result) {
response.getWriter().write("success");
} else {
response.getWriter().write("failed");
}
}
private void find(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String name = request.getParameter("name");
Card card = dao.find(name);
if (card != null) {
response.getWriter().write(card.getName() + "," + card.getPhone() + "," + card.getEmail() + "," + card.getCompany());
} else {
response.getWriter().write("failed");
}
}
private void findAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<Card> list = dao.findAll();
if (list != null && list.size() > 0) {
for (Card card : list) {
response.getWriter().write(card.getName() + "," + card.getPhone() + "," + card.getEmail() + "," + card.getCompany() + "\n");
}
} else {
response.getWriter().write("failed");
}
}
}
```
最后,我们需要在项目中创建一个名为index.jsp的页面,用于展示名片信息的增删改查和显示功能。
```
<%-- index.jsp --%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>名片管理系统</title>
</head>
<body>
<h1>名片管理系统</h1>
<h2>添加名片</h2>
<form action="CardServlet" method="post">
<input type="hidden" name="action" value="add">
姓名:<input type="text" name="name"><br>
手机:<input type="text" name="phone"><br>
邮箱:<input type="text" name="email"><br>
公司:<input type="text" name="company"><br>
<input type="submit" value="添加">
</form>
<h2>删除名片</h2>
<form action="CardServlet" method="post">
<input type="hidden" name="action" value="delete">
姓名:<input type="text" name="name"><br>
<input type="submit" value="删除">
</form>
<h2>修改名片</h2>
<form action="CardServlet" method="post">
<input type="hidden" name="action" value="update">
姓名:<input type="text" name="name"><br>
手机:<input type="text" name="phone"><br>
邮箱:<input type="text" name="email"><br>
公司:<input type="text" name="company"><br>
<input type="submit" value="修改">
</form>
<h2>查找名片</h2>
<form action="CardServlet" method="post">
<input type="hidden" name="action" value="find">
姓名:<input type="text" name="name"><br>
<input type="submit" value="查找">
</form>
<h2>显示所有名片</h2>
<form action="CardServlet" method="post">
<input type="hidden" name="action" value="findAll">
<input type="submit" value="显示">
</form>
<h2>名片列表</h2>
<c:forEach items="${list}" var="card">
姓名:${card.name},手机:${card.phone},邮箱:${card.email},公司:${card.company}<br>
</c:forEach>
</body>
</html>
```
以上代码基本实现了一个简单的JavaWeb名片管理系统。
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)