基于java swing 和SQL Server的酒店管理系统课程设计

酒店管理系统是一个比较复杂的系统，需要考虑到很多方面的功能和业务逻辑。在设计和实现这样一个系统时，需要进行系统分析和设计，确定系统的需求和功能，选择合适的技术和工具进行开发，最后进行测试和部署。

下面是一些可能需要考虑的功能和模块：

1. 酒店客房管理：包括客房信息管理、房间状态管理、客房预定管理、客房入住管理等。
2. 前台管理：包括客户信息管理、订单管理、结账管理、客户服务管理等。
3. 后台管理：包括员工信息管理、权限管理、财务管理、报表管理等。
4. 系统设置模块：包括基本设置、数据备份、系统维护等。

在选择技术和工具时，可以考虑使用Java Swing作为界面开发工具，使用SQL Server作为数据库管理系统。Java技术具有跨平台性和良好的可维护性，SQL Server是一个功能强大的关系型数据库管理系统，可以满足系统的存储和查询需求。

关于课程设计和源码，建议您参考相关的教学资料或者参考其他开源的酒店管理系统进行学习和参考。同时，需要提醒您注意版权和知识产权问题，不要抄袭他人的代码和设计方案。

相关问题

帮我写一份Javaswing基于SQLserver的学生信息管理系统

好的，以下是一个基于Java Swing和SQL Server的学生信息管理系统的示例代码：

1. 数据库连接部分

import java.sql.*;

public class DatabaseConnection {
    static final String JDBC_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    static final String DB_URL = "jdbc:sqlserver://localhost:1433;databaseName=student";
    static final String USER = "yourusername";
    static final String PASSWORD = "yourpassword";

    public Connection getConnection() {
        Connection conn = null;
        try {
            Class.forName(JDBC_DRIVER);
            conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
}

2. 主界面部分

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class MainFrame extends JFrame implements ActionListener {
    private JButton addButton, searchButton, updateButton, deleteButton, reportButton;

    public MainFrame() {
        super("学生信息管理系统");
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setLayout(new FlowLayout());

        addButton = new JButton("添加");
        searchButton = new JButton("查询");
        updateButton = new JButton("修改");
        deleteButton = new JButton("删除");
        reportButton = new JButton("报告");

        addButton.addActionListener(this);
        searchButton.addActionListener(this);
        updateButton.addActionListener(this);
        deleteButton.addActionListener(this);
        reportButton.addActionListener(this);

        add(addButton);
        add(searchButton);
        add(updateButton);
        add(deleteButton);
        add(reportButton);

        pack();
        setLocationRelativeTo(null);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == addButton) {
            new AddFrame();
        } else if (e.getSource() == searchButton) {
            new SearchFrame();
        } else if (e.getSource() == updateButton) {
            new UpdateFrame();
        } else if (e.getSource() == deleteButton) {
            new DeleteFrame();
        } else if (e.getSource() == reportButton) {
            new ReportFrame();
        }
    }
}

3. 添加学生信息部分

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class AddFrame extends JFrame implements ActionListener {
    private JLabel nameLabel, genderLabel, ageLabel, majorLabel;
    private JTextField nameText, genderText, ageText, majorText;
    private JButton addButton, cancelButton;

    public AddFrame() {
        super("添加学生信息");
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        setLayout(new GridLayout(5, 2));

        nameLabel = new JLabel("姓名：");
        genderLabel = new JLabel("性别：");
        ageLabel = new JLabel("年龄：");
        majorLabel = new JLabel("专业：");

        nameText = new JTextField(20);
        genderText = new JTextField(20);
        ageText = new JTextField(20);
        majorText = new JTextField(20);

        addButton = new JButton("添加");
        cancelButton = new JButton("取消");

        addButton.addActionListener(this);
        cancelButton.addActionListener(this);

        add(nameLabel);
        add(nameText);
        add(genderLabel);
        add(genderText);
        add(ageLabel);
        add(ageText);
        add(majorLabel);
        add(majorText);
        add(addButton);
        add(cancelButton);

        pack();
        setLocationRelativeTo(null);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == addButton) {
            String name = nameText.getText().trim();
            String gender = genderText.getText().trim();
            int age = Integer.parseInt(ageText.getText().trim());
            String major = majorText.getText().trim();

            Connection conn = new DatabaseConnection().getConnection();
            try {
                PreparedStatement ps = conn.prepareStatement("INSERT INTO student VALUES (?, ?, ?, ?)");
                ps.setString(1, name);
                ps.setString(2, gender);
                ps.setInt(3, age);
                ps.setString(4, major);
                ps.executeUpdate();
                JOptionPane.showMessageDialog(this, "添加成功！");
                dispose();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        } else if (e.getSource() == cancelButton) {
            dispose();
        }
    }
}

4. 查询学生信息部分

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SearchFrame extends JFrame implements ActionListener {
    private JLabel nameLabel;
    private JTextField nameText;
    private JButton searchButton, cancelButton;
    private JTable table;

    public SearchFrame() {
        super("查询学生信息");
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        setLayout(new BorderLayout());

        nameLabel = new JLabel("姓名：");
        nameText = new JTextField(20);
        searchButton = new JButton("查询");
        cancelButton = new JButton("取消");

        searchButton.addActionListener(this);
        cancelButton.addActionListener(this);

        JPanel topPanel = new JPanel();
        topPanel.add(nameLabel);
        topPanel.add(nameText);
        topPanel.add(searchButton);
        topPanel.add(cancelButton);

        table = new JTable();
        JScrollPane scrollPane = new JScrollPane(table);

        add(topPanel, BorderLayout.NORTH);
        add(scrollPane, BorderLayout.CENTER);

        setSize(500, 300);
        setLocationRelativeTo(null);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == searchButton) {
            String name = nameText.getText().trim();

            Connection conn = new DatabaseConnection().getConnection();
            try {
                PreparedStatement ps = conn.prepareStatement("SELECT * FROM student WHERE name=?");
                ps.setString(1, name);
                ResultSet rs = ps.executeQuery();
                DefaultTableModel model = new DefaultTableModel();
                model.addColumn("姓名");
                model.addColumn("性别");
                model.addColumn("年龄");
                model.addColumn("专业");
                while (rs.next()) {
                    Object[] row = new Object[4];
                    row[0] = rs.getString("name");
                    row[1] = rs.getString("gender");
                    row[2] = rs.getInt("age");
                    row[3] = rs.getString("major");
                    model.addRow(row);
                }
                table.setModel(model);
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        } else if (e.getSource() == cancelButton) {
            dispose();
        }
    }
}

5. 修改学生信息部分

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UpdateFrame extends JFrame implements ActionListener {
    private JLabel nameLabel, genderLabel, ageLabel, majorLabel;
    private JTextField nameText, genderText, ageText, majorText;
    private JButton searchButton, updateButton, cancelButton;

    public UpdateFrame() {
        super("修改学生信息");
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        setLayout(new GridLayout(5, 2));

        nameLabel = new JLabel("姓名：");
        genderLabel = new JLabel("性别：");
        ageLabel = new JLabel("年龄：");
        majorLabel = new JLabel("专业：");

        nameText = new JTextField(20);
        genderText = new JTextField(20);
        ageText = new JTextField(20);
        majorText = new JTextField(20);

        searchButton = new JButton("查询");
        updateButton = new JButton("修改");
        cancelButton = new JButton("取消");

        searchButton.addActionListener(this);
        updateButton.addActionListener(this);
        cancelButton.addActionListener(this);

        nameText.setEditable(false);
        genderText.setEditable(false);
        ageText.setEditable(false);
        majorText.setEditable(false);

        add(nameLabel);
        add(nameText);
        add(genderLabel);
        add(genderText);
        add(ageLabel);
        add(ageText);
        add(majorLabel);
        add(majorText);
        add(updateButton);
        add(cancelButton);

        pack();
        setLocationRelativeTo(null);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == searchButton) {
            String name = JOptionPane.showInputDialog(this, "请输入要修改的学生姓名：");

            Connection conn = new DatabaseConnection().getConnection();
            try {
                PreparedStatement ps = conn.prepareStatement("SELECT * FROM student WHERE name=?");
                ps.setString(1, name);
                ResultSet rs = ps.executeQuery();
                if (rs.next()) {
                    nameText.setText(rs.getString("name"));
                    genderText.setText(rs.getString("gender"));
                    ageText.setText(Integer.toString(rs.getInt("age")));
                    majorText.setText(rs.getString("major"));
                    nameText.setEditable(true);
                    genderText.setEditable(true);
                    ageText.setEditable(true);
                    majorText.setEditable(true);
                } else {
                    JOptionPane.showMessageDialog(this, "未找到该学生信息！");
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        } else if (e.getSource() == updateButton) {
            String name = nameText.getText().trim();
            String gender = genderText.getText().trim();
            int age = Integer.parseInt(ageText.getText().trim());
            String major = majorText.getText().trim();

            Connection conn = new DatabaseConnection().getConnection();
            try {
                PreparedStatement ps = conn.prepareStatement("UPDATE student SET gender=?, age=?, major=? WHERE name=?");
                ps.setString(1, gender);
                ps.setInt(2, age);
                ps.setString(3, major);
                ps.setString(4, name);
                ps.executeUpdate();
                JOptionPane.showMessageDialog(this, "修改成功！");
                dispose();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        } else if (e.getSource() == cancelButton) {
            dispose();
        }
    }
}

6. 删除学生信息部分

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DeleteFrame extends JFrame implements ActionListener {
    private JLabel nameLabel;
    private JTextField nameText;
    private JButton searchButton, deleteButton, cancelButton;

    public DeleteFrame() {
        super("删除学生信息");
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        setLayout(new GridLayout(2, 2));

        nameLabel = new JLabel("姓名：");
        nameText = new JTextField(20);
        searchButton = new JButton("查询");
        deleteButton = new JButton("删除");
        cancelButton = new JButton("取消");

        searchButton.addActionListener(this);
        deleteButton.addActionListener(this);
        cancelButton.addActionListener(this);

        add(nameLabel);
        add(nameText);
        add(searchButton);
        add(deleteButton);
        add(cancelButton);

        pack();
        setLocationRelativeTo(null);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == searchButton) {
            String name = nameText.getText().trim();

            Connection conn = new DatabaseConnection().getConnection();
            try {
                PreparedStatement ps = conn.prepareStatement("SELECT * FROM student WHERE name=?");
                ps.setString(1, name);
                ResultSet rs = ps.executeQuery();
                if (rs.next()) {
                    int option = JOptionPane.showConfirmDialog(this, "是否确认删除该学生信息？");
                    if (option == JOptionPane.YES_OPTION) {
                        ps = conn.prepareStatement("DELETE FROM student WHERE name=?");
                        ps.setString(1, name);
                        ps.executeUpdate();
                        JOptionPane.showMessageDialog(this, "删除成功！");
                        dispose();
                    }
                } else {
                    JOptionPane.showMessageDialog(this, "未找到该学生信息！");
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        } else if (e.getSource() == deleteButton) {
            dispose();
        } else if (e.getSource() == cancelButton) {
            dispose();
        }
    }
}

7. 生成报告部分

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileOutputStream;
import java.net.URL;
import java.sql.Connection;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.util.JRLoader;
import net.sf.jasperreports.view.JasperViewer;

public class ReportFrame extends JFrame implements ActionListener {
    private JButton reportButton, cancelButton;

    public ReportFrame() {
        super("生成报告");
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        setLayout(new FlowLayout());

        reportButton = new JButton("生成报告");
        cancelButton = new JButton("取消");

        reportButton.addActionListener(this);
        cancelButton.addActionListener(this);

        add(reportButton);
        add(cancelButton);

        pack();
        setLocationRelativeTo(null);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == reportButton) {
            Connection conn = new DatabaseConnection().getConnection();
            try {
                URL url = getClass().getResource("/report/student_info.jrxml");
                JasperReport jasperReport = JasperCompileManager.compileReport(url.openStream());
                JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, conn);
                JasperViewer.viewReport(jasperPrint, false);

                File file = new File("D:/student_info.pdf");
                if (!file.exists()) {
                    file.createNewFile();
                }
                FileOutputStream fos = new FileOutputStream(file);
                net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfStream(jasperPrint, fos);
                fos.close();

                JOptionPane.showMessageDialog(this, "报告已生成！");
                dispose();
            } catch (Exception ex) {
                ex.printStackTrace();
            }
        } else if (e.getSource() == cancelButton) {
            dispose();
        }
    }
}

这是一个简单的学生信息管理系统的示例代码，您可以根据需求进行修改和完善。希望对您有帮助！