package Project_employee;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import jxl.Workbook;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.Label;
import javax.swing.*;
@SuppressWarnings("serial")
public class StaffSearch1 extends JFrame implements StaffDao{
private JTextField textField;
private JTextField textField_1;
private JTextField textField_2;
private JTextField textField_3;
private JTextField textField_4;
private JTextField textField_5;
private JTextField textField_6;
private JTextField textField_7;
private JTextField textField_8;
public StaffSearch1() {
getContentPane().setLayout(null);
JLabel label = new JLabel("病人编号");
label.setForeground(Color.WHITE);
label.setHorizontalAlignment(SwingConstants.CENTER);
label.setFont(new Font("微软雅黑", Font.BOLD, 20));
label.setBounds(70, 32, 162, 38);
getContentPane().add(label);
textField = new JTextField();
textField.setBounds(204, 42, 196, 24);
getContentPane().add(textField);
textField.setColumns(10);
JButton btnSearch = new JButton("SEARCH");
btnSearch.setFont(new Font("微软雅黑", Font.BOLD, 18));
btnSearch.setBounds(477, 39, 113, 27);
getContentPane().add(btnSearch);
//查询按钮事件监听
btnSearch.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent arg0) {
searchEmployee();
}
});
JButton btnNewButton = new JButton("\u8FD4\u56DE");
btnNewButton.setFont(new Font("微软雅黑", Font.PLAIN, 15));
btnNewButton.setBounds(580, 403, 113, 27);
getContentPane().add(btnNewButton);
JLabel lblNewLabel = new JLabel("病人编号");
lblNewLabel.setForeground(Color.WHITE);
lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 17));
lblNewLabel.setBounds(70, 121, 72, 18);
getContentPane().add(lblNewLabel);
JLabel label_1 = new JLabel("病历号");
label_1.setForeground(Color.WHITE);
label_1.setHorizontalAlignment(SwingConstants.CENTER);
label_1.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_1.setBounds(70, 196, 72, 18);
getContentPane().add(label_1);
JLabel label_2 = new JLabel("籍贯");
label_2.setForeground(Color.WHITE);
label_2.setHorizontalAlignment(SwingConstants.CENTER);
label_2.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_2.setBounds(70, 263, 72, 18);
getContentPane().add(label_2);
JLabel label_3 = new JLabel("年龄");
label_3.setForeground(Color.WHITE);
label_3.setHorizontalAlignment(SwingConstants.CENTER);
label_3.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_3.setBounds(70, 326, 72, 18);
getContentPane().add(label_3);
textField_1 = new JTextField();
textField_1.setEditable(false);
textField_1.setBounds(156, 120, 129, 24);
getContentPane().add(textField_1);
textField_1.setColumns(10);
textField_2 = new JTextField();
textField_2.setEditable(false);
textField_2.setColumns(10);
textField_2.setBounds(156, 195, 129, 24);
getContentPane().add(textField_2);
textField_3 = new JTextField();
textField_3.setEditable(false);
textField_3.setColumns(10);
textField_3.setBounds(156, 262, 129, 24);
getContentPane().add(textField_3);
textField_4 = new JTextField();
textField_4.setEditable(false);
textField_4.setColumns(10);
textField_4.setBounds(156, 325, 129, 24);
getContentPane().add(textField_4);
JLabel label_4 = new JLabel("姓名");
label_4.setForeground(Color.WHITE);
label_4.setHorizontalAlignment(SwingConstants.CENTER);
label_4.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_4.setBounds(411, 123, 72, 18);
getContentPane().add(label_4);
JLabel label_5 = new JLabel("性别");
label_5.setForeground(Color.WHITE);
label_5.setHorizontalAlignment(SwingConstants.CENTER);
label_5.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_5.setBounds(411, 196, 72, 18);
getContentPane().add(label_5);
JLabel label_6 = new JLabel("电话");
label_6.setForeground(Color.WHITE);
label_6.setHorizontalAlignment(SwingConstants.CENTER);
label_6.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_6.setBounds(411, 263, 72, 18);
getContentPane().add(label_6);
JLabel label_7 = new JLabel("身份证号");
label_7.setForeground(Color.WHITE);
label_7.setHorizontalAlignment(SwingConstants.CENTER);
label_7.setFont(new Font("微软雅黑", Font.BOLD, 17));
label_7.setBounds(411, 326, 72, 18);
getContentPane().add(label_7);
textField_5 = new JTextField();
textField_5.setEditable(false);
textField_5.setBounds(490, 120, 129, 24);
getContentPane().add(textField_5);
textField_5.setColumns(10);
textField_6 = new JTextField();
textField_6.setEditable(false);
textField_6.setColumns(10);
textField_6.setBounds(490, 195, 129, 24);
getContentPane().add(textField_6);
textField_7 = new JTextField();
textField_7.setEditable(false);
textField_7.setColumns(10);
textField_7.setBounds(490, 262, 129, 24);
getContentPane().add(textField_7);
textField_8 = new JTextField();
textField_8.setEditable(false);
textField_8.setColumns(10);
textField_8.setBounds(490, 325, 129, 24);
getContentPane().add(textField_8);
JButton btnexcel = new JButton("\u751F\u6210Excel");
btnexcel.setFont(new Font("微软雅黑", Font.PLAIN, 15));
btnexcel.setBounds(72, 403, 113, 27);
getContentPane().add(btnexcel);
//生成excel表格事件监听
btnexcel.addActionListener(new ActionListener() {
@SuppressWarnings("static-access")
@Override
public void actionPerformed(ActionEvent arg0) {
ArrayList<Staff> list=new ArrayList<Staff>();
if(textField_1.getText().equals("")) {
JOptionPane.showMessageDialog(null,"请先查询出所需导出的病人信息");
}
else {
String id=textField_1.getText();
String name=textField_5.getText();
String blhao=textField_2.getText();
String sfzhao=textField_8.getText();
String jiguan=textField_3.getText();
String sex=textField_6.getText();
String age=textField_4.getText();
String num=textField_7.getText();
list.add(new Staff(id,name,blhao,sfzhao,jiguan,sex,age,num));
try {
WritableWorkbook wwb=null;
String filename="D://java//em_info.xls";
File file=new File(filename);
if(!file.exists()) {
file.createNewFile();
}
wwb=Workbook.createWorkbook(file);
WritableSheet ws=wwb.createSheet("Test sheet 1", 0);
Label labelId=new Label(0,0,"病人编号(id)");
Label labelName=new Label(1,0,"姓名(name)");
Label labelType=new Label(2,0,"电话(num)");
Label labelXueli=new Label(3,0,"年龄(age)");
Label labelAddress=new Label(4,0,"病历号(bihao)");
Label labelSex=new Label(5,0,"身份证号(sfzhao)");
Label labelAge=new Label(6,0,"性别(sex)");
Label labelSalary=new Label(7,0,"籍贯(address)");
ws.addCell(labelId);ws.addCell(labelName);ws.addCell(labelType);
ws.addCell(labelXueli);ws.addCell(labelAddress);ws.addCell(labelSex);
ws.addCell(labelAge);ws.addCell(labelSalary);
for(int i
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
电子病历管理系统 王梦冲 林宣治 capstone_病历_java_病历系统_电子病历_电子病历系统_ (129个子文件)
StaffUpdate.class 8KB
StaffDelete1.class 8KB
StaffSearch1.class 8KB
StaffDelete.class 8KB
StaffSearch.class 8KB
StaffUpdate1.class 8KB
MainMenu$1.class 6KB
Register.class 5KB
StaffAdd.class 5KB
MainMenu.class 5KB
StaffAdd1.class 5KB
StaffUpdate$3.class 5KB
StaffSearch1$2.class 5KB
StaffSearch$2.class 5KB
StaffUpdate1$3.class 4KB
StaffAdd$1.class 4KB
StaffAdd1$1.class 4KB
Register$2.class 3KB
InfoDemo1.class 3KB
InfoDemo.class 3KB
SubMenu1.class 3KB
SubMenu.class 3KB
StaffDelete1$2.class 3KB
StaffDelete$2.class 3KB
Staff2.class 2KB
Staff1.class 2KB
Staff.class 2KB
insertTest.class 1KB
jdbc.class 1KB
User.class 939B
StaffSearch1$3.class 764B
StaffSearch$3.class 757B
SubMenu1$3.class 743B
SubMenu1$1.class 743B
SubMenu1$4.class 743B
SubMenu1$2.class 740B
MainMenu$2.class 739B
SubMenu$3.class 736B
SubMenu$1.class 736B
SubMenu$4.class 736B
SubMenu$2.class 733B
StaffSearch1$1.class 732B
StaffDelete1$1.class 732B
StaffUpdate1$1.class 732B
StaffUpdate$1.class 726B
StaffSearch$1.class 726B
StaffDelete$1.class 726B
StaffDelete1$3.class 725B
StaffSearch1$4.class 725B
StaffUpdate1$4.class 725B
StaffSearch$4.class 719B
StaffDelete$3.class 719B
StaffUpdate$4.class 719B
StaffAdd1$2.class 707B
InfoDemo1$1.class 707B
SubMenu1$5.class 701B
StaffAdd$2.class 701B
InfoDemo$1.class 701B
Register$1.class 701B
SubMenu$5.class 695B
StaffUpdate1$2.class 694B
StaffUpdate$2.class 688B
LoginTest.class 592B
UserExistException.class 457B
StaffDao.class 145B
.classpath 507B
.classpath 507B
电子病历管理系统课程总结.doc 1.38MB
系统使用说明书( 电子病历管理系统).docx 316KB
StaffSearch1.java 13KB
StaffSearch.java 13KB
StaffUpdate1.java 12KB
StaffUpdate.java 12KB
MainMenu.java 10KB
StaffDelete.java 10KB
StaffDelete1.java 10KB
StaffAdd1.java 8KB
StaffAdd.java 8KB
Register.java 7KB
SubMenu1.java 4KB
SubMenu.java 3KB
InfoDemo1.java 2KB
InfoDemo.java 2KB
LoginTest.java 2KB
Staff1.java 2KB
Staff.java 2KB
Staff2.java 2KB
insertTest.java 1011B
jdbc.java 691B
User.java 673B
UserExistException.java 214B
StaffDao.java 92B
MainMenu_backgroud.jpg 136KB
MainMenu_backgroud.jpg 136KB
Staffupdate_backgroud.jpg 54KB
Staffupdate_backgroud.jpg 54KB
Staffdelete_backgroud.jpg 54KB
Staffdelete_backgroud.jpg 54KB
Staffsearch_1_backgroud.jpg 51KB
Staffsearch_1_backgroud.jpg 51KB
共 129 条
- 1
- 2
资源评论
- qq_417887212022-03-06用户下载后在一定时间内未进行评价,系统默认好评。
- m0_481054552022-01-18用户下载后在一定时间内未进行评价,系统默认好评。
- banxia0212022-12-03资源不错,内容挺好的,有一定的使用价值,值得借鉴,感谢分享。
程籽籽
- 粉丝: 67
- 资源: 4722
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功