用java和mysql实现访客管理系统的黑名单增删改查功能,并将代码分为action、dao、pojo、service四个部分。代码中要求详细写出getter和setter构造方法
时间: 2023-11-28 14:47:46 浏览: 48
1. POJO类:Visitor.java
```java
public class Visitor {
private int id;
private String name;
private String idCard;
private boolean isBlacklisted;
public Visitor() {}
public Visitor(int id, String name, String idCard, boolean isBlacklisted) {
this.id = id;
this.name = name;
this.idCard = idCard;
this.isBlacklisted = isBlacklisted;
}
//getter和setter方法
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getIdCard() {
return idCard;
}
public void setIdCard(String idCard) {
this.idCard = idCard;
}
public boolean isBlacklisted() {
return isBlacklisted;
}
public void setBlacklisted(boolean blacklisted) {
isBlacklisted = blacklisted;
}
}
```
2. DAO类:VisitorDAO.java
```java
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class VisitorDAO {
private Connection connection;
public VisitorDAO() {
this.connection = new DBUtil().getConnection();
}
public List<Visitor> getAllVisitors() {
List<Visitor> visitors = new ArrayList<>();
String sql = "SELECT * FROM visitors";
try {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
Visitor visitor = new Visitor();
visitor.setId(resultSet.getInt("id"));
visitor.setName(resultSet.getString("name"));
visitor.setIdCard(resultSet.getString("idCard"));
visitor.setBlacklisted(resultSet.getBoolean("isBlacklisted"));
visitors.add(visitor);
}
} catch (SQLException e) {
e.printStackTrace();
}
return visitors;
}
public Visitor getVisitorById(int id) {
Visitor visitor = new Visitor();
String sql = "SELECT * FROM visitors WHERE id=?";
try {
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, id);
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
visitor.setId(resultSet.getInt("id"));
visitor.setName(resultSet.getString("name"));
visitor.setIdCard(resultSet.getString("idCard"));
visitor.setBlacklisted(resultSet.getBoolean("isBlacklisted"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return visitor;
}
public boolean addVisitor(Visitor visitor) {
String sql = "INSERT INTO visitors(name, idCard, isBlacklisted) VALUES(?,?,?)";
try {
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, visitor.getName());
preparedStatement.setString(2, visitor.getIdCard());
preparedStatement.setBoolean(3, visitor.isBlacklisted());
preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean updateVisitor(Visitor visitor) {
String sql = "UPDATE visitors SET name=?, idCard=?, isBlacklisted=? WHERE id=?";
try {
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, visitor.getName());
preparedStatement.setString(2, visitor.getIdCard());
preparedStatement.setBoolean(3, visitor.isBlacklisted());
preparedStatement.setInt(4, visitor.getId());
preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean deleteVisitor(int id) {
String sql = "DELETE FROM visitors WHERE id=?";
try {
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, id);
preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
}
```
3. Service类:VisitorService.java
```java
import java.util.List;
public class VisitorService {
private VisitorDAO visitorDAO = new VisitorDAO();
public List<Visitor> getAllVisitors() {
return visitorDAO.getAllVisitors();
}
public Visitor getVisitorById(int id) {
return visitorDAO.getVisitorById(id);
}
public boolean addVisitor(Visitor visitor) {
return visitorDAO.addVisitor(visitor);
}
public boolean updateVisitor(Visitor visitor) {
return visitorDAO.updateVisitor(visitor);
}
public boolean deleteVisitor(int id) {
return visitorDAO.deleteVisitor(id);
}
}
```
4. Action类:VisitorAction.java
```java
import com.opensymphony.xwork2.ActionSupport;
import java.util.List;
public class VisitorAction extends ActionSupport {
private VisitorService visitorService = new VisitorService();
private Visitor visitor;
private List<Visitor> visitors;
private int id;
public String list() {
visitors = visitorService.getAllVisitors();
return SUCCESS;
}
public String add() {
if (visitorService.addVisitor(visitor)) {
return SUCCESS;
} else {
return ERROR;
}
}
public String edit() {
visitor = visitorService.getVisitorById(id);
return SUCCESS;
}
public String update() {
if (visitorService.updateVisitor(visitor)) {
return SUCCESS;
} else {
return ERROR;
}
}
public String delete() {
if (visitorService.deleteVisitor(id)) {
return SUCCESS;
} else {
return ERROR;
}
}
//getter和setter方法
public Visitor getVisitor() {
return visitor;
}
public void setVisitor(Visitor visitor) {
this.visitor = visitor;
}
public List<Visitor> getVisitors() {
return visitors;
}
public void setVisitors(List<Visitor> visitors) {
this.visitors = visitors;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
}
```