Java+Swing实现医院管理系统

2501_90223218

于 2025-01-12 08:49:33 发布

阅读量930

点赞数 6

文章标签： java 前端大数据

本文链接：https://blog.youkuaiyun.com/2501_90223218/article/details/145086533

版权

int b1 = Integer.valueOf(b).intValue();

double d = a1 * b1;

sume = sume + d;

sum5 = String.valueOf(sume);

}

sume = 0;

if (sum5 != null) {

tx9.setText(sum5);

} else {

tx9.setText(“0.0”);

}

} catch (Exception ex) {

ex.printStackTrace();

}

try {

String sql1 = “select PePrice,PeNumber from DrugTable where MrId='” + tx1.getText()

“’ and PeName=‘化验费’”;

Statement stmt = con.createStatement();

rs = stmt.executeQuery(sql1);

while (rs.next()) {

String a = rs.getString(1);

String b = rs.getString(2);

double a1 = Double.valueOf(a).doubleValue();

int b1 = Integer.valueOf(b).intValue();

double d = a1 * b1;

sumf = sumf + d;

sum6 = String.valueOf(sumf);

}

sumc = 0;

if (sum6 != null) {

tx10.setText(sum6);

} else {

tx10.setText(“0.0”);

}

} catch (Exception ex) {

ex.printStackTrace();

}

try {

String sql1 = “select PaPay from Patient where PaId='” + tx2.getText() + “'”;

Statement stmt = con.createStatement();

rs = stmt.executeQuery(sql1);

while (rs.next()) {

String a = rs.getString(1);

if (a != null) {

tx11.setText(a);

} else {

tx11.setText(“0.0”);

}

} catch (Exception ex) {

ex.printStackTrace();

}

String t;

String y;

String u;

String u1;

String u2;

String u3;

String u4;

t = tx5.getText();

u1 = tx6.getText();

u2 = tx8.getText();

u3 = tx9.getText();

u4 = tx10.getText();

u = tx7.getText();

y = tx11.getText();

float c = Float.parseFloat(u);

float c1 = Float.parseFloat(t);

float c2 = Float.parseFloat(y);

float c4 = Float.parseFloat(u1);

float c5 = Float.parseFloat(u2);

float c6 = Float.parseFloat(u3);

float c7 = Float.parseFloat(u4);

float q = (float) (c2 - (c7 + c6 + c5 + c4 + c1 + c));// 减除押金后需要交的钱

float q1 = (float) ((c7 + c6 + c5 + c4 + c1 + c));// 费用总计

String s = String.valueOf(q);

String s1 = String.valueOf(q1);

tx12.setText(s);

tx13.setText(s1);

tx12.setForeground(Color.BLUE);

tx11.setForeground(Color.BLUE);

}

});

}

private void databaseSearch1(String sql, int i) {

// TODO Auto-generated method stub

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

ResultSet rs;

try {

int rowcount = dtm3.getRowCount() - 1;

if (rowcount != -1) {

for (int i1 = rowcount; i1 >= 0; i1–) {

dtm3.removeRow(i1); // 删除Jtable中的所有行

}

dtm3.setRowCount(0); // 将Jtable中的行数设为零

}

Statement stmt = con.createStatement();

rs = stmt.executeQuery(sql);

String[] data = new String[4];

while (rs.next()) {

for (int j = 1; j <= 4; j++) {

data[j - 1] = rs.getString(j); // 取出数据库中的数组装载到数组中

}

dtm3.addRow(data); // 在Jtabl

}

con.close();

// 设置表格隔行背景色（隔行背景色不同）

} catch (Exception err) {

}

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

if (e.getSource() == btn1) {

// 把费用表录入到收费表中

try {

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

Statement stmt = con.createStatement();

String sql = “INSERT INTO Charge(MrId,PaId,PaName,DeptName,Drugfee,treatmentfee,checkfee,registrationfee,disposalfee,assayfee,sum,time)VALUES(?,?,?,?,?,?,?,?,?,?,?,?)”;

PreparedStatement parepare = con.prepareStatement(sql);

parepare.setString(1, tx1.getText());

parepare.setString(2, tx2.getText());

parepare.setString(3, tx3.getText());

parepare.setString(4, tx4.getText());

parepare.setString(5, tx5.getText());

parepare.setString(6, tx6.getText());

parepare.setString(7, tx7.getText());

parepare.setString(8, tx8.getText());

parepare.setString(9, tx9.getText());

parepare.setString(10, tx10.getText());

parepare.setString(11, tx13.getText());

parepare.setString(12, tx14.getText());

// 判断是否有输入错误的，做提示操作

if (tx1.getText().equals(“”)) {

JOptionPane.showMessageDialog(null, “请输入结算的档案号”, “错误”, JOptionPane.INFORMATION_MESSAGE);

} else {

parepare.executeUpdate();

JOptionPane.showMessageDialog(null, “结账成功，需要交（退）” + tx12.getText() + “”, “结账成功”,

JOptionPane.INFORMATION_MESSAGE);

String sql1 = “delete from Patient where PaId='” + tx2.getText() + “'”;

try {

stmt.executeUpdate(sql1);

tx0.setText(“”);

tx1.setText(“”);

tx2.setText(“”);

tx3.setText(“”);

tx4.setText(“”);

tx5.setText(“”);

tx6.setText(“”);

tx7.setText(“”);

tx8.setText(“”);

tx9.setText(“”);

tx10.setText(“”);

tx11.setText(“”);

tx12.setText(“”);

tx13.setText(“”);

tx14.setText(“”);

JScrollPane5.setVisible(false);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

} catch (Exception e2) {

e2.printStackTrace();

}

} else if (e.getSource() == btn2) {

tx0.setText(“”);

tx1.setText(“”);

tx2.setText(“”);

tx3.setText(“”);

tx4.setText(“”);

tx5.setText(“”);

tx6.setText(“”);

tx7.setText(“”);

tx8.setText(“”);

tx9.setText(“”);

tx10.setText(“”);

tx11.setText(“”);

tx12.setText(“”);

tx13.setText(“”);

tx14.setText(“”);

JScrollPane5.setVisible(false);

}

ChargeQuery.java

package com.sjsq;

import java.awt.Color;

import java.awt.Component;

import java.awt.Font;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.swing.ImageIcon;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.table.DefaultTableCellRenderer;

import javax.swing.table.DefaultTableModel;

public class ChargeQuery {

Font f1 = new Font(“隶书”, Font.BOLD, 30);

public static JTable table;

public static DefaultTableModel dtm;

private JScrollPane JScrollPane = new JScrollPane();

JPanel panel2 = new JPanel();

private JLabel la1, la2, la3, la4, la5;

private JTextField tx1, tx2;

private String columnNames[] = { “就医档案编号”, “病人编号”, “病人姓名”, “就医科室”, “用药费用”, “治疗费”, “检查费”, “挂号费”, “处置费”, “化验费”,

“费用总额”, “结账时间” };

ChargeQuery() {

// 添加背景

ImageIcon background = new ImageIcon(“picture/right_bg.jpg”); // 背景图片

JLabel label = new JLabel(background);

panel2.setLayout(null);

// 设置默认表格面板

dtm = new DefaultTableModel(columnNames, 0);

table = new JTable(dtm) {

public boolean isCellEditable(int row, int column) {

return false;

}// 表格不允许被编辑 }

};

String sql = “select * from Charge”;

databaseSearch(sql, 12);

JScrollPane.setViewportView(table);// 给表格添加滚动条

panel2.add(JScrollPane);

JScrollPane.setBounds(30, 200, 950, 300);

setbgcolor();

JLabel label1 = new JLabel(“收费统计”);

panel2.add(label1);

label1.setBounds(30, 10, 400, 50);

label1.setFont(f1);

la1 = new JLabel(“总费用统计:”);

la2 = new JLabel(“人数统计:”);

tx1 = new JTextField();

tx2 = new JTextField();

la1.setBounds(30, 80, 100, 50);

la2.setBounds(30, 120, 100, 50);

tx1.setBounds(100, 90, 100, 30);

tx2.setBounds(100, 130, 100, 30);

panel2.add(la1);

panel2.add(la2);

panel2.add(tx1);

panel2.add(tx2);

tx1.setEditable(false);

tx2.setEditable(false);

panel2.add(label);// 面板添加背景图片，设置位置

label.setBounds(-30, 0, 1100, 700);

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

ResultSet rs, rs1;

try {

String sql2 = "select Sum(sum) from Charge ";

String sql1 = "select count(*) from Charge ";

Statement stmt = con.createStatement();

Statement stmt1 = con.createStatement();

rs = stmt.executeQuery(sql1);

rs1 = stmt1.executeQuery(sql2);

while (rs.next()) {

String a = rs.getString(1);

tx2.setText(a);

}

while (rs1.next()) {

String a = rs1.getString(1);

tx1.setText(a);

}

} catch (Exception e) {

e.printStackTrace();

}

private void setbgcolor() {

// TODO Auto-generated method stub

try {

DefaultTableCellRenderer tcr = new DefaultTableCellRenderer() {

public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected,

boolean hasFocus, int row, int column) {

if (row % 2 == 0)

setBackground(new Color(223, 220, 239)); // 设置奇数行底色

else if (row % 2 == 1)

setBackground(Color.white); // 设置偶数行底色

return super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);

}

};

for (int i = 0; i < table.getColumnCount(); i++) {

table.getColumn(table.getColumnName(i)).setCellRenderer(tcr);

}

} catch (Exception ex) {

ex.printStackTrace();

}

private void databaseSearch(String sql, int i) {

// TODO Auto-generated method stub

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

ResultSet rs;

try {

int rowcount = dtm.getRowCount() - 1;

if (rowcount != -1) {

for (int i1 = rowcount; i1 >= 0; i1–) {

dtm.removeRow(i1); // 删除Jtable中的所有行

}

dtm.setRowCount(0); // 将Jtable中的行数设为零

}

Statement stmt = con.createStatement();

rs = stmt.executeQuery(sql);

String[] data = new String[12];

while (rs.next()) {

for (int j = 1; j <= 12; j++) {

data[j - 1] = rs.getString(j); // 取出数据库中的数组装载到数组中

}

dtm.addRow(data); // 在Jtable中添加数据行

}

con.close();

// 设置表格隔行背景色（隔行背景色不同）

} catch (Exception err) {

}

ChufangModify.java

package com.sjsq;

import java.awt.Color;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.DefaultCellEditor;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.border.TitledBorder;

import javax.swing.event.DocumentEvent;

import javax.swing.event.DocumentListener;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableColumn;

public class ChufangModify extends JFrame implements ActionListener, ItemListener {

JButton button6 = new JButton(“增加”);

JButton button7 = new JButton(“确定”);

JButton button8 = new JButton(“删除”);

private String columnNames[] = { “编码”, “名称”, “单价”, “数量”, “计数单位”, “类别”, “档案编号” };

private String columnNames1[] = { “编码”, “名称”, “单价”, “计数单位”, “类别” };

private JLabel la0;

private JComboBox box1, box2;

JPanel panel2 = new JPanel();

public static JTable table2, table3;

public static DefaultTableModel dtm2, dtm3;

private JScrollPane JScrollPane3 = new JScrollPane();

private JScrollPane JScrollPane5 = new JScrollPane();

String y;

ChufangModify(String Stitle) {

super(Stitle);

panel2.setLayout(null);

ImageIcon ic; // 按钮图片

ic = new ImageIcon(“picture/right_bg.jpg”);

JLabel label = new JLabel(ic);// 把背景图片显示在一个标签里面

dtm2 = new DefaultTableModel(columnNames, 0) {// dtm2是项目收费表格模版

public boolean isCellEditable(int row, int column) {

if (column == 1 || column == 3)

return true;// 这个是可以编辑的列

// if(rowIndex!=0) return false;

return false;

}// 表格不允许被编辑 }

};

String fontSize1[] = { “1”, “2”, “3”, “4”, “5”, “6”, “7”, “8”, “9”, “10”, “12” };

table2 = new JTable(dtm2);// JScrollPane4 项目表

JScrollPane JScrollPane4 = new JScrollPane(table2);

TableColumn a1 = table2.getColumn(“名称”);

TableColumn a2 = table2.getColumn(“数量”);

JTextField box3 = new JTextField();

box2 = new JComboBox(fontSize1);

box2.addActionListener(this);

box2.addItemListener(this);

box3.getDocument().addDocumentListener(new DocumentListener() {

@Override

public void removeUpdate(DocumentEvent e) {

System.out.println(“removeUpdate”);

updata_combobox();

}

@Override

public void insertUpdate(DocumentEvent e) {

System.out.println(“insertUpdate”);

updata_combobox();

}

@Override

public void changedUpdate(DocumentEvent e) {

updata_combobox();

}

private void updata_combobox() {

String s1 = null;

s1 = box3.getText();

String sql = “select * from Price where PeName like '%” + s1 + “%'and PeClass=‘其他类’”;

databaseSearch1(sql, 5);

}

});

box3.setEditable(true);

DefaultCellEditor dce2 = new DefaultCellEditor(box3);

a1.setCellEditor(dce2);

box2.setEditable(true);

box2.setMaximumRowCount(5);

DefaultCellEditor dce3 = new DefaultCellEditor(box2);

a2.setCellEditor(dce3);

box2.addActionListener(this);

final JPanel panel = new JPanel();

panel.setLayout(null);

panel.setBorder(new TitledBorder(null, “诊疗项目单”, TitledBorder.DEFAULT_JUSTIFICATION,

TitledBorder.DEFAULT_POSITION, null, null));

panel.setBounds(20, 150, 530, 180);

panel.setBackground(Color.WHITE);

panel.add(JScrollPane4);

JScrollPane4.setBounds(10, 20, 400, 150);

panel2.add(panel);

button6.setBounds(420, 20, 100, 40);

panel.add(button6);

button7.setBounds(420, 70, 100, 40);

panel.add(button7);

button8.setBounds(420, 120, 100, 40);

panel.add(button8);

button6.addActionListener(this);

button7.addActionListener(this);

button8.addActionListener(this);

dtm3 = new DefaultTableModel(columnNames1, 0);// 项目明细表

table3 = new JTable(dtm3) {

public boolean isCellEditable(int row, int column) {

return false;

}// 表格不允许被编辑 }

};

JScrollPane5.setViewportView(table3);

panel2.add(JScrollPane5);

JScrollPane5.setBounds(30, 50, 400, 100);

JScrollPane5.setVisible(false);

String SQL1 = “select * from Price where PeClass=‘其他类’”;

databaseSearch1(SQL1, 5);

JScrollPane4.setViewportView(table2);

box3.addMouseListener(new MouseAdapter() {// 设置TABLE双击鼠标事件

public void mouseClicked(MouseEvent e) {

if (e.getButton() == MouseEvent.BUTTON1) // 单击鼠标左键

JScrollPane5.setVisible(true);

}

});

button8.addMouseListener(new MouseAdapter() { // 删除按钮实现删除记录的功能

public void mouseClicked(MouseEvent e) {

int row = table2.getSelectedRow();// 这句选择要删除的行

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

Statement stmt;

String val = (String) table2.getValueAt(row, 6);

String val1 = (String) table2.getValueAt(row, 0);

String sql = “delete from DrugTable where MrId='” + val + “‘and PeNo=’” + val1 + “'”;

try {

stmt = con.createStatement();

stmt.executeUpdate(sql);

button6.setEnabled(true);

JOptionPane.showMessageDialog(null, " 删除成功！", “注意”, JOptionPane.INFORMATION_MESSAGE);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

if (row != -1) { // 这句判断是否有选中的行

dtm2.removeRow(row);

} // 这句删除指定行

}

});

table3.addMouseListener(new MouseAdapter() {// 设置TABLE双击鼠标事件

public void mouseClicked(MouseEvent e) {

if (e.getButton() == MouseEvent.BUTTON1) // 单击鼠标左键

if (e.getClickCount() == 2) {

int o = table3.getSelectedRow();

int row = table2.getSelectedRow();

String ao = (String) table3.getValueAt(o, 1);

String bo = (String) table3.getValueAt(o, 0);

String co = (String) table3.getValueAt(o, 2);

String eo = (String) table3.getValueAt(o, 4);

String qo = (String) table3.getValueAt(o, 3);

System.out.println(ao);

box3.setText(ao);

table2.setValueAt(bo, row, 0);

table2.setValueAt(co, row, 2);

table2.setValueAt(eo, row, 5);

table2.setValueAt(qo, row, 4);

y = co;

JScrollPane5.setVisible(false);

}

});

panel2.add(label);

label.setBounds(0, 0, 600, 400);

this.add(panel2);

this.setSize(600, 400); // 设置窗口大小

this.setResizable(false); // 设置不可调整窗口大小

this.setLocationRelativeTo(null);

this.setVisible(true);

}

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

if (e.getSource() == button7) {

try {

String s = (String) box2.getSelectedItem();

int i = Integer.valueOf(s).intValue();

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

int row = table2.getSelectedRow();

String b = (String) table2.getValueAt(row, 3);

String sql = “INSERT INTO DrugTable(PeNo,PeName,PePrice,PeNumber,PeUnit,PeClass,MrId)VALUES(?,?,?,?,?,?,?)”;

PreparedStatement parepare = con.prepareStatement(sql);

parepare.setString(1, (String) table2.getValueAt(row, 0));

parepare.setString(2, (String) table2.getValueAt(row, 1));

parepare.setString(3, (String) table2.getValueAt(row, 2));

parepare.setString(4, (String) table2.getValueAt(row, 3));

parepare.setString(5, (String) table2.getValueAt(row, 4));

parepare.setString(6, (String) table2.getValueAt(row, 5));

parepare.setString(7, (String) table2.getValueAt(row, 6));

if (i <= 0 || b == “”) {

JOptionPane.showMessageDialog(null, “数量不能小于0或为空”, “错误”, JOptionPane.INFORMATION_MESSAGE);

}

else {

parepare.executeUpdate();

JOptionPane.showMessageDialog(null, “录入成功”, “录入成功”, JOptionPane.INFORMATION_MESSAGE);

button6.setEnabled(true);

}

} catch (Exception et) {

et.printStackTrace();

}

public void databaseSearch1(String SQL1, int i) {

// TODO Auto-generated method stub

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

ResultSet rs;

try {

int rowcount = dtm3.getRowCount() - 1;

if (rowcount != -1) {

for (int i1 = rowcount; i1 >= 0; i1–) {

dtm3.removeRow(i1); // 删除Jtable中的所有行

}

dtm3.setRowCount(0); // 将Jtable中的行数设为零

}

Statement stmt = con.createStatement();

rs = stmt.executeQuery(SQL1);

String[] data = new String[5];

while (rs.next()) {

for (int j = 1; j <= 5; j++) {

data[j - 1] = rs.getString(j); // 取出数据库中的数组装载到数组中

}

dtm3.addRow(data); // 在Jtabl

}

con.close();

// 设置表格隔行背景色（隔行背景色不同）

} catch (Exception err) {

}

public void addrow(JTable table) {

// TODO Auto-generated method stub

int row = table.getSelectedRow();

String b = (String) table.getValueAt(row, 0);

button6.addActionListener(new ActionListener() {// 添加事件

public void actionPerformed(ActionEvent e) {

String[] da1 = { “”, “” };

String[] rowValues = da1;

dtm2.addRow(rowValues); // 添加一行

int row1 = table2.getRowCount() - 1;

table2.setRowSelectionInterval(row1, row1);

table2.setValueAt(b, row1, 6);

button6.setEnabled(false);

}

});

}

public void databaseSearch2(String SQL, int i) {

DBUtil dbUtil = new DBUtil();

Connection con = dbUtil.getConnection();

ResultSet rs;

try {

int rowcount = dtm2.getRowCount() - 1;

if (rowcount != -1) {

for (int i1 = rowcount; i1 >= 0; i1–) {

dtm2.removeRow(i1); // 删除Jtable中的所有行

}

dtm2.setRowCount(0); // 将Jtable中的行数设为零

}

Statement stmt = con.createStatement();

rs = stmt.executeQuery(SQL);

String[] data = new String[7];

while (rs.next()) {

for (int j = 1; j <= 7; j++) {

data[j - 1] = rs.getString(j); // 取出数据库中的数组装载到数组中

}

dtm2.addRow(data); // 在Jtabl

}

con.close();

// 设置表格隔行背景色（隔行背景色不同）

} catch (Exception err) {

}

@Override

public void itemStateChanged(ItemEvent e) {

// TODO Auto-generated method stub

}

DBUtil.java

package com.sjsq;

import java.sql.Connection;

import java.sql.DriverManager;

public class DBUtil {

// 连接

private Connection con = null;

public String url = “jdbc:mysql://localhost:3306/swing_hospital_management?serverTimezone=UTC”;

public String username = “root”;

public String password = “admin”;

// 获取连接

public Connection getConnection() {

try {

con = DriverManager.getConnection(url, username, password);

} catch (Exception e) {

e.printStackTrace();

System.out.println(“获取连接失败:” + e.getMessage());

}

return con;

}

// 关闭连接

public void close() {

try {

if (con != null) {

con.close();

}

con = null;

System.out.println(“数据库连接关闭”);

} catch (Exception e) {

e.printStackTrace();

}

// 测试

public static void main(String[] args) {

DBUtil dbUtil = new DBUtil();

dbUtil.getConnection();

}

DepartmentManage.java

package com.sjsq;

import java.awt.Color;

import java.awt.Component;

import java.awt.Font;

import java.awt.Rectangle;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.regex.Pattern;

import javax.swing.DefaultComboBoxModel;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JDialog;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JMenuItem;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JPopupMenu;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.border.TitledBorder;

import javax.swing.table.DefaultTableCellRenderer;

import javax.swing.table.DefaultTableModel;

public class DepartmentManage extends JFrame implements ActionListener {

JPanel departmentManage = new JPanel();

private JLabel manageTitle = new JLabel(“科室信息综合操作”);

private JLabel la1, la2, la3, la4, la5, la6;

private JTextField tx1, tx2, tx3, tx4, tx5, tx6;

public JButton save, query, modify, delete;

private Font laFont = new Font(“宋体”, Font.BOLD, 15);

private JComboBox jcbb1;

private String str1[] = { “查询全部”, “按科室编号查询”, “按科室名称查询” };

private final String[] columnNames = { “科室编号”, “科室名称”, “科室主任”, “科室电话” };

private JScrollPane JScrollPane1 = new JScrollPane();

private java.sql.Connection con = null;

private static JTable table;

private static DefaultTableModel dtm;

private Pattern pattern = Pattern.compile(“[0-9]*”);

public DepartmentManage() {

// 背景设置

departmentManage.setLayout(null);

ImageIcon background = new ImageIcon(“picture/right_bg.jpg”);

JLabel label = new JLabel(background);

// 标题设置

manageTitle.setFont(new Font(“宋体”, Font.BOLD, 50));

最低0.47元/天解锁文章