devbox
天景科技苑
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

数据库课程设计（学生宿舍管理系统）附sql文件、源代码和Word模板_学生宿舍管理系统数据库设计

作者：天景科技苑 | 2024-06-22 11:45:41

赞

踩

学生宿舍管理系统数据库设计

目录

一、功能要求

1、设计内容

2、学生宿舍管理系统主要功能

3、学生宿舍管理系统数据库表单（可以按照需求增、删、改）

二、系统需求分析

2.1 功能需求分析

2.2数据需求分析

2.3 业务规则及完整性约束分析

三、数据库概念结构设计

3.1 局部E-R图

四、 数据库物理结构设计

4.1创建数据库：

4.2创建Suguan表：

4.3创建qinshizhang表：

4.4创建student表：

4.5创建baoxun表：

4.6创建存储过程my

4.7另一种实现利用触发器实现当前时间

五、程序代码展示 

5.1登录界面

5.2寝室长 

 5.3宿管员

六、程序运行和数据库截图

六、源代码链接

一、功能要求

1、设计内容

设计一个学生宿舍管理系统，该系统的用户由寝室长和宿管员组成，不同的用户拥有不同的管理权限，各自完成各自的管理功能，首先是登录，登录的时候首先要判断用户的身份，合法的用户然后进入到系统主界面中，不同的用户看到不同的系统功能。

2、学生宿舍管理系统主要功能

（1）登录界面

（2）寝室长界面：寝室人员信息、保修操作、修改密码。

（3）管理员管理：查看学生住宿信息（按学号搜索、空白搜索全部）、管理学生住宿信息（添加学生住宿信息、删除学生住宿信息）、处理保修信息（修改处理状况）、管理学生账号（添加和删除）、修改密码。

3、学生宿舍管理系统数据库表单（可以按照需求增、删、改）

（1）寝室长信息表单：账号、密码

（2）宿管员信息表单：账号、密码

（3）报修信息表单：报修编号、寝楼、宿舍号、时间、问题、状况

（4）学生信息表单：学号、姓名、性别、专业、班级、宿舍号、寝楼、联系电话

二、系统需求分析

2.1 功能需求分析

首先，基本功能是登录。登录有两种身份：寝室长或宿管员。对于寝室长而言，系统中需要提供，寝室人员信息显示、报修功能、报修状态查看、修改密码的功能。对于管理员而言，系统需要提供查看学生住宿信息，管理学生住宿信息，处理报修，管理学生账号，修改密码的功能

图1.1 系统功能模块图

2.2数据需求分析

寝室长登录需要对寝室长采集账号和密码；

寝室人员信息显示：在界面上显示寝室人员的全部信息，由宿管员界面添加学生信息采集；

报修操作需要对寝室长采集寝楼、宿舍号、时间、问题的信息；

修改密码需要采集原密码和新密码；

宿管员登录需要对宿管员采集用户名和用户密码；

查看学生住宿信息:开始显示全部学生的信息，通过搜索按钮需要输入对应的学号（模糊匹配）、输入空白则搜索全部学生信息；

管理学生住宿信息：添加需要对学生采集学号、姓名、性别、专业、班级、宿舍号、寝楼、联系电话，删除学生信息只需要提供学生的学号；

处理报修：需要采集处理序号，选择处理的状况；

管理学生账号：需要采集学生的账号和密码后可以选择删除还是添加；

修改密码需要采集原密码和新密码；

2.3 业务规则及完整性约束分析

寝室长（账号、密码）

学生（学号、姓名、性别、专业、班级、宿舍号、寝楼、联系电话）

报修信息（报修编号、寝楼（外码）、宿舍号、时间、问题、状况）

宿管员（账号、密码）

三、数据库概念结构设计

3.1 局部E-R图

图2.1寝室长实体E-R图

图2.2顾客实体E-R图

图2.3订单实体E-R图

图2.4菜单实体E-R图

四、 数据库物理结构设计

4.1创建数据库：

CREATE database susheSystem;

4.2创建Suguan表：

  1. use susheSystem;
  2.  
  3. create table Suguan(
  4.  
  5.     Zhanghao CHAR(10)  PRIMARY KEY,
  6.  
  7.     Mima CHAR(20) NOT null
  8.  
  9. );

4.3创建qinshizhang表：

  1. create table qinshizhang(
  2.  
  3.     Zhanghao1 CHAR(10)  PRIMARY KEY,
  4.  
  5.     Mima1 CHAR(20) NOT null
  6.  
  7. );

4.4创建student表：

  1. CREATE Table student(
  2.  
  3.     Xuehao CHAR(20) PRIMARY KEY, #学号
  4.  
  5.     Name CHAR(10) NOT NULL, #姓名
  6.  
  7.     Sex CHAR(5) NOT NULL, #性别
  8.  
  9.     Specialistion CHAR(10) NOT NULL,#专业
  10.  
  11.     Class CHAR(10) NOT NULL,#班级
  12.  
  13.     Dormitory CHAR(10) NOT NULL,#宿舍号
  14.  
  15.     Qinlou CHAR(10) NOT NULL,#寝楼
  16.  
  17.     Phone CHAR(20)#电话
  18.  
  19. );

4.5创建baoxun表：

  1. CREATE TABLE baoxun(
  2.  
  3.     Number1 int(2) NOT NULL AUTO_INCREMENT,#报修编号
  4.  
  5.     Qinlou CHAR(10) NOT NULL,#寝楼
  6.  
  7.     Dormitory CHAR(10) NOT NULL,#宿舍号
  8.  
  9.     Time1 DATE ,#时间
  10.  
  11.     Question char(100) NOT NULL,#问题
  12.  
  13.     Situation char(10)  DEFAULT '等待处理',#状况
  14.  
  15.     PRIMARY KEY (Number1) USING BTREE,
  16.  
  17.     FOREIGN KEY (Qinlou) REFERENCES Suguan(zhanghao)
  18.  
  19. );

4.6创建存储过程my

  1. delimiter $
  2.  
  3. create procedure my()
  4.  
  5. begin
  6.  
  7.       alter table baoxun drop Number1;
  8.  
  9. alter table baoxun add Number1 int(2) not null auto_increment primary key first;
  10.  
  11. end $
  12.  
  13. delimiter ;
  14.  
  15. 设置定时事件
  16.  
  17. show variables like '%event_sche%';-- 查看事件计划是否开启
  18.  
  19. set global event_scheduler=1;
  20.  
  21. create event on1  on schedule every 1 second do call my();-- 创建定时事务

4.7另一种实现利用触发器实现当前时间

  1. /*delimiter $
  3. create procedure my(in id int)
  5. begin
  7.       declare ti date default 0;
  9.       set ti=curdate();
  11.       update  baoxun set Time1=ti where  Number1=id;
  13. end $
  15. delimiter ;
  17. delimiter $
  19. create trigger my1 after insert on baoxun for each row
  21. begin
  23.       call my(new.Number1);
  25. end $
  27. delimiter ;
  29. drop trigger if exists my;
  31. delimiter $
  33. create trigger my2 after insert on baoxun for each row
  35. begin
  37.       declare ti date default 0;
  39.       set ti=curdate();
  41.       update  baoxun set Time1=ti where  Number1=new.Number1;
  43. end $
  45. delimiter ;
  47. INSERT INTO baoxun(Qinlou,Dormitory,Question) VALUES ('紫园一栋', '107','门坏了');
  49. */

五、程序代码展示 

5.1登录界面

  1. package 学生宿舍管理系统;
  2.  
  3. import java.awt.*;
  4. import javax.swing.*;
  5. import javax.swing.JComboBox;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11. import java.sql.Statement;
  12. import java.awt.event.ActionEvent;
  13. import java.awt.event.ActionListener;
  14.  
  15. @SuppressWarnings("serial")
  16. public class 登录界面 extends JFrame implements ActionListener{
  17. 	//添加输入框【用户名输入框】
  18.     JTextField user1 = new JTextField(20);
  19.     //定义两个静态变量，提共账号和密码
  20.     public static String chaxu,pass1;
  21. 	String url = "jdbc:mysql://localhost:3306/sushesystem?useSSL=false&serverTimezone=UTC";
  22.     //添加下拉单
  23.     static JComboBox<Object> jc1 = new JComboBox<>();
  24.     //主方法
  25.     public static void main(String[] args) {
  26.        登录界面 a =new 登录界面();
  27.        a.界面();
  28.     }
  29.     //定义界面方法
  30.     public void 界面() {
  31.     	//创建主界面框架“登录”
  32.         JFrame jFrame = new JFrame("登录");
  33.         //设置窗口大小
  34.         jFrame.setSize(900,507);
  35.         //设置布局管理为null
  36.         jFrame.setLayout(null);
  37.         //添加标签{学生宿舍管理系统}
  38.         //创建一个标签并命名
  39.         JLabel textStudentManage = new JLabel("学生宿舍管理系统");
  40.         //设置颜色
  41.         textStudentManage.setForeground(new Color(0x0010FF)); 
  42.         //设置字体、大小
  43.         textStudentManage.setFont(new Font("微软雅黑", Font.PLAIN,30));
  44.         //设置标签的绝对位置
  45.         textStudentManage.setBounds(280,50,800,100);
  46.         //向框架中添加组件
  47.         jFrame.add(textStudentManage);
  48.          //添加标签【用户名】
  49.          JLabel textUser = new JLabel("用户名:");
  50.          textUser.setForeground(new Color(0xFF0000));
  51.          textUser.setFont(new Font("微软雅黑", Font.PLAIN,30));
  52.          textUser.setBounds(200,140,200,100);
  53.          jFrame.add(textUser);
  54.   
  55.          //添加输入框【用户名输入框】
  56.          user1.setFont(new Font("微软雅黑", Font.PLAIN,18));
  57.          user1.setSelectedTextColor(new Color(0xFF0000));
  58.          user1.setBounds(330,170,280,40);
  59.          jFrame.add(user1);
  60.   
  61.          //添加标签【密码】
  62.          JLabel textPassword = new JLabel("密  码  :");
  63.          textPassword.setForeground(new Color(0xFF0000));
  64.          textPassword.setFont(new Font("微软雅黑", Font.PLAIN,30));
  65.          textPassword.setBounds(200,200,200,100);
  66.          jFrame.add(textPassword);
  67.   
  68.          //添加密码输入框【密码】
  69.          JPasswordField password = new JPasswordField(20);
  70.          password.setBounds(330,230,280,40);
  71.          jFrame.add(password);
  72.  
  73.          //添加下拉单
  74.          jc1.setBounds(380,280,150,30);
  75.          jc1.addItem("宿管员");
  76.          jc1.addItem("寝室长");
  77.          jFrame.add(jc1);
  78.  
  79.          //添加按钮【登录】
  80.          JButton jButton = new JButton("登录");
  81.          jButton.setForeground(new Color(0x023BF6));
  82.          jButton.setBackground(new Color(0x38FF00));
  83.          jButton.setFont(new Font("微软雅黑", Font.PLAIN,20));
  84.          jButton.setBorderPainted(false);
  85.          jButton.setBounds(300,330,100,50);
  86.          jFrame.add(jButton);
  87.   
  88.          //添加按钮【注册】
  89.          JButton chongzhi = new JButton("重置");
  90.          chongzhi.setForeground(new Color(0x0029FF));
  91.          chongzhi.setBackground(new Color(0xECA871));
  92.          chongzhi.setFont(new Font("微软雅黑", Font.PLAIN,20));
  93.          chongzhi.setBorderPainted(false);
  94.          chongzhi.setBounds(500,330,100,50);
  95.          jFrame.add(chongzhi);
  96.          
  97.          //设置界面关闭，显示
  98.          jFrame.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
  99.          jFrame.setResizable(false);//false设置窗口大小不可改变
  100.          jFrame.setLocationRelativeTo(null);//将窗口置于屏幕的中央
  101.          jFrame.setVisible(true);//设置可见
  102.          chongzhi.addActionListener(new ActionListener(){//为重置按钮添加监听事件
  103.             //同时清空name、password的数据
  104.             public void actionPerformed(ActionEvent arg0) {
  105.                 user1.setText("");
  106.                 password.setText("");
  107.             }
  108.         });
  109.          
  110.          //设置登录按钮监听
  111.         jButton.addActionListener(new ActionListener(){
  112.             public void actionPerformed(ActionEvent arg0){
  113.             	//获取用户输入的密码和账号，并赋值给静态变量
  114.             	String name = user1.getText();
  115.             	chaxu = name;
  116. 				String pass = password.getText();
  117.                 pass1 = pass;
  118.                 //账号规范检测
  119.                 if (0 == name.length()) {
  120.                     JOptionPane.showMessageDialog(null, "账号不能为空");
  121.                     user1.grabFocus();
  122.                     return;
  123.                 }
  124.                 if (0 == pass.length()) {
  125.                     JOptionPane.showMessageDialog(null, "密码不可为空!");
  126.                     password.grabFocus();
  127.                     return;
  128.                 }
  129.                 //双界面登录判断
  130.                 if (jc1.getSelectedItem().toString().equals("宿管员")) {
  131.                     if (check(name, pass)) {
  132.                         JOptionPane.showMessageDialog(null, "登录成功");
  133.                         jFrame.dispose(); //关闭当前界面
  134.                         new 宿管员();
  135.                       
  136.                     } else
  137.                         JOptionPane.showMessageDialog(null, "密码错误");
  138.                 }
  139.                 if (jc1.getSelectedItem().toString().equals("寝室长")) {
  140.                     if (check(name, pass)) {
  141.                         JOptionPane.showMessageDialog(null, "登录成功");
  142.                         jFrame.dispose();
  143.                         new 寝室长();
  144.                     } else
  145.                         JOptionPane.showMessageDialog(null, "密码错误");
  146.                 }
  147.  
  148.             }
  149.  
  150.         });
  151. 	}
  152.     
  153.     //重写由继承actionlistener得到的方法   
  154.     @Override
  155.     public void actionPerformed(ActionEvent e) {
  156.         
  157.     }
  158.     
  159.     //定义账号密码检查方法check，从数据库获取账号信息
  160.     public static boolean check(String name, String password){
  161.         try {
  162.         	//数据库加载
  163.             Class.forName("com.mysql.cj.jdbc.Driver");
  164.             System.out.println("Success loading Mysql Driver!");
  165.         } catch (ClassNotFoundException e) {
  166.             e.printStackTrace();
  167.         }
  168.         boolean result = false;
  169.         try {
  170.         	//数据库信息定义和连接数据库
  171.             String url = "jdbc:mysql://localhost:3306/sushesystem?useSSL=false&serverTimezone=UTC";
  172.             String username = "root";
  173.             String passwords = "yu1314520";
  174.             Connection c = DriverManager.getConnection(url, username, passwords);
  175.             if (c != null) {
  176.                 System.out.println("数据库连接成功!");
  177.             } else {
  178.                 System.out.println("数据库连接失败!");
  179.             }
  180.             Statement s = c.createStatement();
  181.             //上面的是为了建立数据而做驱动准备以及连接测试。
  182.             
  183.             //账号登录判断，通过改变数据库查询代码来读取相应的表并验证账号、密码
  184.             if (jc1.getSelectedItem().toString().equals("宿管员")) {        //当用户选择“超级管理员”身份登录时
  185.                 String sql = "select * from suguan " + "where Zhanghao = '" + name + "' and Mima = '"    //查询
  186.                         + password + "'";
  187.                 ResultSet rs = s.executeQuery(sql);
  188.                 while (rs.next()) {
  189.                     if (rs.getString("Zhanghao").equals(name) && rs.getString("Mima").equals(password)) {    //如果用户输入的用户名和密码都和数据库中信息对得上。
  190.                         result = true;        //返回true
  191.                     } else {
  192.                         System.out.println(rs.getString("Zhanghao").equals(name));
  193.                         System.out.println(rs.getString("Mima").equals(password));
  194.                         return false;
  195.                     }
  196.                 }
  197.             } else {
  198.                 if (jc1.getSelectedItem().toString().equals("寝室长")) {        //当用户选择“供应商”身份登录时
  199.                     String sql = "select * from qinshizhang " + "where Zhanghao1 = '" + name + "' and Mima1 = '"
  200.                             + password + "'";
  201.                     ResultSet rs = s.executeQuery(sql);
  202.                     while (rs.next()) {
  203.                         if (rs.getString("Zhanghao1").equals(name)
  204.                                 && rs.getString("Mima1").equals(password)) {
  205.                             result = true; // 如果用户名和密码都正确，那么就将result返回为true；
  206.                         } else {
  207.                             return false;
  208.                         }
  209.                     }
  210.                 }
  211.  
  212.  
  213.             }
  214.            c.close();
  215.         }catch (SQLException e2) {
  216.             e2.printStackTrace();
  217.         }
  218.         //返回验证结果
  219.         return result;
  220.  
  221.     }
  222. }

5.2寝室长 

  1. package 学生宿舍管理系统;
  2.  
  3. import java.awt.Color;
  4. import java.awt.Dimension;
  5. import java.awt.Font;
  6. import java.awt.event.ActionEvent;
  7. import java.awt.event.ActionListener;
  8. import java.sql.Connection;
  9. import java.sql.PreparedStatement;
  10. import java.sql.ResultSet;
  11.  
  12. import javax.swing.JButton;
  13. import javax.swing.JFrame;
  14. import javax.swing.JLabel;
  15. import javax.swing.JOptionPane;
  16. import javax.swing.JPanel;
  17. import javax.swing.JPasswordField;
  18. import javax.swing.JScrollPane;
  19. import javax.swing.JTabbedPane;
  20. import javax.swing.JTable;
  21. import javax.swing.JTextArea;
  22. import javax.swing.JTextField;
  23.  
  24. public class 寝室长 extends JFrame{
  25. 	JTabbedPane jbb = new JTabbedPane(JTabbedPane.TOP);
  26. 	Connection connection = new GetConnection().GetConnection();
  27. 	JPanel 寝室人员,报修,修改密码;
  28. 	登录界面 c = new 登录界面();
  29. 	String a = c.chaxu;//"紫园一栋107";//c.chaxu;
  30. 	String pass1 = c.pass1;//"12345678";//c.pass1;
  31. 	public 寝室长() {
  32. 		 this.setTitle("寝室长界面");
  33. 		 this.setSize(800,600);
  34. 		 this.setLayout(null);
  35. 		 this.setLocation(400,400);
  36. 		 this.setVisible(true); 
  37. 		 寝室人员 = new JPanel();
  38. 		 寝室人员.setSize(700,500);
  39. 		 报修 = new JPanel();
  40. 		 报修.setSize(700,500);
  41. 		 报修.setLayout(null);
  42. 		 修改密码 = new JPanel();
  43. 		 修改密码.setSize(700,500);
  44. 		 修改密码.setLayout(null);
  45. 		 jbb.addTab("寝室人员", 寝室人员);
  46. 		 jbb.addTab("报修", 报修);
  47. 		 jbb.addTab("修改密码", 修改密码);
  48. 		 this.setContentPane(jbb);
  49. 		 this.寝室人员界面();
  50. 		 this.报修();
  51. 		 this.修改密码();
  52. 	}
  53. 	public void 寝室人员界面() {
  54. 		JScrollPane scpDome = new JScrollPane();
  55. 		scpDome.setPreferredSize(new Dimension(700, 400));
  56. 		寝室人员.add(scpDome);
  57. 		//Connection connection = new GetConnection().GetConnection();
  58. 		String sql = "select * from student where Dormitory='"+a.substring(4,7)+"'and Qinlou='"+a.substring(0,4)+"'";
  59.         try {
  60.         	PreparedStatement state;
  61.             ResultSet re;
  62.         	state=connection.prepareStatement(sql);
  63.             re=state.executeQuery();
  64.             int count=0;
  65.             while(re.next()) {
  66.             	count++;
  67.             }
  68.             re = state.executeQuery();
  69.             Object[][] info= new Object[count][8];
  70.             count = 0;
  71.             while(re.next()) {
  72.                 info[count][0]=re.getString("Xuehao");
  73.                 info[count][1]=re.getString("Name");
  74.                 info[count][2]=re.getString("Sex");
  75.                 info[count][3]=re.getString("Specialistion");
  76.                 info[count][4]=re.getString("Class");
  77.                 info[count][5]=re.getString("Dormitory");
  78.                 info[count][6]=re.getString("Qinlou");
  79.                 info[count][7]=re.getString("Phone");
  80.                 count++;
  81.             }
  82.             String[] title = {"学号","姓名","性别","专业","班级","宿舍号","寝楼","联系电话"};
  83.             JTable tabDome = new JTable(info,title);
  84.             //JTableHeader jth = tabDome.getTableHeader();
  85.             scpDome.getViewport().add(tabDome);
  86. //            connection.close();
  87.         }catch (Exception e) {
  88.         	e.printStackTrace();
  89. 		}		
  90. 	}
  91. 	public void 报修() {
  92. 		JScrollPane scpDome1 = new JScrollPane();
  93. 		scpDome1.setBounds(5,5,400,400);
  94. 		报修.add(scpDome1);
  95. 		//Connection connection1 = new GetConnection().GetConnection();
  96. 		String sql = "select * from baoxun where Dormitory='"+a.substring(4,7)+"'and Qinlou='"+a.substring(0,4)+"'";
  97.         try {
  98.         	PreparedStatement state;
  99.             ResultSet re;
  100.         	state=connection.prepareStatement(sql);
  101.             re=state.executeQuery();
  102.             int count=0;
  103.             while(re.next()) {
  104.             	count++;
  105.             }
  106.             re = state.executeQuery();
  107.             Object[][] info= new Object[count][6];
  108.             count = 0;
  109.             while(re.next()) {
  110.                 info[count][0]=Integer.valueOf(re.getString("Number1"));
  111.                 info[count][1]=re.getString("Qinlou");
  112.                 info[count][2]=re.getString("Dormitory");
  113.                 info[count][3]=re.getString("Time1");
  114.                 info[count][4]=re.getString("Question");
  115.                 info[count][5]=re.getString("Situation");
  116.                 count++;
  117.             }
  118.             String[] title = {"报修编号","寝楼","宿舍号","时间","问题","状况"};
  119.             JTable tabDome = new JTable(info,title);
  120.             //JTableHeader jth = tabDome.getTableHeader();
  121.             scpDome1.getViewport().add(tabDome);
  122.             //connection.close();
  123.         }catch (Exception e) {
  124.         	e.printStackTrace();
  125. 		}
  126.         
  127.         JLabel r1 = new JLabel("寝   楼:");
  128.         r1.setForeground(new Color(000));
  129.         r1.setFont(new Font("微软雅黑", Font.PLAIN,20));
  130.         r1.setBounds(430,10,100,100);
  131.         报修.add(r1);
  132.         
  133.         JTextField b1 = new JTextField(5);
  134.         b1.setFont(new Font("微软雅黑", Font.PLAIN,18));
  135.         b1.setSelectedTextColor(new Color(0xFF0000));
  136.         b1.setBounds(500,40,180,40);
  137.         报修.add(b1);
  138.         
  139.         JLabel r2 = new JLabel("宿舍号:");
  140.         r2.setForeground(new Color(000));
  141.         r2.setFont(new Font("微软雅黑", Font.PLAIN,20));
  142.         r2.setBounds(430,72,100,100);
  143.         报修.add(r2);
  144.         
  145.         JTextField b2 = new JTextField(5);
  146.         b2.setFont(new Font("微软雅黑", Font.PLAIN,18));
  147.         b2.setSelectedTextColor(new Color(0xFF0000));
  148.         b2.setBounds(500,100,180,40);
  149.         报修.add(b2);
  150.         
  151.         JLabel r3 = new JLabel("时   间:");
  152.         r3.setForeground(new Color(000));
  153.         r3.setFont(new Font("微软雅黑", Font.PLAIN,20));
  154.         r3.setBounds(430,134,100,100);
  155.         报修.add(r3);
  156.         
  157.         JTextField b3 = new JTextField(5);
  158.         b3.setFont(new Font("微软雅黑", Font.PLAIN,18));
  159.         b3.setSelectedTextColor(new Color(0xFF0000));
  160.         b3.setBounds(500,170,180,40);
  161.         报修.add(b3);
  162.         
  163.         JLabel r4 = new JLabel("问   题:");
  164.         r4.setForeground(new Color(000));
  165.         r4.setFont(new Font("微软雅黑", Font.PLAIN,20));
  166.         r4.setBounds(430,196,100,100);
  167.         报修.add(r4);
  168.         
  169.         JTextArea b4 = new JTextArea();
  170.         b4.setFont(new Font("微软雅黑", Font.PLAIN,18));
  171.         b4.setSelectedTextColor(new Color(0xFF0000));
  172.         b4.setBounds(500,230,180,100);
  173.         报修.add(b4);
  174.         
  175.         JButton j1 = new JButton("报 修");
  176.         j1.setForeground(new Color(128));
  177.         j1.setBackground(new Color(225,225,255));
  178.         j1.setFont(new Font("微软雅黑", Font.PLAIN,20));
  179.         j1.setBorderPainted(false);
  180.         j1.setBounds(530,360,120,40);
  181.         报修.add(j1);
  182.         
  183.         j1.addActionListener(new ActionListener(){
  184.             public void actionPerformed(ActionEvent arg0){
  185.             	String a1 = b1.getText();
  186.                 String a2 = b2.getText();
  187.                 String a3 = b3.getText();
  188.                 String a4 = b4.getText();
  189.                 b1.setText("");
  190.                 b2.setText("");
  191.                 b3.setText("");
  192.                 b4.setText("");
  193.                 if(a1.equals(a.substring(0,4))&& a2.equals(a.substring(4,7))) {
  194. 	            	//Connection connection2 = new GetConnection().GetConnection();
  195. 	        		String sql = "insert into baoxun(Qinlou,Dormitory,Time1,Question) values('"+a1+"','"+a2+"','"+a3+"','"+a4+"');";
  196. 	                try {
  197. 	                	PreparedStatement state;
  198. 	                	state=(PreparedStatement)connection.prepareStatement(sql);
  199. 	                	state.executeUpdate();
  200. 	                	JOptionPane.showMessageDialog(null, "报修成功！");
  201. 	                }catch (Exception e) {
  202. 	                	JOptionPane.showMessageDialog(null, "报修失败！");
  203. 	                	System.out.println("报修失败");
  204. 	                	e.printStackTrace();
  205. 					}finally {
  206. 						报修.remove(scpDome1);
  207. 						JScrollPane scpDome1 = new JScrollPane();
  208. 						scpDome1.setBounds(5,5,400,400);
  209. 						报修.add(scpDome1);
  210. 						//Connection connection1 = new GetConnection().GetConnection();
  211. 						String sql1 = "select * from baoxun where Dormitory='"+a.substring(4,7)+"'and Qinlou='"+a.substring(0,4)+"'";
  212. 				        try {
  213. 				        	PreparedStatement state;
  214. 				            ResultSet re;
  215. 				        	state=connection.prepareStatement(sql1);
  216. 				            re=state.executeQuery();
  217. 				            int count=0;
  218. 				            while(re.next()) {
  219. 				            	count++;
  220. 				            }
  221. 				            re = state.executeQuery();
  222. 				            Object[][] info= new Object[count][6];
  223. 				            count = 0;
  224. 				            while(re.next()) {
  225. 				                info[count][0]=Integer.valueOf(re.getString("Number1"));
  226. 				                info[count][1]=re.getString("Qinlou");
  227. 				                info[count][2]=re.getString("Dormitory");
  228. 				                info[count][3]=re.getString("Time1");
  229. 				                info[count][4]=re.getString("Question");
  230. 				                info[count][5]=re.getString("Situation");
  231. 				                count++;
  232. 				            }
  233. 				            String[] title = {"报修编号","寝楼","宿舍号","时间","问题","状况"};
  234. 				            JTable tabDome = new JTable(info,title);
  235. 				            //JTableHeader jth = tabDome.getTableHeader();
  236. 				            scpDome1.getViewport().add(tabDome);
  237. 				            //connection.close();
  238. 				        }catch (Exception e) {
  239. 				        	e.printStackTrace();
  240. 						}
  241. 					}
  242. 	            }
  243.                 else {
  244.                 	JOptionPane.showMessageDialog(null, "输入有误！");
  245.                 }
  246.             }
  247.         });
  248. 	}
  249. 	public void 修改密码() {
  250. 		
  251. 		JLabel title = new JLabel("修 改 密 码");
  252. 		title.setForeground(new Color(000));
  253. 		title.setFont(new Font("华文行楷", Font.PLAIN,40));
  254. 		title.setBounds(300,20,200,200);
  255.         修改密码.add(title);
  256. 		
  257.         JLabel x1 = new JLabel("原密码:");
  258.         x1.setForeground(new Color(000));
  259.         x1.setFont(new Font("微软雅黑", Font.PLAIN,30));
  260.         x1.setBounds(200,140,100,100);
  261.         修改密码.add(x1);
  262.         
  263.         JPasswordField password1 = new JPasswordField(20);
  264.         password1.setBounds(330,177,250,30);
  265.         修改密码.add(password1);
  266. //        JTextField y1 = new JTextField(5);
  267. //        y1.setFont(new Font("微软雅黑", Font.PLAIN,18));
  268. //        y1.setSelectedTextColor(new Color(0xFF0000));
  269. //        y1.setBounds(340,170,250,40);
  270. //        修改密码.add(y1);
  271.         
  272.         JLabel x2 = new JLabel("新密码:");
  273.         x2.setForeground(new Color(000));
  274.         x2.setFont(new Font("微软雅黑", Font.PLAIN,30));
  275.         x2.setBounds(200,200,100,100);
  276.         修改密码.add(x2);
  277.         
  278.         JPasswordField password2 = new JPasswordField(20);
  279.         password2.setBounds(330,238,250,30);
  280.         修改密码.add(password2);
  281. //        JTextField y2 = new JTextField(5);
  282. //        y2.setFont(new Font("微软雅黑", Font.PLAIN,18));
  283. //        y2.setSelectedTextColor(new Color(0xFF0000));
  284. //        y2.setBounds(340,230,250,40);
  285. //        修改密码.add(y2);
  286.         JButton jb1 = new JButton("修 改");
  287.         jb1.setForeground(new Color(16711680));
  288.         jb1.setBackground(new Color(5526612));
  289.         jb1.setFont(new Font("华文行楷", Font.PLAIN,30));
  290.         jb1.setBorderPainted(false);
  291.         jb1.setBounds(360,300,130,40);
  292.         修改密码.add(jb1);
  293.         
  294.         jb1.addActionListener(new ActionListener(){
  295.             public void actionPerformed(ActionEvent arg0){
  296.             	String a1 = password1.getText();
  297.                 String a2 = password2.getText();
  298.                 password1.setText("");
  299.                 password2.setText("");
  300.                 
  301.                 if(a1.equals(pass1)) {
  302. 	            	//Connection connection2 = new GetConnection().GetConnection();
  303. 	        		String sql = "update qinshizhang set Mima1 = '"+a2+"' where Zhanghao1 = '"+a+"'";
  304. 	                try {
  305. 	                	PreparedStatement state;
  306. 	                	state=(PreparedStatement)connection.prepareStatement(sql);
  307. 	                	state.executeUpdate();
  308. 	                	JOptionPane.showMessageDialog(null, "修改成功,请重新登录本系统！");
  309. 	                	connection.close();
  310. 	                }catch (Exception e) {
  311. 	                	JOptionPane.showMessageDialog(null, "修改失败！");
  312. 	                	System.out.println("修改失败");
  313. 	                	e.printStackTrace();
  314. 					}finally {
  315. 						System.exit(0);
  316. 					}
  317. 	            }
  318.                 else {
  319.                 	JOptionPane.showMessageDialog(null, "原密码输入有误！");
  320.                 }
  321.             }
  322.         });
  323. 	}
  324. 	public static void main(String[] args) {
  325. 		new 寝室长();
  326. 	}
  327. }

 5.3宿管员

  1. package 学生宿舍管理系统;
  2.  
  3. import java.awt.Color;
  4. import java.awt.Dimension;
  5. import java.awt.Font;
  6. import java.awt.event.ActionEvent;
  7. import java.awt.event.ActionListener;
  8. import java.sql.Connection;
  9. import java.sql.PreparedStatement;
  10. import java.sql.ResultSet;
  11.  
  12. import javax.swing.JButton;
  13. import javax.swing.JComboBox;
  14. import javax.swing.JFrame;
  15. import javax.swing.JLabel;
  16. import javax.swing.JMenu;
  17. import javax.swing.JMenuBar;
  18. import javax.swing.JOptionPane;
  19. import javax.swing.JPanel;
  20. import javax.swing.JPasswordField;
  21. import javax.swing.JScrollPane;
  22. import javax.swing.JTabbedPane;
  23. import javax.swing.JTable;
  24. import javax.swing.JTextField;
  25.  
  26. public class 宿管员 extends JFrame{
  27. 	JLabel jlabel=new JLabel();
  28. 	JScrollPane scpDome = new JScrollPane();
  29. 	JTabbedPane jbb = new JTabbedPane(JTabbedPane.LEFT);
  30. 	Connection connection = new GetConnection().GetConnection();
  31. 	JPanel 查看学生住宿信息,管理学生住宿信息,处理报修信息,管理学生账号,修改密码;
  32. 	登录界面 c = new 登录界面();
  33. 	String a = c.chaxu;//"紫园一栋";//c.chaxu;
  34. 	String pass1 = c.pass1;//"12345678";//c.pass1;
  35. 	public 宿管员() {
  36. 		 this.setTitle("宿管员界面");
  37. 		 this.setSize(800,800);
  38. 		 this.setLayout(null);
  39. 		 this.setLocation(350,50);
  40. 		 this.setVisible(true); 
  41. 		 
  42. 		 查看学生住宿信息 = new JPanel();
  43. 		 查看学生住宿信息.setSize(750,750);
  44. 		 查看学生住宿信息.setLayout(null);
  45. 		 
  46. 		 管理学生住宿信息 = new JPanel();
  47. 		 管理学生住宿信息.setSize(750,750);
  48. 		 管理学生住宿信息.setLayout(null);
  49. 		 
  50. 		 处理报修信息 = new JPanel();
  51. 		 处理报修信息.setSize(750,750);
  52. 		 处理报修信息.setLayout(null);
  53. 		 
  54. 		 管理学生账号 = new JPanel();
  55. 		 管理学生账号.setSize(750,750);
  56. 		 管理学生账号.setLayout(null);
  57. 		 
  58. 		 修改密码 = new JPanel();
  59. 		 修改密码.setSize(700,500);
  60. 		 修改密码.setLayout(null);
  61. 		 jbb.addTab("查看学生住宿信息", 查看学生住宿信息);
  62. 		 jbb.addTab("管理学生住宿信息", 管理学生住宿信息);
  63. 		 jbb.addTab("处理报修信息", 处理报修信息);
  64. 		 jbb.addTab("管理学生账号", 管理学生账号);
  65. 		 jbb.addTab("修改密码", 修改密码);
  66. 		 this.setContentPane(jbb);
  67. 		 this.查看学生住宿信息();
  68. 		 this.管理学生住宿信息();
  69. 		 this.处理报修信息();
  70. 		 this.管理学生账号();
  71. 		 this.修改密码();
  72. 	}
  73. 	public void 查看学生住宿信息() {
  74. 		
  75. 		JLabel title1 = new JLabel("查看学生住宿信息");
  76. 		title1.setForeground(new Color(000));
  77. 		title1.setFont(new Font("华文行楷", Font.PLAIN,30));
  78. 		title1.setBounds(186,10,326,40);
  79. 		查看学生住宿信息.add(title1);
  80. 		
  81.         JButton jbt1 = new JButton("搜索");
  82.         jbt1.setForeground(new Color(16711680));
  83.         jbt1.setBackground(new Color(13487565));
  84.         jbt1.setFont(new Font("华文行楷", Font.PLAIN,13));
  85.         jbt1.setBorderPainted(false);
  86.         jbt1.setBounds(165,65,60,18);
  87.         查看学生住宿信息.add(jbt1);
  88.         
  89.         JTextField b1 = new JTextField(25);
  90.         b1.setFont(new Font("微软雅黑", Font.PLAIN,15));
  91.         b1.setSelectedTextColor(new Color(0xFF0000));
  92.         b1.setBounds(5,65,160,20);
  93.         查看学生住宿信息.add(b1);
  94. 		
  95. 		//JScrollPane scpDome = new JScrollPane();
  96. 		scpDome.setBounds(5,85,650,600);
  97. 		查看学生住宿信息.add(scpDome);
  98. 		//Connection connection = new GetConnection().GetConnection();
  99. 		String sql = "select * from student where Qinlou='"+a+"'";
  100.         try {
  101.         	PreparedStatement state;
  102.             ResultSet re;
  103.         	state=connection.prepareStatement(sql);
  104.             re=state.executeQuery();
  105.             int count=0;
  106.             while(re.next()) {
  107.             	count++;
  108.             }
  109.             re = state.executeQuery();
  110.             Object[][] info= new Object[count][8];
  111.             count = 0;
  112.             while(re.next()) {
  113.             	info[count][0]=re.getString("Xuehao");
  114.             	info[count][1]=re.getString("Name");
  115.             	info[count][2]=re.getString("Sex");
  116.             	info[count][3]=re.getString("Specialistion");
  117.             	info[count][4]=re.getString("Class");
  118.             	info[count][5]=re.getString("Dormitory");
  119.             	info[count][6]=re.getString("Qinlou");
  120.             	info[count][7]=re.getString("Phone");
  121.             	count++;
  122.             }
  123.             String[] title = {"学号","姓名","性别","专业","班级","宿舍号","寝楼","联系电话"};
  124.             JTable tabDome = new JTable(info,title);
  125.             //JTableHeader jth = tabDome.getTableHeader();
  126.             scpDome.getViewport().add(tabDome);
  127. //            connection.close();
  128.         }catch (Exception e) {
  129.         	e.printStackTrace();
  130. 		}
  131.         
  132.         jbt1.addActionListener(new ActionListener(){
  133.             public void actionPerformed(ActionEvent arg0){
  134.             	String a1 = b1.getText();
  135.             	b1.setText("");
  136.                 if(a1.equals("")) {
  137.                 	
  138.                 	查看学生住宿信息.remove(scpDome);
  139. 					//JScrollPane scpDome = new JScrollPane();
  140. 					scpDome.setBounds(5,85,650,600);
  141. 					查看学生住宿信息.add(scpDome);
  142. 					//Connection connection = new GetConnection().GetConnection();
  143. 					String sql2 = "select * from student where Qinlou='"+a+"'";
  144. 			        try {
  145. 			        	PreparedStatement state;
  146. 			            ResultSet re;
  147. 			        	state=connection.prepareStatement(sql2);
  148. 			            re=state.executeQuery();
  149. 			            int count=0;
  150. 			            while(re.next()) {
  151. 			            	count++;
  152. 			            }
  153. 			            re = state.executeQuery();
  154. 			            Object[][] info= new Object[count][8];
  155. 			            count = 0;
  156. 			            while(re.next()) {
  157. 			                info[count][0]=re.getString("Xuehao");
  158. 			                info[count][1]=re.getString("Name");
  159. 			                info[count][2]=re.getString("Sex");
  160. 			                info[count][3]=re.getString("Specialistion");
  161. 			                info[count][4]=re.getString("Class");
  162. 			                info[count][5]=re.getString("Dormitory");
  163. 			                info[count][6]=re.getString("Qinlou");
  164. 			                info[count][7]=re.getString("Phone");
  165. 			                count++;
  166. 			            }
  167. 			            String[] title = {"学号","姓名","性别","专业","班级","宿舍号","寝楼","联系电话"};
  168. 			            JTable tabDome = new JTable(info,title);
  169. 			            //JTableHeader jth = tabDome.getTableHeader();
  170. 			            scpDome.getViewport().add(tabDome);
  171. //			            connection.close();
  172. 			        }catch (Exception e) {
  173. 			        	e.printStackTrace();
  174. 			        }
  175.                 }else {
  176.                 	//Connection connection2 = new GetConnection().GetConnection();
  177.                 	scpDome.setBounds(5,85,650,600);
  178.             		查看学生住宿信息.add(scpDome);
  179.             		//Connection connection = new GetConnection().GetConnection();
  180.             		String sql1 = "select * from student where Xuehao like '%"+a1+"%'";
  181.                     try {
  182.                     	PreparedStatement state;
  183.                         ResultSet re;
  184.                     	state=connection.prepareStatement(sql1);
  185.                         re=state.executeQuery();
  186.                         int count=0;
  187.                         while(re.next()) {
  188.                         	count++;
  189.                         }
  190.                         if(count==0) {
  191.                         	JOptionPane.showMessageDialog(null, "搜索失败,该学号不存在！");
  192.                         	System.out.println("搜索失败,该学号不存在！");
  193.                         }
  194.                         re = state.executeQuery();
  195.                         Object[][] info= new Object[count][8];
  196.                         count = 0;
  197.                         while(re.next()) {
  198.                             info[count][0]=re.getString("Xuehao");
  199.                             info[count][1]=re.getString("Name");
  200.                             info[count][2]=re.getString("Sex");
  201.                             info[count][3]=re.getString("Specialistion");
  202.                             info[count][4]=re.getString("Class");
  203.                             info[count][5]=re.getString("Dormitory");
  204.                             info[count][6]=re.getString("Qinlou");
  205.                             info[count][7]=re.getString("Phone");
  206.                             count++;
  207.                         }
  208.                         String[] title = {"学号","姓名","性别","专业","班级","宿舍号","寝楼","联系电话"};
  209.                         JTable tabDome = new JTable(info,title);
  210.                         //JTableHeader jth = tabDome.getTableHeader();
  211.                         scpDome.getViewport().add(tabDome);
  212. //                        connection.close();
  213.                     }catch (Exception e) {
  214.                     	JOptionPane.showMessageDialog(null, "搜索失败,该学号不存在！");
  215.                     	System.out.println("搜索失败,该学号不存在！");
  216.                     	e.printStackTrace();
  217.             		} 
  218.                 }
  219.             }
  220.         });
  221. 	}
  222. 	public void 管理学生住宿信息() {
  223. 		
  224. 		JLabel title1 = new JLabel("添加学生住宿信息");
  225. 		title1.setForeground(new Color(000));
  226. 		title1.setFont(new Font("华文行楷", Font.PLAIN,30));
  227. 		title1.setBounds(186,20,326,40);
  228. 		管理学生住宿信息.add(title1);
  229. 		
  230. 		JLabel r1 = new JLabel("学  号:");
  231.         r1.setForeground(new Color(000));
  232.         r1.setFont(new Font("微软雅黑", Font.PLAIN,20));
  233.         r1.setBounds(77,50,100,100);
  234.         管理学生住宿信息.add(r1);
  235.         
  236.         JTextField b1 = new JTextField(25);
  237.         b1.setFont(new Font("微软雅黑", Font.PLAIN,15));
  238.         b1.setSelectedTextColor(new Color(0xFF0000));
  239.         b1.setBounds(140,90,160,30);
  240.         管理学生住宿信息.add(b1);
  241.         
  242.         JLabel r2 = new JLabel("姓     名:");
  243.         r2.setForeground(new Color(000));
  244.         r2.setFont(new Font("微软雅黑", Font.PLAIN,20));
  245.         r2.setBounds(350,50,100,100);
  246.         管理学生住宿信息.add(r2);
  247.         
  248.         JTextField b2 = new JTextField(25);
  249.         b2.setFont(new Font("微软雅黑", Font.PLAIN,15));
  250.         b2.setSelectedTextColor(new Color(0xFF0000));
  251.         b2.setBounds(440,90,160,30);
  252.         管理学生住宿信息.add(b2);
  253.         
  254.         JLabel r3 = new JLabel("性  别:");
  255.         r3.setForeground(new Color(000));
  256.         r3.setFont(new Font("微软雅黑", Font.PLAIN,20));
  257.         r3.setBounds(77,100,100,100);
  258.         管理学生住宿信息.add(r3);
  259.         
  260.         JTextField b3 = new JTextField(25);
  261.         b3.setFont(new Font("微软雅黑", Font.PLAIN,15));
  262.         b3.setSelectedTextColor(new Color(0xFF0000));
  263.         b3.setBounds(140,135,160,30);
  264.         管理学生住宿信息.add(b3);
  265.         
  266.         JLabel r4 = new JLabel("专     业:");
  267.         r4.setForeground(new Color(000));
  268.         r4.setFont(new Font("微软雅黑", Font.PLAIN,20));
  269.         r4.setBounds(350,100,100,100);
  270.         管理学生住宿信息.add(r4);
  271.         
  272.         JTextField b4 = new JTextField(25);
  273.         b4.setFont(new Font("微软雅黑", Font.PLAIN,15));
  274.         b4.setSelectedTextColor(new Color(0xFF0000));
  275.         b4.setBounds(440,135,160,30);
  276.         管理学生住宿信息.add(b4);
  277.         
  278.         JLabel r5 = new JLabel("班  级:");
  279.         r5.setForeground(new Color(000));
  280.         r5.setFont(new Font("微软雅黑", Font.PLAIN,20));
  281.         r5.setBounds(77,150,100,100);
  282.         管理学生住宿信息.add(r5);
  283.         
  284.         JTextField b5 = new JTextField(25);
  285.         b5.setFont(new Font("微软雅黑", Font.PLAIN,15));
  286.         b5.setSelectedTextColor(new Color(0xFF0000));
  287.         b5.setBounds(140,188,160,30);
  288.         管理学生住宿信息.add(b5);
  289.         
  290.         JLabel r6 = new JLabel("宿 舍 号:");
  291.         r6.setForeground(new Color(000));
  292.         r6.setFont(new Font("微软雅黑", Font.PLAIN,20));
  293.         r6.setBounds(350,150,100,100);
  294.         管理学生住宿信息.add(r6);
  295.         
  296.         JTextField b6 = new JTextField(25);
  297.         b6.setFont(new Font("微软雅黑", Font.PLAIN,15));
  298.         b6.setSelectedTextColor(new Color(0xFF0000));
  299.         b6.setBounds(440,188,160,30);
  300.         管理学生住宿信息.add(b6);
  301.         
  302.         JLabel r7 = new JLabel("寝  楼:");
  303.         r7.setForeground(new Color(000));
  304.         r7.setFont(new Font("微软雅黑", Font.PLAIN,20));
  305.         r7.setBounds(77,200,100,100);
  306.         管理学生住宿信息.add(r7);
  307.         
  308.         JTextField b7 = new JTextField(25);
  309.         b7.setFont(new Font("微软雅黑", Font.PLAIN,15));
  310.         b7.setSelectedTextColor(new Color(0xFF0000));
  311.         b7.setBounds(140,238,160,30);
  312.         管理学生住宿信息.add(b7);
  313.         
  314.         JLabel r8 = new JLabel("联系电话:");
  315.         r8.setForeground(new Color(000));
  316.         r8.setFont(new Font("微软雅黑", Font.PLAIN,20));
  317.         r8.setBounds(350,200,100,100);
  318.         管理学生住宿信息.add(r8);
  319.         
  320.         JTextField b8 = new JTextField(25);
  321.         b8.setFont(new Font("微软雅黑", Font.PLAIN,15));
  322.         b8.setSelectedTextColor(new Color(0xFF0000));
  323.         b8.setBounds(440,238,160,30);
  324.         管理学生住宿信息.add(b8);
  325.         
  326.         JButton jbt1 = new JButton("添 加");
  327.         jbt1.setForeground(new Color(16711680));
  328.         jbt1.setBackground(new Color(13487565));
  329.         jbt1.setFont(new Font("华文行楷", Font.PLAIN,30));
  330.         jbt1.setBorderPainted(false);
  331.         jbt1.setBounds(150,300,130,40);
  332.         管理学生住宿信息.add(jbt1);
  333.         
  334.         JButton jbt2 = new JButton("重 置");
  335.         jbt2.setForeground(new Color(16711680));
  336.         jbt2.setBackground(new Color(13487565));
  337.         jbt2.setFont(new Font("华文行楷", Font.PLAIN,30));
  338.         jbt2.setBorderPainted(false);
  339.         jbt2.setBounds(370,300,130,40);
  340.         管理学生住宿信息.add(jbt2);
  341.         
  342.         jbt2.addActionListener(new ActionListener(){//为重置按钮添加监听事件
  343.             //同时清空name、password的数据
  344.             public void actionPerformed(ActionEvent arg0) {
  345.             	b1.setText("");
  346.             	b2.setText("");
  347.             	b3.setText("");
  348.             	b4.setText("");
  349.             	b5.setText("");
  350.             	b6.setText("");
  351.             	b7.setText("");
  352.             	b8.setText("");
  353.             }
  354.         });
  355.         
  356.         jbt1.addActionListener(new ActionListener(){
  357.             public void actionPerformed(ActionEvent arg0){
  358.             	String a1 = b1.getText();
  359.                 String a2 = b2.getText();
  360.                 String a3 = b3.getText();
  361.                 String a4 = b4.getText();
  362.                 String a5 = b5.getText();
  363.                 String a6 = b6.getText();
  364.                 String a7 = b7.getText();
  365.                 String a8 = b8.getText();
  366.                 if(a1!=null&& a2!=null && a3!=null&& a4!=null) {
  367. 	            	//Connection connection2 = new GetConnection().GetConnection();
  368. 	        		String sql = "insert into student(Xuehao,Name,Sex,Specialistion,Class,Dormitory,Qinlou,Phone) values('"+a1+"','"+a2+"','"+a3+"','"+a4+"','"+a5+"','"+a6+"','"+a7+"','"+a8+"')";
  369. 	                try {
  370. 	                	PreparedStatement state;
  371. 	                	state=(PreparedStatement)connection.prepareStatement(sql);
  372. //	                	int abc = Integer.valueOf(a8);;
  373. //	                	state.setInt(1, abc);
  374. 	                	state.executeUpdate();
  375. 	                	JOptionPane.showMessageDialog(null, "添加成功！");
  376. 	                }catch (Exception e) {
  377. 	                	JOptionPane.showMessageDialog(null, "添加失败,该学号已经存在！");
  378. 	                	System.out.println("添加失败,该学号已经存在！");
  379. 	                	e.printStackTrace();
  380. 					}finally {
  381. 						查看学生住宿信息.remove(scpDome);
  382. 						//JScrollPane scpDome = new JScrollPane();
  383. 						scpDome.setBounds(5,85,650,600);
  384. 						查看学生住宿信息.add(scpDome);
  385. 						//Connection connection = new GetConnection().GetConnection();
  386. 						String sql1 = "select * from student where Qinlou='"+a+"'";
  387. 				        try {
  388. 				        	PreparedStatement state;
  389. 				            ResultSet re;
  390. 				        	state=connection.prepareStatement(sql1);
  391. 				            re=state.executeQuery();
  392. 				            int count=0;
  393. 				            while(re.next()) {
  394. 				            	count++;
  395. 				            }
  396. 				            re = state.executeQuery();
  397. 				            Object[][] info= new Object[count][8];
  398. 				            count = 0;
  399. 				            while(re.next()) {
  400. 				                info[count][0]=re.getString("Xuehao");
  401. 				                info[count][1]=re.getString("Name");
  402. 				                info[count][2]=re.getString("Sex");
  403. 				                info[count][3]=re.getString("Specialistion");
  404. 				                info[count][4]=re.getString("Class");
  405. 				                info[count][5]=re.getString("Dormitory");
  406. 				                info[count][6]=re.getString("Qinlou");
  407. 				                info[count][7]=re.getString("Phone");
  408. 				                count++;
  409. 				            }
  410. 				            String[] title = {"学号","姓名","性别","专业","班级","宿舍号","寝楼","联系电话"};
  411. 				            JTable tabDome = new JTable(info,title);
  412. 				            //JTableHeader jth = tabDome.getTableHeader();
  413. 				            scpDome.getViewport().add(tabDome);
  414. //				            connection.close();
  415. 				        }catch (Exception e) {
  416. 				        	e.printStackTrace();
  417. 						}		
  418. 					}
  419.                 }
  420.                 else {
  421.                 	JOptionPane.showMessageDialog(null, "输入有误，请修改信息！");
  422.                 }
  423.             }
  424.         });
  425.         
  426.         JLabel title2 = new JLabel("删除学生住宿信息");
  427. 		title2.setForeground(new Color(000));
  428. 		title2.setFont(new Font("华文行楷", Font.PLAIN,30));
  429. 		title2.setBounds(186,450,326,40);
  430. 		管理学生住宿信息.add(title2);
  431. 		
  432. 		JLabel title3 = new JLabel("#（删除学生住宿信息只用提供学生的学号）");
  433. 		title3.setForeground(new Color(7396243));
  434. 		title3.setFont(new Font("华文行楷", Font.PLAIN,14));
  435. 		title3.setBounds(260,480,326,40);
  436. 		管理学生住宿信息.add(title3);
  437. 		
  438. 		JLabel x1 = new JLabel(" 学   号:");
  439.         x1.setForeground(new Color(000));
  440.         x1.setFont(new Font("微软雅黑", Font.PLAIN,20));
  441.         x1.setBounds(77,512,100,100);
  442.         管理学生住宿信息.add(x1);
  443.         
  444.         JTextField y1 = new JTextField(25);
  445.         y1.setFont(new Font("微软雅黑", Font.PLAIN,15));
  446.         y1.setSelectedTextColor(new Color(0xFF0000));
  447.         y1.setBounds(160,550,170,30);
  448.         管理学生住宿信息.add(y1);
  449.         
  450.         JButton jbt3 = new JButton("删 除");
  451.         jbt3.setForeground(new Color(16711680));
  452.         jbt3.setBackground(new Color(13487565));
  453.         jbt3.setFont(new Font("华文行楷", Font.PLAIN,30));
  454.         jbt3.setBorderPainted(false);
  455.         jbt3.setBounds(410,545,130,40);
  456.         管理学生住宿信息.add(jbt3);
  457.         
  458.         jbt3.addActionListener(new ActionListener(){
  459.             public void actionPerformed(ActionEvent arg0){
  460.             	String a1 = y1.getText();
  461.             	y1.setText("");
  462.                 if(a1!=null) {
  463. 	            	//Connection connection2 = new GetConnection().GetConnection();
  464. 	        		String sql = "delete from student"+
  465. 	                        " where Xuehao = '"+a1+"'";
  466. 	                try {
  467. 	                	PreparedStatement state;
  468. 	                	state=(PreparedStatement)connection.prepareStatement(sql);
  469. //	                	int abc = Integer.valueOf(a8);;
  470. //	                	state.setInt(1, abc);
  471. 	                	state.executeUpdate();
  472. 	                	JOptionPane.showMessageDialog(null, "删除成功！");
  473. 	                }catch (Exception e) {
  474. 	                	JOptionPane.showMessageDialog(null, "删除失败,该学号不存在！");
  475. 	                	System.out.println("删除失败,该学号不存在！");
  476. 	                	e.printStackTrace();
  477. 					}finally {
  478. 						查看学生住宿信息.remove(scpDome);
  479. 						//JScrollPane scpDome = new JScrollPane();
  480. 						scpDome.setBounds(5,5,650,600);
  481. 						查看学生住宿信息.add(scpDome);
  482. 						//Connection connection = new GetConnection().GetConnection();
  483. 						String sql1 = "select * from student where Qinlou='"+a+"'";
  484. 				        try {
  485. 				        	PreparedStatement state;
  486. 				            ResultSet re;
  487. 				        	state=connection.prepareStatement(sql1);
  488. 				            re=state.executeQuery();
  489. 				            int count=0;
  490. 				            while(re.next()) {
  491. 				            	count++;
  492. 				            }
  493. 				            re = state.executeQuery();
  494. 				            Object[][] info= new Object[count][8];
  495. 				            count = 0;
  496. 				            while(re.next()) {
  497. 				                info[count][0]=re.getString("Xuehao");
  498. 				                info[count][1]=re.getString("Name");
  499. 				                info[count][2]=re.getString("Sex");
  500. 				                info[count][3]=re.getString("Specialistion");
  501. 				                info[count][4]=re.getString("Class");
  502. 				                info[count][5]=re.getString("Dormitory");
  503. 				                info[count][6]=re.getString("Qinlou");
  504. 				                info[count][7]=re.getString("Phone");
  505. 				                count++;
  506. 				            }
  507. 				            String[] title = {"学号","姓名","性别","专业","班级","宿舍号","寝楼","联系电话"};
  508. 				            JTable tabDome = new JTable(info,title);
  509. 				            //JTableHeader jth = tabDome.getTableHeader();
  510. 				            scpDome.getViewport().add(tabDome);
  511. //				            connection.close();
  512. 				        }catch (Exception e) {
  513. 				        	e.printStackTrace();
  514. 						}		
  515. 					}
  516.                 }
  517.                 else {
  518.                 	JOptionPane.showMessageDialog(null, "输入有误，学号不能为空！");
  519.                 }
  520.             }
  521.         });
  522.         
  523. 	}
  524. 	public void 处理报修信息() {
  525. 		
  526. 		JLabel title1 = new JLabel("处理报修信息");
  527. 		title1.setForeground(new Color(000));
  528. 		title1.setFont(new Font("华文行楷", Font.PLAIN,30));
  529. 		title1.setBounds(186,10,326,40);
  530. 		处理报修信息.add(title1);
  531. 		
  532. 		JScrollPane scpDome1 = new JScrollPane();
  533. 		scpDome1.setBounds(5,80,400,550);
  534. 		处理报修信息.add(scpDome1);
  535. 		//Connection connection1 = new GetConnection().GetConnection();
  536. 		String sql = "select * from baoxun where  Qinlou='"+a+"'";
  537.         try {
  538.         	PreparedStatement state;
  539.             ResultSet re;
  540.         	state=connection.prepareStatement(sql);
  541.             re=state.executeQuery();
  542.             int count=0;
  543.             while(re.next()) {
  544.             	count++;
  545.             }
  546.             re = state.executeQuery();
  547.             Object[][] info= new Object[count][6];
  548.             count = 0;
  549.             while(re.next()) {
  550.             	info[count][0]=Integer.valueOf(re.getString("Number1"));
  551.             	info[count][1]=re.getString("Qinlou");
  552.             	info[count][2]=re.getString("Dormitory");
  553.             	info[count][3]=re.getString("Time1");
  554.             	info[count][4]=re.getString("Question");
  555.             	info[count][5]=re.getString("Situation");
  556.             	count++;
  557.             }
  558.             String[] title = {"报修编号","寝楼","宿舍号","时间","问题","状况"};
  559.             JTable tabDome = new JTable(info,title);
  560.             //JTableHeader jth = tabDome.getTableHeader();
  561.             scpDome1.getViewport().add(tabDome);
  562.             //connection.close();
  563.         }catch (Exception e) {
  564.         	e.printStackTrace();
  565. 		}
  566.         
  567.         JLabel title2 = new JLabel("处 理");
  568. 		title2.setForeground(new Color(2186785));
  569. 		title2.setFont(new Font("华文行楷", Font.PLAIN,30));
  570. 		title2.setBounds(480,180,326,40);
  571. 		处理报修信息.add(title2);
  572.         
  573.         JLabel r1 = new JLabel("处理序号:");
  574.         r1.setForeground(new Color(000));
  575.         r1.setFont(new Font("微软雅黑", Font.PLAIN,20));
  576.         r1.setBounds(410,200,100,100);
  577.         处理报修信息.add(r1);
  578.         
  579.         JTextField b1 = new JTextField(25);
  580.         b1.setFont(new Font("微软雅黑", Font.PLAIN,15));
  581.         b1.setSelectedTextColor(new Color(0xFF0000));
  582.         b1.setBounds(500,238,100,30);
  583.         处理报修信息.add(b1);
  584.         
  585.         JLabel r2 = new JLabel("处理状态:");
  586.         r2.setForeground(new Color(000));
  587.         r2.setFont(new Font("微软雅黑", Font.PLAIN,20));
  588.         r2.setBounds(410,254,100,100);
  589.         处理报修信息.add(r2);
  590.         
  591.         JComboBox<Object> jc2 = new JComboBox<>();
  592.         jc2.setBounds(500,290,100,30);
  593.         jc2.addItem("等待处理");
  594.         jc2.addItem("正在处理");
  595.         jc2.addItem("已处理");
  596.         处理报修信息.add(jc2);
  597.         
  598.         JButton jb1 = new JButton("处 理");
  599.         jb1.setForeground(new Color(16711680));
  600.         jb1.setBackground(new Color(5526612));
  601.         jb1.setFont(new Font("华文行楷", Font.PLAIN,30));
  602.         jb1.setBorderPainted(false);
  603.         jb1.setBounds(450,360,130,40);
  604.         处理报修信息.add(jb1);
  605.         
  606.         jb1.addActionListener(new ActionListener(){
  607.             public void actionPerformed(ActionEvent arg0){
  608.             	String a1 = b1.getText();
  609.                 String a2 = jc2.getSelectedItem().toString();
  610.                 b1.setText("");                
  611. 	            	//Connection connection2 = new GetConnection().GetConnection();
  612. 	        		String sql1 = "update baoxun set Situation = '"+a2+"' where Number1= ?";
  613. 	                try {
  614. 	                	PreparedStatement state;
  615. 	                	state=(PreparedStatement)connection.prepareStatement(sql1);
  616. 	                	int z = Integer.parseInt(a1);
  617. 	                	state.setInt(1, z);
  618. 	                	state.executeUpdate();
  619. 	                	JOptionPane.showMessageDialog(null, "修改成功！");
  620. 	                	//connection.close();
  621. 	                }catch (Exception e) {
  622. 	                	JOptionPane.showMessageDialog(null, "你输入的编号有问题，请重新输入！");
  623. 	                	System.out.println("修改失败");
  624. 	                	e.printStackTrace();
  625. 					}finally {
  626. 						处理报修信息.remove(scpDome1);
  627. 						JScrollPane scpDome1 = new JScrollPane();
  628. 						scpDome1.setBounds(5,80,400,550);
  629. 						处理报修信息.add(scpDome1);
  630. 						//Connection connection1 = new GetConnection().GetConnection();
  631. 						String sql2 = "select * from baoxun where  Qinlou='"+a+"'";
  632. 				        try {
  633. 				        	PreparedStatement state;
  634. 				            ResultSet re;
  635. 				        	state=connection.prepareStatement(sql2);
  636. 				            re=state.executeQuery();
  637. 				            int count=0;
  638. 				            while(re.next()) {
  639. 				            	count++;
  640. 				            }
  641. 				            re = state.executeQuery();
  642. 				            Object[][] info= new Object[count][6];
  643. 				            count = 0;
  644. 				            while(re.next()) {
  645. 				                info[count][0]=Integer.valueOf(re.getString("Number1"));
  646. 				                info[count][1]=re.getString("Qinlou");
  647. 				                info[count][2]=re.getString("Dormitory");
  648. 				                info[count][3]=re.getString("Time1");
  649. 				                info[count][4]=re.getString("Question");
  650. 				                info[count][5]=re.getString("Situation");
  651. 				                count++;
  652. 				            }
  653. 				            String[] title = {"报修编号","寝楼","宿舍号","时间","问题","状况"};
  654. 				            JTable tabDome = new JTable(info,title);
  655. 				            //JTableHeader jth = tabDome.getTableHeader();
  656. 				            scpDome1.getViewport().add(tabDome);
  657. 				            //connection.close();
  658. 				        }catch (Exception e) {
  659. 				        	e.printStackTrace();
  660. 						}
  661. 					}
  662. 	            }            
  663.         });
  664. 	}
  665. 	public void 管理学生账号() {
  666. 		
  667. 		JLabel title1 = new JLabel("管理学生账号");
  668. 		title1.setForeground(new Color(000));
  669. 		title1.setFont(new Font("华文行楷", Font.PLAIN,30));
  670. 		title1.setBounds(186,10,326,40);
  671. 		管理学生账号.add(title1);
  672. 		
  673. 		JScrollPane scpDome1 = new JScrollPane();
  674. 		scpDome1.setBounds(5,80,320,550);
  675. 		管理学生账号.add(scpDome1);
  676. 		//Connection connection1 = new GetConnection().GetConnection();
  677. 		String sql = "select * from qinshizhang ";
  678.         try {
  679.         	PreparedStatement state;
  680.             ResultSet re;
  681.         	state=connection.prepareStatement(sql);
  682.             re=state.executeQuery();
  683.             int count=0;
  684.             while(re.next()) {
  685.             	count++;
  686.             }
  687.             re = state.executeQuery();
  688.             Object[][] info= new Object[count][2];
  689.             count = 0;
  690.             while(re.next()) {
  691.             	info[count][0]=re.getString("Zhanghao1");
  692.             	info[count][1]=re.getString("Mima1");
  693.             	count++;
  694.             }
  695.             String[] title = {"账号","密码"};
  696.             JTable tabDome = new JTable(info,title);
  697.             //JTableHeader jth = tabDome.getTableHeader();
  698.             scpDome1.getViewport().add(tabDome);
  699.             //connection.close();
  700.         }catch (Exception e) {
  701.         	e.printStackTrace();
  702. 		}
  703.         
  704.         JLabel title2 = new JLabel("管理账号");
  705. 		title2.setForeground(new Color(3329433));
  706. 		title2.setFont(new Font("华文行楷", Font.PLAIN,30));
  707. 		title2.setBounds(440,80,326,40);
  708. 		管理学生账号.add(title2);
  709.         
  710.         JLabel r1 = new JLabel(" 账  号:");
  711.         r1.setForeground(new Color(000));
  712.         r1.setFont(new Font("微软雅黑", Font.PLAIN,20));
  713.         r1.setBounds(370,120,100,100);
  714.         管理学生账号.add(r1);
  715.         
  716.         JTextField b1 = new JTextField(25);
  717.         b1.setFont(new Font("微软雅黑", Font.PLAIN,15));
  718.         b1.setSelectedTextColor(new Color(0xFF0000));
  719.         b1.setBounds(460,158,150,30);
  720.         管理学生账号.add(b1);
  721.         
  722.         JLabel r2 = new JLabel(" 密  码:");
  723.         r2.setForeground(new Color(000));
  724.         r2.setFont(new Font("微软雅黑", Font.PLAIN,20));
  725.         r2.setBounds(370,180,100,100);
  726.         管理学生账号.add(r2);
  727.         
  728.         JTextField b2 = new JTextField(25);
  729.         b2.setFont(new Font("微软雅黑", Font.PLAIN,15));
  730.         b2.setSelectedTextColor(new Color(0xFF0000));
  731.         b2.setBounds(460,215,150,30);
  732.         管理学生账号.add(b2);
  733.         
  734.         JButton jb1 = new JButton("添加");
  735.         jb1.setForeground(new Color(16711680));
  736.         jb1.setBackground(new Color(5526612));
  737.         jb1.setFont(new Font("华文行楷", Font.PLAIN,20));
  738.         jb1.setBorderPainted(false);
  739.         jb1.setBounds(380,280,80,40);
  740.         管理学生账号.add(jb1);
  741.         
  742.         JButton jb2 = new JButton("删除");
  743.         jb2.setForeground(new Color(16711680));
  744.         jb2.setBackground(new Color(5526612));
  745.         jb2.setFont(new Font("华文行楷", Font.PLAIN,20));
  746.         jb2.setBorderPainted(false);
  747.         jb2.setBounds(530,280,80,40);
  748.         管理学生账号.add(jb2);
  749.         
  750.         jb1.addActionListener(new ActionListener(){
  751.             public void actionPerformed(ActionEvent arg0){
  752.             	String a1 = b1.getText();
  753.                 String a2 = b2.getText();
  754.                 b1.setText("");
  755.             	b2.setText("");
  756. 	            //Connection connection2 = new GetConnection().GetConnection();
  757. 	        	String sql = "insert into qinshizhang(Zhanghao1,Mima1) values('"+a1+"','"+a2+"')";
  758. 	             try {
  759. 	                	PreparedStatement state;
  760. 	                	state=(PreparedStatement)connection.prepareStatement(sql);
  761. //	                	int abc = Integer.valueOf(a8);;
  762. //	                	state.setInt(1, abc);
  763. 	                	state.executeUpdate();
  764. 	                	JOptionPane.showMessageDialog(null, "添加成功！");
  765. 	                }catch (Exception e) {
  766. 	                	JOptionPane.showMessageDialog(null, "添加失败,该账号已经存在！");
  767. 	                	System.out.println("添加失败,该账号已经存在！");
  768. 	                	e.printStackTrace();
  769. 					}finally {
  770. 						管理学生账号.remove(scpDome1);
  771. 						JScrollPane scpDome1 = new JScrollPane();
  772. 						scpDome1.setBounds(5,80,320,550);
  773. 						管理学生账号.add(scpDome1);
  774. 						//Connection connection1 = new GetConnection().GetConnection();
  775. 						String sql1 = "select * from qinshizhang ";
  776. 				        try {
  777. 				        	PreparedStatement state;
  778. 				            ResultSet re;
  779. 				        	state=connection.prepareStatement(sql1);
  780. 				            re=state.executeQuery();
  781. 				            int count=0;
  782. 				            while(re.next()) {
  783. 				            	count++;
  784. 				            }
  785. 				            re = state.executeQuery();
  786. 				            Object[][] info= new Object[count][2];
  787. 				            count = 0;
  788. 				            while(re.next()) {
  789. 				            	info[count][0]=re.getString("Zhanghao1");
  790. 				            	info[count][1]=re.getString("Mima1");
  791. 				            	count++;
  792. 				            }
  793. 				            String[] title = {"账号","密码"};
  794. 				            JTable tabDome = new JTable(info,title);
  795. 				            //JTableHeader jth = tabDome.getTableHeader();
  796. 				            scpDome1.getViewport().add(tabDome);
  797. 				            //connection.close();
  798. 				        }catch (Exception e) {
  799. 				        	e.printStackTrace();
  800. 						}
  801. 					}
  802.                 }    
  803.         	});
  804.         
  805.         jb2.addActionListener(new ActionListener(){
  806.             public void actionPerformed(ActionEvent arg0){
  807.             	String a1 = b1.getText();
  808.                 //String a2 = b2.getText();
  809.                 b1.setText("");
  810.             	b2.setText("");
  811. 	            //Connection connection2 = new GetConnection().GetConnection();
  812. 	        	String sql2 = "delete from qinshizhang where  Zhanghao1='"+a1+"'";
  813. 	             try {
  814. 	                	PreparedStatement state;
  815. 	                	state=(PreparedStatement)connection.prepareStatement(sql2);
  816. //	                	int abc = Integer.valueOf(a8);;
  817. //	                	state.setInt(1, abc);
  818. 	                	state.executeUpdate();
  819. 	                	JOptionPane.showMessageDialog(null, "删除成功！");
  820. 	                }catch (Exception e) {
  821. 	                	JOptionPane.showMessageDialog(null, "删除失败,该账号不存在！");
  822. 	                	System.out.println("删除失败,该账号不存在！");
  823. 	                	e.printStackTrace();
  824. 					}finally {
  825. 						管理学生账号.remove(scpDome1);
  826. 						JScrollPane scpDome1 = new JScrollPane();
  827. 						scpDome1.setBounds(5,80,320,550);
  828. 						管理学生账号.add(scpDome1);
  829. 						//Connection connection1 = new GetConnection().GetConnection();
  830. 						String sql1 = "select * from qinshizhang ";
  831. 				        try {
  832. 				        	PreparedStatement state;
  833. 				            ResultSet re;
  834. 				        	state=connection.prepareStatement(sql1);
  835. 				            re=state.executeQuery();
  836. 				            int count=0;
  837. 				            while(re.next()) {
  838. 				            	count++;
  839. 				            }
  840. 				            re = state.executeQuery();
  841. 				            Object[][] info= new Object[count][2];
  842. 				            count = 0;
  843. 				            while(re.next()) {
  844. 				            	info[count][0]=re.getString("Zhanghao1");
  845. 				            	info[count][1]=re.getString("Mima1");
  846. 				            	count++;
  847. 				            }
  848. 				            String[] title = {"账号","密码"};
  849. 				            JTable tabDome = new JTable(info,title);
  850. 				            //JTableHeader jth = tabDome.getTableHeader();
  851. 				            scpDome1.getViewport().add(tabDome);
  852. 				            //connection.close();
  853. 				        }catch (Exception e) {
  854. 				        	e.printStackTrace();
  855. 						}
  856. 					}
  857.                 }    
  858.         	});
  859. 	}
  860. 	public void 修改密码() {
  861. 		JLabel title = new JLabel("修 改 密 码");
  862. 		title.setForeground(new Color(000));
  863. 		title.setFont(new Font("华文行楷", Font.PLAIN,40));
  864. 		title.setBounds(240,20,200,200);
  865.         修改密码.add(title);
  866. 		
  867.         JLabel x1 = new JLabel("原密码:");
  868.         x1.setForeground(new Color(000));
  869.         x1.setFont(new Font("微软雅黑", Font.PLAIN,30));
  870.         x1.setBounds(140,140,100,100);
  871.         修改密码.add(x1);
  872.         
  873.         JPasswordField password1 = new JPasswordField(20);
  874.         password1.setBounds(270,177,250,30);
  875.         修改密码.add(password1);
  876. //        JTextField y1 = new JTextField(5);
  877. //        y1.setFont(new Font("微软雅黑", Font.PLAIN,18));
  878. //        y1.setSelectedTextColor(new Color(0xFF0000));
  879. //        y1.setBounds(340,170,250,40);
  880. //        修改密码.add(y1);
  881.         
  882.         JLabel x2 = new JLabel("新密码:");
  883.         x2.setForeground(new Color(000));
  884.         x2.setFont(new Font("微软雅黑", Font.PLAIN,30));
  885.         x2.setBounds(140,200,100,100);
  886.         修改密码.add(x2);
  887.         
  888.         JPasswordField password2 = new JPasswordField(20);
  889.         password2.setBounds(270,238,250,30);
  890.         修改密码.add(password2);
  891. //        JTextField y2 = new JTextField(5);
  892. //        y2.setFont(new Font("微软雅黑", Font.PLAIN,18));
  893. //        y2.setSelectedTextColor(new Color(0xFF0000));
  894. //        y2.setBounds(340,230,250,40);
  895. //        修改密码.add(y2);
  896.         JButton jb1 = new JButton("修 改");
  897.         jb1.setForeground(new Color(16711680));
  898.         jb1.setBackground(new Color(5526612));
  899.         jb1.setFont(new Font("华文行楷", Font.PLAIN,30));
  900.         jb1.setBorderPainted(false);
  901.         jb1.setBounds(300,300,130,40);
  902.         修改密码.add(jb1);
  903.         
  904.         jb1.addActionListener(new ActionListener(){
  905.             public void actionPerformed(ActionEvent arg0){
  906.             	String a1 = password1.getText();
  907.                 String a2 = password2.getText();
  908.                 password1.setText("");
  909.                 password2.setText("");
  910.                 
  911.                 if(a1.equals(pass1)) {
  912. 	            	//Connection connection2 = new GetConnection().GetConnection();
  913. 	        		String sql = "update Suguan set Mima = '"+a2+"' where Zhanghao = '"+a+"'";
  914. 	                try {
  915. 	                	PreparedStatement state;
  916. 	                	state=(PreparedStatement)connection.prepareStatement(sql);
  917. 	                	state.executeUpdate();
  918. 	                	JOptionPane.showMessageDialog(null, "修改成功,请重新登录本系统！");
  919. 	                	connection.close();
  920. 	                }catch (Exception e) {
  921. 	                	JOptionPane.showMessageDialog(null, "修改失败！");
  922. 	                	System.out.println("修改失败");
  923. 	                	e.printStackTrace();
  924. 					}finally {
  925. 						System.exit(0);
  926. 					}
  927. 	            }
  928.                 else {
  929.                 	JOptionPane.showMessageDialog(null, "原密码输入有误！");
  930.                 }
  931.             }
  932.         });
  933. 	}
  934. 	
  935. //	public static void main(String [] args)
  936. //	{
  937. //		new 宿管员();
  938. //	}
  939. }

 5.4数据库链接辅助类

  1. package 学生宿舍管理系统;
  2.  
  3. import java.sql.Connection;  
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.Statement;
  7.  
  8. //连接到mySQL数据库
  9. public class GetConnection {
  10.     private Connection con=null;
  11.     public Connection GetConnection(){
  12.     	//数据库连接URL（url：就是一个jdbc的规范的约定）
  13.     	String url = "jdbc:mysql://localhost:3306/sushesystem?useSSL=false&serverTimezone=UTC";
  14.         String username = "root";
  15.         String passwords = "yu1314520";
  16.  
  17.         try {
  18.         	Class.forName("com.mysql.cj.jdbc.Driver");//加载数据库驱动
  19.             con= DriverManager.getConnection(url, username, passwords);//数据库连接用户名、密码
  20.         } catch (Exception e) {
  21.             // TODO 自动生成的 catch 块
  22.             e.printStackTrace();
  23.         }
  24.         return con;// 返回的con就是一个数据库连接对象，通过它你就可以对这个数据库做添删改查的动作
  25.     }
  26.  
  27. }

六、程序运行和数据库截图

  • 登录界面

  •  宿管员操作界面

  • 管理学生信息（添加）

  • 管理学生信息（删除）

  • 处理报修信息

  • 管理学生账号

  • 修改密码

  • 寝室人员查看

  • 报修操作

  • 寝室长账号表

  • 宿管员账号

  • 学生信息

  • 报修信息

  • 存储过程

六、源代码链接

链接：https://download.csdn.net/download/m0_56068773/88808954

声明：本文内容由网友自发贡献，转载请注明出处：【wpsshop】
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号