C/S Structural design database dormitory management system

Mainly used Java.swing And sql server Designed dormitory management system , There are some problems, welcome to correct .

Database settings

Connect to database (JDBC)

See how to connect to the database ：https://blog.csdn.net/weixin_45330449/article/details/107207913

package GUIdemo1;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBconnect {
    
    Connection dbConn;
    public DBconnect(){
    
        try {
    
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String dbURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=SSGL";
            dbConn = DriverManager.getConnection(dbURL, "sa", "sa");
        }catch(Exception ei) {
    
            ei.printStackTrace();
            System.out.println(" Failed to connect to database ！");
        }
    }
}

Interface settings

mainDisp class ：

public class mainDisp extends JFrame{
    
	JButton jb1,jb2;
	JPanel jp1,jp2,jp3;
	JLabel jl1,jl2;
	DBconnect DB = new DBconnect();
		
	public mainDisp() {
    
		super();

		jb1=new JButton(" Sushi ");
		jb2=new JButton(" Student ");
		jp1=new JPanel();
		jp2=new JPanel();
		jp3=new JPanel();
		jl1=new JLabel(" Dormitory management system ");
		jl2=new JLabel(" Please select login identity ");
		
		jl1.setFont(new Font(" Chinese Songti ",Font.BOLD|Font.PLAIN,40));
		jl1.setForeground(Color.black);
		jl2.setFont(new Font(" Chinese Songti ",Font.BOLD|Font.PLAIN,20));
		jl2.setForeground(Color.blue);
		
		

		jp1.add(jl1);
		jp2.add(jl2);
		jp3.add(jb1);
		jp3.add(jb2);
		setLayout(new GridLayout(3,1));
		add(jp1);
		add(jp2);
		add(jp3);
		
		setTitle(" The user login ");
		setSize(400,300);
		setLocationRelativeTo(null);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setVisible(true);
		
		
		jb1.addActionListener(new ActionListener() {
    
			public void actionPerformed(ActionEvent e) {
    
				setVisible(false);
				new dormitoryLogin();
				}});
		jb2.addActionListener(new ActionListener() {
    
			public void actionPerformed(ActionEvent e) {
    
				setVisible(false);
				new studentLogin();
				}});

	}
	public static void main(String[] args) {
    
		new mainDisp();
	}
}

dormSearch class ：

class dormSearch extends JDialog implements ActionListener {
    
	private JTextField jt;
	private JButton jb;
	private JComboBox cmb;
	private JPanel jp;
	private JTable table;
	private DefaultTableModel model;
	private DBconnect DB = new DBconnect();
	private String[] srr={
    "--- Please select the query method ---"," Query by dormitory "," By student number "};
	public dormSearch(){
    
		super();
		setLayout(new BorderLayout());
		setTitle(" Check in information ");
		setSize(500,300);
		setLocationRelativeTo(null);
		jt=new JTextField(10);
		jb = new JButton(" Inquire about ");
		jp = new JPanel();
		model=new DefaultTableModel();
		table=new JTable();
		table.setModel(model);
		JScrollPane jsp=new JScrollPane(table);
		cmb = new JComboBox(srr);
		add(jp,BorderLayout.NORTH);
		add(jsp,BorderLayout.CENTER);
		jp.add(cmb);
		jp.add(jt);
		jp.add(jb);
		jb.addActionListener(this);
		setVisible(true);
	}

	public void actionPerformed(ActionEvent e) {
    
		if (cmb.getSelectedIndex()==2) {
    
			model.setRowCount(0);
			model.setColumnCount(0);
			try {
    
				String str1=jt.getText();
				String sql = "select * from stay_info where Stu_num="+str1;
				Statement statement = DB.dbConn.createStatement();
				ResultSet res=statement.executeQuery(sql);
				// Get the number and name of columns in the table , As the title of the table component 
				ResultSetMetaData rsmd=res.getMetaData();
				// Get the number of columns 
				int count=rsmd.getColumnCount();
				 Add column names to the table model as headings 
				for(int i=1;i<=count;i++){
    
					model.addColumn(rsmd.getColumnName(i));
				}
				String[] row=new String[count];
				while(res.next()){
    
					for(int i=0;i<count;i++)
						row[i]=res.getString(i+1);
					// Add a row 
					model.addRow(row);
				}
				res.close();
			} catch (Exception ei) {
    
				ei.printStackTrace();
			}
		}
		else if (cmb.getSelectedIndex()==1){
    
			model.setRowCount(0);
			model.setColumnCount(0);
			try {
    
				String str1=jt.getText();
				String sql="select * from stay_info where Dorm_num="+str1;
				Statement statement=DB.dbConn.createStatement();
				ResultSet res=statement.executeQuery(sql);
				// Get the number and name of columns in the table , As the title of the table component 
				ResultSetMetaData rsmd=res.getMetaData();
				// Get the number of columns 
				int count=rsmd.getColumnCount();
				 Add column names to the table model as headings 
				for(int i=1;i<=count;i++){
    
					model.addColumn(rsmd.getColumnName(i));
				}
				String[] row=new String[count];
				while(res.next()){
    
					for(int i=0;i<count;i++)
						row[i]=res.getString(i+1);
					// Add a row 
					model.addRow(row);
				}
				res.close();
			}catch(Exception ei) {
    
				ei.printStackTrace();
			}
		}
	}
}

effect ：



Program download ：https://download.csdn.net/download/weixin_45330449/12589569
GitHub download ：https://github.com/As-Zach/Demo/blob/master/GUIdemo.zip