生成一个用Java Swing和mysql数据库制作客户管理系统代码
时间: 2024-03-09 20:46:19 浏览: 28
抱歉,由于回答的字数限制,我无法在这里提供完整的代码。但是,我可以为您提供实现该系统的大致思路和关键代码片段。
1. 建立数据库连接
```java
String url = "jdbc:mysql://localhost:3306/customer";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);
```
2. 实现登录功能
```java
String username = usernameTextField.getText();
String password = new String(passwordField.getPassword());
String sql = "SELECT * FROM user WHERE username = ? AND password = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
// 登录成功,跳转到主界面
} else {
// 登录失败,显示错误提示
}
```
3. 添加客户
```java
String name = nameTextField.getText();
String phone = phoneTextField.getText();
String address = addressTextField.getText();
String sql = "INSERT INTO customer (name, phone, address) values (?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, phone);
pstmt.setString(3, address);
int result = pstmt.executeUpdate();
if (result > 0) {
// 添加成功,清空输入框
nameTextField.setText("");
phoneTextField.setText("");
addressTextField.setText("");
} else {
// 添加失败,显示错误提示
}
```
4. 编辑客户
```java
String name = nameTextField.getText();
String phone = phoneTextField.getText();
String address = addressTextField.getText();
String sql = "UPDATE customer SET name = ?, phone = ?, address = ? WHERE id = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, phone);
pstmt.setString(3, address);
pstmt.setInt(4, id);
int result = pstmt.executeUpdate();
if (result > 0) {
// 编辑成功,关闭编辑窗口
editFrame.dispose();
} else {
// 编辑失败,显示错误提示
}
```
5. 删除客户
```java
int id = (int) table.getValueAt(row, 0);
String sql = "DELETE FROM customer WHERE id = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
int result = pstmt.executeUpdate();
if (result > 0) {
// 删除成功,刷新客户列表
refreshTable();
} else {
// 删除失败,显示错误提示
}
```
以上是关键代码片段,您可以根据需要进行修改和完善。希望对您有所帮助!