使用Java语言GUI界面实现会员管理系统的完整代码
时间: 2023-07-12 14:09:40 浏览: 44
很抱歉,我无法在这里提供完整的代码,因为代码的实现过程涉及到很多细节,而且需要根据具体的需求进行设计。但是,我可以提供一些代码片段供您参考。
首先,我们需要定义一个会员类,如下所示:
```java
public class Member {
private int id;
private String name;
private String gender;
private String phone;
public Member(int id, String name, String gender, String phone) {
this.id = id;
this.name = name;
this.gender = gender;
this.phone = phone;
}
// 省略get和set方法
}
```
然后,我们需要使用JDBC连接MySQL数据库,如下所示:
```java
public class Database {
private Connection conn;
public Database() throws SQLException {
String url = "jdbc:mysql://localhost:3306/membership";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url, user, password);
}
public void close() throws SQLException {
conn.close();
}
public void addMember(Member member) throws SQLException {
String sql = "INSERT INTO member (id, name, gender, phone) VALUES (?, ?, ?, ?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setInt(1, member.getId());
stmt.setString(2, member.getName());
stmt.setString(3, member.getGender());
stmt.setString(4, member.getPhone());
stmt.executeUpdate();
stmt.close();
}
// 省略删除、修改、查询等方法
}
```
接下来,我们需要设计GUI界面,如下所示:
```java
public class MemberGUI extends JFrame {
private JTextField idField;
private JTextField nameField;
private JTextField genderField;
private JTextField phoneField;
public MemberGUI() {
// 窗口设置
setTitle("会员管理系统");
setSize(500, 300);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
// 布局设置
JPanel topPanel = new JPanel();
topPanel.setLayout(new GridLayout(4, 2));
topPanel.add(new JLabel("ID:"));
idField = new JTextField();
topPanel.add(idField);
topPanel.add(new JLabel("姓名:"));
nameField = new JTextField();
topPanel.add(nameField);
topPanel.add(new JLabel("性别:"));
genderField = new JTextField();
topPanel.add(genderField);
topPanel.add(new JLabel("电话:"));
phoneField = new JTextField();
topPanel.add(phoneField);
add(topPanel, BorderLayout.NORTH);
JPanel buttonPanel = new JPanel();
buttonPanel.setLayout(new FlowLayout());
JButton addButton = new JButton("添加");
addButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
int id = Integer.parseInt(idField.getText());
String name = nameField.getText();
String gender = genderField.getText();
String phone = phoneField.getText();
Member member = new Member(id, name, gender, phone);
Database db = new Database();
db.addMember(member);
db.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
buttonPanel.add(addButton);
add(buttonPanel, BorderLayout.SOUTH);
}
public static void main(String[] args) {
MemberGUI gui = new MemberGUI();
gui.setVisible(true);
}
}
```
以上代码片段仅供参考,具体实现过程需要根据具体需求进行设计。希望这些代码片段能对您有所帮助。