标题java编写前端程序连接数据库 医院信息管理系统

1.引用类包

import java.awt.*;
import java.awt.event.*;  
import javax.swing.*;
import java.net.URL; 
import java.net.URI;
import java.lang.*;
import java.applet.*;
import java.io.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableRowSorter;

2.下面是程序正文

public class Test {//连接数据库static Connection con;static PreparedStatement sql;static ResultSet res;//窗口public static JFrame jf1;   //总登录界面窗口public static JFrame jf2;   //登录小程序界面窗口public static JFrame jf3; //管理员界面窗口public static JFrame jf4; //医生界面窗口public static JFrame jf5; //护士界面窗口public static JFrame jf6;//医生信息表窗口public static JFrame jf7; //护士信息表窗口public static JFrame jf8; //病人信息表窗口public static JFrame jf9; //药品信息表窗口public static JFrame jf10; //病房信息表窗口public static JFrame jf11; //科室信息表窗口public static JFrame jf12; //手术信息表窗口public static JFrame jf13; //医生个人信息窗口public static JFrame jf14; //医生个人信息窗口public static JButton jb1; //管理员登录按钮public static JButton jb2;//医生登录按钮public static JButton jb3;//护士登录按钮public static JButton jb4; //登录小程序确定按钮public static JButton jb5;//登录小程序取消按钮//管理员界面的按钮public static JButton jb6 = new JButton("医生管理");public static JButton jb7= new JButton("护士管理");public static JButton jb8= new JButton("病人管理");public static JButton jb9= new JButton("药品管理");public static JButton jb10= new JButton("病房管理");public static JButton jb11= new JButton("科室管理");public static JButton jb12= new JButton("手术管理");//医生界面的按钮public static JButton jb13= new JButton("个人信息");public static JButton jb14= new JButton("病人信息");public static JButton jb15= new JButton("护士信息");public static JButton jb16= new JButton("手术信息");//护士界面的按钮public static JButton jb17= new JButton("个人信息");public static JButton jb18= new JButton("病人信息");public static JButton jb19= new JButton("病房信息");public static int i1=0;   //记录主界面点的哪个按钮，1为管理员，2为医生，3为护士，，同时也可以控制医生和护士可以看完整护士表，医生不能看护士的密码和工资public static int i2=0;   //记录登录小程序界面点的哪个按钮，1为登录，2为取消public static int i3=0;   //记录在管理员界面点的拿个按钮，1为医生，2为护士，3为病人，4为药品，5为病房，6为科室，7为手术public static int i4=0;   //记录在医生界面点的按钮，1为个人信息，2为病人信息，3为护士信息，4为手术信息public static int i5=0;   //记录在护士界面点的按钮，1为个人信息，2为病人信息，3为病房信息public static int i6=0;   //记录操作，1为添加，2为修改，3为删除public static int t=0;//用于记录输入的用户名密码是否正确,0为错误，1为正确public static String input1; //暂存输入的用户名public static String input2; //暂存输入的密码private static Font font = new Font("方正正大黑简体",Font.BOLD,20); //设置字体以及大小private static Font font2 = new Font("方正正大黑简体",Font.BOLD,15); //设置以及字体大小/*** @param args the command line arguments*/public Connection getConnection() //连接数据库{try{Class.forName("com.mysql.cj.jdbc.Driver"); System.out.println("数据库驱动加载成功");}catch(ClassNotFoundException e){e.printStackTrace();System.out.println("数据库驱动加载失败");}//用于加载数据库驱动程序try{con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?&useSSL=false&serverTimezone=UTC", "root", "");System.out.println("数据库连接成功");}catch(SQLException e){e.printStackTrace();}//用于连接数据库，建立连接数据库的Connection对象,每次访问都需要建立一个对象return con;}public void getWindows1()  //创建医院管理系统主界面{jf1 = new JFrame("医院管理系统");jf1.setLocation(500,200);jb1 = new JButton("管理员登录");jb2 = new JButton("医生登录");jb3 = new JButton("护士登录");JLabel imgLabel = new JLabel(new ImageIcon("src\\4.jpg")); //把照片弄到标签上jf1.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法imgLabel.setSize(900, 600);Container c1 = jf1.getContentPane();//定义容器((JPanel)c1).setOpaque(false);//将控件显示为透明，漏出背景jb1.setBounds(100, 400, 143, 47);  //设置位置jb2.setBounds(375, 400, 143, 47);jb3.setBounds(650, 400, 143, 47);jb1.setFont(font); //设置字体jb2.setFont(font);jb3.setFont(font);jb1.addMouseListener(new MouseListener() {    //给管理员登录按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i1=1;jf1.dispose();//销毁窗口getWindows2();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb2.addMouseListener(new MouseListener() {    //给医生登录按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i1=2;jf1.dispose();//销毁窗口getWindows2();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}});jb3.addMouseListener(new MouseListener() {    //给护士登录按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb13.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i1=3;jf1.dispose();//销毁窗口getWindows2();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}});c1.add(jb1);  //添加到容器c1.add(jb2);c1.add(jb3);//c1.setLayout(null);   //容器或者窗体都可以设置这个布局管理jf1.setLayout(null);jf1.setSize(900, 600);jf1.setResizable(false);  //用户不能改变窗口的大小jf1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口方式，直接关闭jf1.setVisible(true); //窗口可见}public void getWindows2() //创建登录小程序界面{if(i1==1){jf2=new JFrame("管理员登录");}if(i1==2){jf2=new JFrame("医生登录");}if(i1==3){jf2=new JFrame("护士登录");}jf2.setLocation(500,200);jf2.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\2.jpg")); //把照片弄到标签上jf2.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法imgLabel.setSize(600, 400);//设置改窗体上的组件信息JLabel jl1 = new JLabel("用户名:");JLabel jl2 = new JLabel("密码:");jb4 = new JButton("登录");jb5 = new JButton("取消");JTextField jt1 = new JTextField(20);JTextField jt2 = new JTextField(20);jl1.setBounds(125,75, 100, 80);jl2.setBounds(125, 150, 100, 80);jb4.setBounds(100, 250, 143,47);jb5.setBounds(350, 250, 143,47);jt1.setBounds(200,105 , 300, 30);jt2.setBounds(200,180,300, 30);jb4.setFont(font);jb5.setFont(font);jl1.setFont(font);jl2.setFont(font);jt1.setFont(font2);jb2.setFont(font2);Container c = jf2.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景jb4.addMouseListener(new MouseListener() {    //给登录按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//先判断是否用户名密码是否正确   input1=jt1.getText();input2=jt2.getText();if(i1==1) //如果是管理员登录，那么查看数据库中的管理员表{con=getConnection(); try{           sql=con.prepareStatement("select * from hospital.manage where Name like ?");sql.setString(1, input1);//input1是前面输入的用户名res=sql.executeQuery();String name;String code;while(res.next()){name = res.getString("Name");code = res.getString("code");if(input2.equals(code)){//如果密码正确t=1;break;}}                      }    catch(Exception e2){e2.printStackTrace();}}if(i1==2)//如果是医生登录，那么查看数据库中医生表{con=getConnection(); try{           sql=con.prepareStatement("select * from hospital.doctor where Name like ?");sql.setString(1, input1);//input1是前面输入的用户名res=sql.executeQuery();String name;String code;while(res.next()){name = res.getString("Name");code = res.getString("code");if(input2.equals(code)){//如果密码正确t=1;break;}}                      }    catch(Exception e2){e2.printStackTrace();}}if(i1==3) //如果是护士登录，那么查看数据库中的护士表{con=getConnection(); try{           sql=con.prepareStatement("select * from hospital.nurse where Name like ?");sql.setString(1, input1);//input1是前面输入的用户名res=sql.executeQuery();String name;String code;while(res.next()){name = res.getString("Name");code = res.getString("code");if(input2.equals(code)){//如果密码正确t=1;break;}}                      }    catch(Exception e2){e2.printStackTrace();}}      if(t==1)  //验证正确，打开新窗口{i2=1;jf2.dispose();//销毁窗口if(i1==1){getWindows3();//打开管理员窗口}if(i1==2){getWindows4();//打开医生窗口}if(i1==3){   getWindows5();//打开护士窗口}}else   //验证失败，提示重新输入{jt1.setText("");//将输入清空jt2.setText("");JOptionPane about =new JOptionPane();about.showMessageDialog(null, "用户名或密码输入错误，请重新输入");//弹出对话空提示}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb5.addMouseListener(new MouseListener() {    //给取消按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i2=2;jf2.dispose();//销毁窗口}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(jl2);c.add(jb4);c.add(jb5);c.add(jt1);c.add(jt2);jf2.setVisible(true);jf2.setSize(600, 400);jf2.setResizable(false);  //用户不能改变窗口的大小jf2.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口方式}public void getWindows3()//创建管理员界面{jf3=new JFrame("我的管理（管理员）");jf3.setLocation(500,200);jf3.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\5.jpg")); //把照片弄到标签上jf3.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf3.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景jb6.setBounds(125, 150, 143, 47);jb7.setBounds(385, 150, 143, 47);jb8.setBounds(625, 150, 143, 47);jb9.setBounds(75, 300, 143, 47);jb10.setBounds(265, 300, 143, 47);jb11.setBounds(465, 300, 143, 47);jb12.setBounds(665, 300, 143, 47);jb6.setFont(font);jb7.setFont(font);jb8.setFont(font);jb9.setFont(font);jb10.setFont(font);jb11.setFont(font);jb12.setFont(font);jb6.addMouseListener(new MouseListener() {    //给医生管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb6.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=1;//jf3.dispose();//销毁窗口getWindows6();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb6.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb7.addMouseListener(new MouseListener() {    //给护士管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb7.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=2;//jf3.dispose();//销毁窗口getWindows7();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb7.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb8.addMouseListener(new MouseListener() {    //给病人管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb8.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=3;//jf3.dispose();//销毁窗口getWindows8();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb8.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb9.addMouseListener(new MouseListener() {    //给药品管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb9.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=4;//jf3.dispose();//销毁窗口getWindows9();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb9.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb10.addMouseListener(new MouseListener() {    //给病房管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb10.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=5;//jf3.dispose();//销毁窗口getWindows10();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb10.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb11.addMouseListener(new MouseListener() {    //给科室管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb11.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=6;//jf3.dispose();//销毁窗口getWindows11();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb11.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb12.addMouseListener(new MouseListener() {    //给手术管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb12.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i3=7;//jf3.dispose();//销毁窗口getWindows12();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb12.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jb6);c.add(jb7);c.add(jb8);c.add(jb9);c.add(jb10);c.add(jb11);c.add(jb12);jf3.setVisible(true);jf3.setSize(900, 600);jf3.setResizable(false);  //用户不能改变窗口的大小jf3.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口方式}public void getWindows4()//创建医生界面{jf4=new JFrame("我的管理（医生）");jf4.setLocation(500,200);jf4.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\5.jpg")); //把照片弄到标签上jf4.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf4.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景jb13.setFont(font);jb14.setFont(font);jb15.setFont(font);jb16.setFont(font);jb13.setBounds(125, 150, 143, 47);jb14.setBounds(400, 150, 143, 47);jb15.setBounds(125, 300, 143, 47);jb16.setBounds(400, 300, 143, 47);jb13.addMouseListener(new MouseListener() {    //给个人信息按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb13.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i4=1;//jf4.dispose();//销毁窗口getWindows13();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb13.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb14.addMouseListener(new MouseListener() {    //给病人按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb14.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i4=2;//jf4.dispose();//销毁窗口getWindows8();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb14.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb15.addMouseListener(new MouseListener() {    //给护士管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb15.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i4=3;//jf4.dispose();//销毁窗口getWindows7();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb15.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb16.addMouseListener(new MouseListener() {    //给手术管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb16.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i4=4;//jf4.dispose();//销毁窗口getWindows12();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb16.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jb13);c.add(jb14);c.add(jb15);c.add(jb16);jf4.setVisible(true);jf4.setSize(700,500);jf4.setResizable(false);  //用户不能改变窗口的大小jf4.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口方式}public void getWindows5()//创建护士界面{jf5=new JFrame("我的管理（护士）");jf5.setLocation(500,200);jf5.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\5.jpg")); //把照片弄到标签上jf5.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf5.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景jb17.setFont(font);jb18.setFont(font);jb19.setFont(font);jb17.setBounds(50,200,143,47);jb18.setBounds(275,200,143, 47);jb19.setBounds(500,200,143, 47);jb17.addMouseListener(new MouseListener() {    //给个人信息按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb17.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i5=1;//jf5.dispose();//销毁窗口getWindows14();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb17.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb18.addMouseListener(new MouseListener() {    //给病人管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb18.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i5=2;//jf4.dispose();//销毁窗口getWindows8();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb18.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); jb19.addMouseListener(new MouseListener() {    //给病房管理按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//jb19.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i5=3;//jf4.dispose();//销毁窗口getWindows10();}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//jb19.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jb17);c.add(jb18);c.add(jb19);jf5.setVisible(true);jf5.setSize(700,500);jf5.setResizable(false);  //用户不能改变窗口的大小jf5.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口方式}public void getWindows6()//创建医生信息表窗口{jf6=new JFrame("医生信息");jf6.setLocation(500,200);jf6.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf6.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf6.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入姓名：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(250, 50, 140, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格String columnName[] = {"医生ID","科室ID","姓名","性别","年龄","学历","密码","工资"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);for(int i=0;i<=7;i++){model.addColumn(columnName[i]);}// String tableValues[][]={{Integer.toString(id),Integer.toString(keshi_ID),name,sex,Integer.toString(age),education,Integer.toString(code),Integer.toString(salary)}};//String tableValues[][]={{null,null,null,null,null,null,null}};//dtm=new DefaultTableModel(tableValues,columnName);             //jt=new JTable(dtm);//jt.setRowSorter(new TableRowSorter<>(dtm));//js.setViewportView(jt);//与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.doctor");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;int keshi_ID;String name;               String sex;int age;String education;int code;int salary;id = res.getInt("ID");keshi_ID = res.getInt("keshi_ID");name = res.getString("Name");sex = res.getString("sex");age = res.getInt("age");education = res.getString("education");code = res.getInt("code");salary = res.getInt("salary");//将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行String tableValues2[]={Integer.toString(id),Integer.toString(keshi_ID),name,sex,Integer.toString(age),education,Integer.toString(code),Integer.toString(salary)};model.addRow(tableValues2);                   }        //预处理添加数据//添加数据/*sql=con.prepareStatement("insert into company.employee values(?,?,?,?)");sql.setInt(1, 11);sql.setString(2, "mm");sql.setInt(3,97);sql.setString(4, "male");sql.executeUpdate();}*/}    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p4.addMouseListener(new MouseListener() {    //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态//连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int keshi_ID1=Integer.parseInt((String) model.getValueAt(a, 1));String name1=(String)model.getValueAt(a, 2);String sex1=(String)model.getValueAt(a, 3);int age1=Integer.parseInt((String) model.getValueAt(a, 4));       String education1=(String)model.getValueAt(a, 5);           int code1 = Integer.parseInt((String) model.getValueAt(a, 6));            int salary1 = Integer.parseInt((String) model.getValueAt(a, 7));sql=con.prepareStatement("insert into hospital.doctor values(?,?,?,?,?,?,?,?)");sql.setInt(1, id1);sql.setInt(2,keshi_ID1);sql.setString(3, name1);sql.setString(4, sex1);sql.setInt(5,age1);sql.setString(6, education1);sql.setInt(7, code1);sql.setInt(8, salary1);sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int keshi_ID1=Integer.parseInt((String) model.getValueAt(a, 1));String name1=(String)model.getValueAt(a, 2);String sex1=(String)model.getValueAt(a, 3);int age1=Integer.parseInt((String) model.getValueAt(a, 4));       String education1=(String)model.getValueAt(a, 5);           int code1 = Integer.parseInt((String) model.getValueAt(a, 6));            int salary1 = Integer.parseInt((String) model.getValueAt(a, 7));int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.doctor set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set keshi_ID = ?  where ID = ?");sql.setInt(1, keshi_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set Name = ?  where ID = ?");sql.setString(1, name1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set sex = ?  where ID = ?");sql.setString(1, sex1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set age = ?  where ID = ?");sql.setInt(1, age1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set education = ?  where ID = ?");sql.setString(1, education1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set code = ?  where ID = ?");sql.setInt(1, code1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.doctor set salary = ?  where ID = ?");sql.setInt(1, salary1);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.doctor where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);c.add(p2);c.add(p3);c.add(p4);c.add(p5);c.add(js);jf6.setVisible(true);jf6.setSize(900,600);jf6.setResizable(false);  //用户不能改变窗口的大小jf6.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows7()//创建护士信息表窗口{jf7=new JFrame("护士信息");jf7.setLocation(500,200);jf7.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf7.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf7.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入姓名：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(250, 50, 140, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格                  String columnName[] = {"护士ID","管理病房ID","姓名","性别","年龄","学历","密码","工资"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);if(i1==1||i1==3){for(int i=0;i<=7;i++){model.addColumn(columnName[i]);}}else{for(int i=0;i<=5;i++){model.addColumn(columnName[i]);}}// String tableValues[][]={{Integer.toString(id),Integer.toString(keshi_ID),name,sex,Integer.toString(age),education,Integer.toString(code),Integer.toString(salary)}};//String tableValues[][]={{null,null,null,null,null,null,null}};//dtm=new DefaultTableModel(tableValues,columnName);             //jt=new JTable(dtm);//jt.setRowSorter(new TableRowSorter<>(dtm));//js.setViewportView(jt);//与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.nurse");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;int room_ID;String name;               String sex;int age;String education;int code;int salary;id = res.getInt("ID");room_ID = res.getInt("room_ID");name = res.getString("Name");sex = res.getString("sex");age = res.getInt("age");education = res.getString("education");code = res.getInt("code");salary = res.getInt("salary");//将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行if(i1==1||i1==3)   //这个if语句来控制只有医生和护士可以看护士表，医生不能看护士的密码和工资{String tableValues2[]={Integer.toString(id),Integer.toString(room_ID),name,sex,Integer.toString(age),education,Integer.toString(code),Integer.toString(salary)};                  model.addRow(tableValues2);   }else{String tableValues2[]={Integer.toString(id),Integer.toString(room_ID),name,sex,Integer.toString(age),education};                  model.addRow(tableValues2);   }}        }    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p4.addMouseListener(new MouseListener() {    //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态           //连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int room_ID1=Integer.parseInt((String) model.getValueAt(a, 1));String name1=(String)model.getValueAt(a, 2);String sex1=(String)model.getValueAt(a, 3);int age1=Integer.parseInt((String) model.getValueAt(a, 4));       String education1=(String)model.getValueAt(a, 5);           int code1 = Integer.parseInt((String) model.getValueAt(a, 6));            int salary1 = Integer.parseInt((String) model.getValueAt(a, 7));sql=con.prepareStatement("insert into hospital.nurse values(?,?,?,?,?,?,?,?)");sql.setInt(1, id1);sql.setInt(6,room_ID1);sql.setString(2, name1);sql.setString(4, sex1);sql.setInt(3,age1);sql.setString(7, education1);sql.setInt(5, code1);sql.setInt(8, salary1);sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int room_ID1=Integer.parseInt((String) model.getValueAt(a, 1));String name1=(String)model.getValueAt(a, 2);String sex1=(String)model.getValueAt(a, 3);int age1=Integer.parseInt((String) model.getValueAt(a, 4));       String education1=(String)model.getValueAt(a, 5);           int code1 = Integer.parseInt((String) model.getValueAt(a, 6));            int salary1 = Integer.parseInt((String) model.getValueAt(a, 7));int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.nurse set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set room_ID = ?  where ID = ?");sql.setInt(1, room_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set Name = ?  where ID = ?");sql.setString(1, name1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set sex = ?  where ID = ?");sql.setString(1, sex1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set age = ?  where ID = ?");sql.setInt(1, age1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set education = ?  where ID = ?");sql.setString(1, education1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set code = ?  where ID = ?");sql.setInt(1, code1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.nurse set salary = ?  where ID = ?");sql.setInt(1, salary1);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取改行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.nurse where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);if(i1==1||i1==3) //医生在这个表中没有修改护士信息的权利{c.add(p2);c.add(p3);c.add(p4);c.add(p5);}c.add(js);jf7.setVisible(true);jf7.setSize(900,600);jf7.setResizable(false);  //用户不能改变窗口的大小jf7.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows8()//创建病人信息表窗口{jf8=new JFrame("病人信息");jf8.setLocation(500,200);jf8.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf8.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf8.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入姓名：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(250, 50, 140, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格String columnName[] = {"病人ID","病房ID","姓名","性别","年龄","症状","科室ID","医生ID"};//String columnName[] = {"病人ID","病房ID","姓名","性别","年龄","症状","科室ID","医生"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);for(int i=0;i<=7;i++){model.addColumn(columnName[i]);}         //与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.bingren");//sql=con.prepareStatement("select hospital.bingren.*,hospital.doctor.* from hospital.bingren，hospital.doctor where hospital.bingren.doctor_ID = hospital.doctor.ID");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;int room_ID;String name;               String sex;int age;String zhengzhuang;int keshi_ID;int doctor_ID;//int doctor;id = res.getInt("bingren.ID");room_ID = res.getInt("room_ID");name = res.getString("bingren.Name");sex = res.getString("sex");age = res.getInt("age");zhengzhuang = res.getString("symptom");keshi_ID = res.getInt("keshi_ID");doctor_ID = res.getInt("doctor_ID");//doctor = res.getInt("doctor.Name");//将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行String tableValues2[]={Integer.toString(id),Integer.toString(room_ID),name,sex,Integer.toString(age),zhengzhuang,Integer.toString(keshi_ID),Integer.toString(doctor_ID)};//String tableValues2[]={Integer.toString(id),Integer.toString(room_ID),name,sex,Integer.toString(age),zhengzhuang,Integer.toString(keshi_ID),Integer.toString(doctor)};model.addRow(tableValues2);                   }        }    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p4.addMouseListener(new MouseListener() {    //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态           //连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int room_ID1=Integer.parseInt((String) model.getValueAt(a, 1));String name1=(String)model.getValueAt(a, 2);String sex1=(String)model.getValueAt(a, 3);int age1=Integer.parseInt((String) model.getValueAt(a, 4));       String zhengzhuang1=(String)model.getValueAt(a, 5);           int keshi_ID1 = Integer.parseInt((String) model.getValueAt(a, 6));            int doctor_ID1 = Integer.parseInt((String) model.getValueAt(a, 7));sql=con.prepareStatement("insert into hospital.bingren values(?,?,?,?,?,?,?,?)");sql.setInt(1, id1);sql.setInt(6,room_ID1);sql.setString(2, name1);sql.setString(4, sex1);sql.setInt(3,age1);sql.setString(5, zhengzhuang1);sql.setInt(7, keshi_ID1);sql.setInt(8, doctor_ID1);sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int room_ID1=Integer.parseInt((String) model.getValueAt(a, 1));String name1=(String)model.getValueAt(a, 2);String sex1=(String)model.getValueAt(a, 3);int age1=Integer.parseInt((String) model.getValueAt(a, 4));       String zhengzhuang1=(String)model.getValueAt(a, 5);           int keshi_ID1 = Integer.parseInt((String) model.getValueAt(a, 6));            int doctor_ID1 = Integer.parseInt((String) model.getValueAt(a, 7));int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.bingren set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set room_ID = ?  where ID = ?");sql.setInt(1, room_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set Name = ?  where ID = ?");sql.setString(1, name1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set sex = ?  where ID = ?");sql.setString(1, sex1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set age = ?  where ID = ?");sql.setInt(1, age1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set symptom = ?  where ID = ?");sql.setString(1, zhengzhuang1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set keshi_ID = ?  where ID = ?");sql.setInt(1, keshi_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingren set doctor_ID = ?  where ID = ?");sql.setInt(1, doctor_ID1);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取改行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.bingren where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);c.add(p2);c.add(p3);c.add(p4);c.add(p5);c.add(js);jf8.setVisible(true);jf8.setSize(900,600);jf8.setResizable(false);  //用户不能改变窗口的大小jf8.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows9()//创建药品信息表窗口{jf9=new JFrame("药品信息");jf9.setLocation(500,200);jf9.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf9.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf9.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入药品：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(250, 50, 140, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格String columnName[] = {"药品ID","药品名","成本价","售价"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);for(int i=0;i<=3;i++){model.addColumn(columnName[i]);}                 //与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.medicine");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;               String name;               float costprice;float sellprice;id = res.getInt("ID");name = res.getString("Name");costprice = res.getFloat("cost_price");sellprice = res.getFloat("selling_price");//将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行String tableValues2[]={Integer.toString(id),name,Float.toString(costprice),Float.toString(sellprice)};model.addRow(tableValues2);                   }        }    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p4.addMouseListener(new MouseListener() {    //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态           //连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));                              String name1=(String)model.getValueAt(a, 1);                                                                 float costprice1 = Float.parseFloat((String) model.getValueAt(a, 2));            float cellprice1 = Float.parseFloat((String) model.getValueAt(a, 3));sql=con.prepareStatement("insert into hospital.medicine values(?,?,?,?)");sql.setInt(1, id1);sql.setString(2, name1);sql.setFloat(3, costprice1);sql.setFloat(4, cellprice1);sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           String name1=(String)model.getValueAt(a, 1);    float costprice1 = Float.parseFloat((String) model.getValueAt(a, 2));            float cellprice1 = Float.parseFloat((String) model.getValueAt(a, 3));int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.medicine set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.medicine set Name = ?  where ID = ?");sql.setString(1, name1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.medicine set cost_price = ?  where ID = ?");sql.setFloat(1, costprice1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.medicine set selling_price = ?  where ID = ?");sql.setFloat(1, cellprice1);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取改行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.medicine where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);c.add(p2);c.add(p3);c.add(p4);c.add(p5);c.add(js);jf9.setVisible(true);jf9.setSize(900,600);jf9.setResizable(false);  //用户不能改变窗口的大小jf9.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows10()//创建病房信息表窗口{jf10=new JFrame("病房信息");jf10.setLocation(500,200);jf10.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf10.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf10.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入病房ID：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(220, 50, 170, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格String columnName[] = {"病房ID","科室ID","总床位","剩余床位"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);for(int i=0;i<=3;i++){model.addColumn(columnName[i]);}                 //与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.bingfang");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;int keshi_ID;                int sum_bed;               int now_bed;id = res.getInt("ID");keshi_ID = res.getInt("keshi_ID");               sum_bed = res.getInt("sum_bed");now_bed = res.getInt("now_bed");//将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行String tableValues2[]={Integer.toString(id),Integer.toString(keshi_ID),Integer.toString(sum_bed),Integer.toString(now_bed)};model.addRow(tableValues2);                   }        }    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;            }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}   }); p4.addMouseListener(new MouseListener() {      //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态           //连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int keshi_ID1=Integer.parseInt((String) model.getValueAt(a, 1));                                        int sum_bed=Integer.parseInt((String) model.getValueAt(a, 2));                           int now_bed = Integer.parseInt((String) model.getValueAt(a, 3));            sql=con.prepareStatement("insert into hospital.bingfang values(?,?,?,?)");sql.setInt(1, id1);sql.setInt(2,keshi_ID1);                             sql.setInt(3,sum_bed);                    sql.setInt(4, now_bed);                   sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));           int keshi_ID1=Integer.parseInt((String) model.getValueAt(a, 1));                                      int sum_bed=Integer.parseInt((String) model.getValueAt(a, 2));                         int now_bed = Integer.parseInt((String) model.getValueAt(a, 3));            int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.bingfang set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingfang set keshi_ID = ?  where ID = ?");sql.setInt(1, keshi_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingfang set sum_bed = ?  where ID = ?");sql.setInt(1, sum_bed);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.bingfang set now_bed = ?  where ID = ?");sql.setInt(1, now_bed);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取改行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.bingfang where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);c.add(p2);c.add(p3);c.add(p4);c.add(p5);c.add(js);jf10.setVisible(true);jf10.setSize(900,600);jf10.setResizable(false);  //用户不能改变窗口的大小jf10.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows11()//创建科室信息窗口{jf11=new JFrame("科室信息");jf11.setLocation(500,200);jf11.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf11.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf11.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入科室名称：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(220, 50, 170, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格String columnName[] = {"科室ID","科室名称","挂号费","主任","总病房数","现有病房数"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);for(int i=0;i<=5;i++){model.addColumn(columnName[i]);}                 //与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.keshi");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;                String name;                               int Fee;String Fzr;int room_number;int now_room_number;id = res.getInt("ID");               name = res.getString("Name");               Fee= res.getInt("Fee");Fzr = res.getString("Fzr");room_number = res.getInt("room_number");now_room_number = res.getInt("now_room_number");//将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行String tableValues2[]={Integer.toString(id),name,Integer.toString(Fee),Fzr,Integer.toString(room_number),Integer.toString(now_room_number)};model.addRow(tableValues2);                   }        }    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p4.addMouseListener(new MouseListener() {    //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态           //连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));                              String name1=(String)model.getValueAt(a, 1);                    int Fee1=Integer.parseInt((String) model.getValueAt(a, 2));       String Fzr1=(String)model.getValueAt(a, 3);           int room_number1 = Integer.parseInt((String) model.getValueAt(a, 4));            int now_room_number1= Integer.parseInt((String) model.getValueAt(a, 5));sql=con.prepareStatement("insert into hospital.keshi values(?,?,?,?,?,?)");sql.setInt(1, id1);                   sql.setString(2, name1);                sql.setInt(3,Fee1);sql.setString(4, Fzr1);sql.setInt(5, room_number1);sql.setInt(6, now_room_number1);sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));                               String name1=(String)model.getValueAt(a, 1);                   int Fee1=Integer.parseInt((String) model.getValueAt(a, 2));       String Fzr1=(String)model.getValueAt(a, 3);           int room_number1 = Integer.parseInt((String) model.getValueAt(a, 4));            int now_room_number1 = Integer.parseInt((String) model.getValueAt(a, 5));int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.keshi set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.keshi set Name = ?  where ID = ?");sql.setString(1, name1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.keshi set Fee = ?  where ID = ?");sql.setInt(1, Fee1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.keshi set Fzr = ?  where ID = ?");sql.setString(1, Fzr1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.keshi set room_number = ?  where ID = ?");sql.setInt(1, room_number1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.keshi set now_room_number = ?  where ID = ?");sql.setInt(1, now_room_number1);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取改行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.keshi where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);c.add(p2);c.add(p3);c.add(p4);c.add(p5);c.add(js);jf11.setVisible(true);jf11.setSize(900,600);jf11.setResizable(false);  //用户不能改变窗口的大小jf11.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows12()//创建手术信息信息窗口{jf12=new JFrame("手术信息");jf12.setLocation(500,200);jf12.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\6.jpg")); //把照片弄到标签上jf12.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf12.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景JLabel jl1=new JLabel("请输入手术ID：");JButton p1 = new JButton("查询");JTextField jt1 = new JTextField(20);JButton p2 = new JButton("添加");JButton p3 = new JButton("修改");JButton p4 = new JButton("删除");JButton p5 = new JButton("确定");jl1.setFont(font);p1.setFont(font);jt1.setFont(font);p2.setFont(font);p3.setFont(font);p4.setFont(font);p5.setFont(font);jl1.setBounds(220, 50, 170, 43);p1.setBounds(550, 57, 110, 30);jt1.setBounds(400, 57, 110, 30);p2.setBounds(150, 500, 110, 30);p3.setBounds(300, 500, 110, 30);p4.setBounds(450, 500, 110, 30);p5.setBounds(600, 500, 110, 30);//创建表格String columnName[] = {"手术ID","病人ID","医生ID","手术时间"};DefaultTableModel model=new DefaultTableModel();JTable table=new JTable();table.setModel(model);table.setRowSorter(new TableRowSorter<>(model));final JScrollPane js=new JScrollPane(table);js.setBounds(80,100, 700, 400);for(int i=0;i<=3;i++){model.addColumn(columnName[i]);}                 //与数据库连接con=getConnection(); try{//sql=con.createStatement(); //实例化Statement对象            //执行sql语句，对数据库操作，并返回结果集//res=sql.executeQuery("select * from company.employee");sql=con.prepareStatement("select * from hospital.operation");res=sql.executeQuery();//遍历查询结果while(res.next()){//将数据从数据库中导出来int id;                int bingren_ID;                    int doctor_ID;String time;id = res.getInt("ID");                                   bingren_ID= res.getInt("bingren_ID");doctor_ID = res.getInt("doctor_ID");time= res.getString("time"); //将数据整合成数组，以用来构成表格//定义表格组件,第一次先弄第一行String tableValues2[]={Integer.toString(id),Integer.toString(bingren_ID),Integer.toString(doctor_ID),time};model.addRow(tableValues2);                   }        }    catch(Exception e){e.printStackTrace();}p1.addMouseListener(new MouseListener() {    //给查询按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//String s2=(String) table.getValueAt(2, 2);//System.out.print(s2);String s1=jt1.getText();//           System.out.print(s1);loop:       for(int x=0;x<=table.getRowCount()-1;x++)  //按照名字查询，选中那一列{               for(int y=0;y<=table.getColumnCount()-1;y++){   //String s3=(String)table.getValueAt(2, 2);// System.out.print(s3);if(s1.equals(table.getValueAt(x, y))){System.out.print(s1);table.setRowSelectionInterval(x,x);break loop;}}}}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p1.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p2.addMouseListener(new MouseListener() {    //给添加按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发  i6=1;String tableValues3[]={null,null,null,null};  //先添加一个空行，并且选中model.addRow(tableValues3);table.setRowSelectionInterval(table.getRowCount()-1,table.getRowCount()-1);}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p2.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p3.addMouseListener(new MouseListener() {    //给修改按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=2;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p3.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p4.addMouseListener(new MouseListener() {    //给删除按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发i6=3;}public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p4.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); p5.addMouseListener(new MouseListener() {    //给确定按钮添加鼠标事件监听器public void mouseEntered(MouseEvent e) {//移入组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi2.png"));  //鼠标放上时，换成颜色深的照片，增加视觉效果}public void mousePressed(MouseEvent e) {//鼠标按键按下时被触发}public void mouseReleased(MouseEvent e) {//鼠标按键被释放时被触发//在添加下按下确定//将输入的值存入临时变量中int a=table.getSelectedRow();//返回选中行的索引，返回值为int型,table.clearSelection();//取消行的选中状态           //连接数据库con=getConnection(); try{                               //预处理添加数据//添加数据,将添加的数据存入到数据库当中if(i6==1) //添加{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0));                              int bingren_ID1= Integer.parseInt((String) model.getValueAt(a, 1));                int doctor_ID1=Integer.parseInt((String) model.getValueAt(a, 2));       String time1=(String)model.getValueAt(a, 3);           sql=con.prepareStatement("insert into hospital.operation values(?,?,?,?)");sql.setInt(1, id1);                                         sql.setInt(2,bingren_ID1);sql.setInt(3,doctor_ID1);sql.setString(4, time1);sql.executeUpdate();}if(i6==2)  //修改某一行的值{table.getCellEditor().stopCellEditing(); //取消单元格的编辑状态int id1=Integer.parseInt((String) model.getValueAt(a, 0)); int bingren_ID1 = Integer.parseInt((String) model.getValueAt(a, 1));int doctor_ID1=Integer.parseInt((String) model.getValueAt(a, 2));       String time1=(String)model.getValueAt(a, 3);           int b = Integer.parseInt((String) model.getValueAt(a, 0));//获取该行的ID，便于和数据库对应sql=con.prepareStatement("update hospital.operation set ID = ?  where ID = ?");sql.setInt(1, id1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.operation set bingren_ID = ?  where ID = ?");sql.setInt(1, bingren_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.operation set doctor_ID = ?  where ID = ?");sql.setInt(1, doctor_ID1);sql.setInt(2, b);sql.executeUpdate();sql=con.prepareStatement("update hospital.operation set time = ?  where ID = ?");sql.setString(1, time1);sql.setInt(2, b);sql.executeUpdate();}if(i6==3) //删除一行{//删掉数据库中的行int c = Integer.parseInt((String) model.getValueAt(a, 0));//获取改行的ID，便于和数据库对应sql=con.prepareStatement("delete from hospital.operation where ID = ?");sql.setInt(1, c);sql.executeUpdate();//删掉表格中的行model.removeRow(a);}i6=0;}           catch(Exception e1){e1.printStackTrace();}                                  }public void mouseClicked(MouseEvent e) {//发生单击事件时被触发}public void mouseExited(MouseEvent e) {//移出组件时被触发//p5.setIcon(new ImageIcon("src\\picture\\kaishi1.png"));  //鼠标移走在恢复原样}}); c.add(jl1);c.add(p1);c.add(jt1);c.add(p2);c.add(p3);c.add(p4);c.add(p5);c.add(js);jf12.setVisible(true);jf12.setSize(900,600);jf12.setResizable(false);  //用户不能改变窗口的大小jf12.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows13()  //创建医生个人信息窗口{jf13=new JFrame("个人信息");jf13.setLocation(500,200);jf13.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\7.jpg")); //把照片弄到标签上jf13.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf13.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景//初始化标签JLabel Jl1 = new JLabel("医生ID");JLabel Jl2 = new JLabel("科室ID");JLabel Jl3 = new JLabel("姓名");JLabel Jl4 = new JLabel("性别");JLabel Jl5 = new JLabel("年龄");JLabel Jl6 = new JLabel("学历");JLabel Jl7 = new JLabel("密码");JLabel Jl8 = new JLabel("工资");//初始化文本域JTextField jt1=new JTextField();JTextField jt2=new JTextField();JTextField jt3=new JTextField();JTextField jt4=new JTextField();JTextField jt5=new JTextField();JTextField jt6=new JTextField();JTextField jt7=new JTextField();JTextField jt8=new JTextField();//设置组件字体Jl1.setFont(font);Jl2.setFont(font);Jl3.setFont(font);Jl4.setFont(font);Jl5.setFont(font);Jl6.setFont(font);Jl7.setFont(font);Jl8.setFont(font);jt1.setFont(font);jt2.setFont(font);jt3.setFont(font);jt4.setFont(font);jt5.setFont(font);jt6.setFont(font);jt7.setFont(font);jt8.setFont(font);//设置组件位置Jl1.setBounds(80, 170, 143, 47);Jl2.setBounds(280, 170, 143, 47);Jl3.setBounds(475, 170, 143, 47);Jl4.setBounds(675, 170, 143, 47);Jl5.setBounds(80, 370, 143, 47);Jl6.setBounds(300, 370, 143, 47);Jl7.setBounds(475, 370, 143, 47);Jl8.setBounds(675, 370, 143, 47);jt1.setBounds(150, 170,100, 40);jt2.setBounds(350, 170,100, 40);jt3.setBounds(525, 170,100, 40);jt4.setBounds(725, 170,100, 40);jt5.setBounds(150, 370,100, 40);jt6.setBounds(350, 370,100, 40);jt7.setBounds(525, 370,100, 40);jt8.setBounds(725, 370,100, 40);//定义存数据的变量int id;int keshi_id;String name;String sex;int age;String education;int code;int salary;//连接数据库con=getConnection(); System.out.print(input1);try{           sql=con.prepareStatement("select * from hospital.doctor where Name like ?");sql.setString(1, input1);   //查询出该用户名的所有信息res=sql.executeQuery();           //将查询到的信息取出来while(res.next())   //将信息存到临时变量上{id=res.getInt("ID");System.out.print(id);keshi_id=res.getInt("keshi_ID");name = res.getString("Name");sex = res.getString("sex");age=res.getInt("age");education = res.getString("education");code = res.getInt("code");salary = res.getInt("salary");  System.out.print(1);//将信息显示到文本空里jt1.setText(Integer.toString(id));jt2.setText(Integer.toString(keshi_id));jt3.setText(name);jt4.setText(sex);jt5.setText(Integer.toString(age));jt6.setText(education);jt7.setText(Integer.toString(code));jt8.setText(Integer.toString(salary));}                      }    catch(Exception e2){e2.printStackTrace();}//将组件添加到容器c.add(Jl1);c.add(Jl2);c.add(Jl3);c.add(Jl4);c.add(Jl5);c.add(Jl6);c.add(Jl7);c.add(Jl8);c.add(jt1);c.add(jt2);c.add(jt3);c.add(jt4);c.add(jt5);c.add(jt6);c.add(jt7);c.add(jt8);jf13.setVisible(true);jf13.setSize(900,600);jf13.setResizable(false);  //用户不能改变窗口的大小jf13.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public void getWindows14()  //创建护士个人信息窗口{jf14=new JFrame("个人信息");jf14.setLocation(500,200);jf14.setLayout(null);JLabel imgLabel = new JLabel(new ImageIcon("src\\7.jpg")); //把照片弄到标签上jf14.getLayeredPane().add(imgLabel,new Integer(Integer.MIN_VALUE)); //以图片为背景的语法       imgLabel.setSize(900,600);Container c = jf14.getContentPane();((JPanel)c).setOpaque(false);//将控件显示为透明，漏出背景//初始化标签JLabel Jl1 = new JLabel("护士ID");JLabel Jl2 = new JLabel("姓名");JLabel Jl3 = new JLabel("年龄");JLabel Jl4 = new JLabel("性别");JLabel Jl5 = new JLabel("密码");JLabel Jl6 = new JLabel("管理病房ID");JLabel Jl7 = new JLabel("学历");JLabel Jl8 = new JLabel("工资");//初始化文本域JTextField jt1=new JTextField();JTextField jt2=new JTextField();JTextField jt3=new JTextField();JTextField jt4=new JTextField();JTextField jt5=new JTextField();JTextField jt6=new JTextField();JTextField jt7=new JTextField();JTextField jt8=new JTextField();//设置组件字体Jl1.setFont(font);Jl2.setFont(font);Jl3.setFont(font);Jl4.setFont(font);Jl5.setFont(font);Jl6.setFont(font);Jl7.setFont(font);Jl8.setFont(font);jt1.setFont(font);jt2.setFont(font);jt3.setFont(font);jt4.setFont(font);jt5.setFont(font);jt6.setFont(font);jt7.setFont(font);jt8.setFont(font);//设置组件位置Jl1.setBounds(80, 170, 143, 47);Jl2.setBounds(280, 170, 143, 47);Jl3.setBounds(475, 170, 143, 47);Jl4.setBounds(675, 170, 143, 47);Jl5.setBounds(80, 370, 143, 47);Jl6.setBounds(280, 370, 143, 47);Jl7.setBounds(475, 370, 143, 47);Jl8.setBounds(675, 370, 143, 47);jt1.setBounds(150, 170,100, 40);jt2.setBounds(350, 170,100, 40);jt3.setBounds(525, 170,100, 40);jt4.setBounds(725, 170,100, 40);jt5.setBounds(150, 370,100, 40);jt6.setBounds(400, 370,60, 40);jt7.setBounds(525, 370,100, 40);jt8.setBounds(725, 370,100, 40);//定义存数据的变量int id;        String name;int age;String sex;int code;int room_ID;String education;       int salary;//连接数据库con=getConnection(); System.out.print(input1);try{           sql=con.prepareStatement("select * from hospital.nurse where Name like ?");sql.setString(1, input1);   //查询出该用户名的所有信息res=sql.executeQuery();           //将查询到的信息取出来while(res.next())   //将信息存到临时变量上{id=res.getInt("ID");name = res.getString("Name");age=res.getInt("age");sex = res.getString("sex");code = res.getInt("code");room_ID=res.getInt("room_ID");education = res.getString("education");                salary = res.getInt("salary");  //将信息显示到文本空里jt1.setText(Integer.toString(id));jt2.setText(name);jt3.setText(Integer.toString(age));jt4.setText(sex);jt5.setText(Integer.toString(code));jt6.setText(Integer.toString(room_ID));jt7.setText(education);jt8.setText(Integer.toString(salary));}                      }    catch(Exception e2){e2.printStackTrace();}//将组件添加到容器c.add(Jl1);c.add(Jl2);c.add(Jl3);c.add(Jl4);c.add(Jl5);c.add(Jl6);c.add(Jl7);c.add(Jl8);c.add(jt1);c.add(jt2);c.add(jt3);c.add(jt4);c.add(jt5);c.add(jt6);c.add(jt7);c.add(jt8);jf14.setVisible(true);jf14.setSize(900,600);jf14.setResizable(false);  //用户不能改变窗口的大小jf14.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);//关闭窗口方式}public static void main(String[] args) {// TODO code application logic hereTest t = new Test();t.getWindows1();}}

对应的后台数据库ER图如下

由于做这个管理系统的时间比较短，总共加起来大概花了一天半的时间，而且我只是一名大二学生，可能程序中有许多不合适的地方，希望大家谅解！！！！！！