package com.qh.Frame;
import java.awt.*;
import java.awt.event.*;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.sql.*;
import java.util.*;
import java.util.List;
import java.util.concurrent.ConcurrentHashMap.KeySetView;
import javax.imageio.ImageIO;
import javax.swing.*;
import javax.swing.border.*;
import javax.swing.event.*;
import javax.swing.table.*;
import javax.swing.tree.*;
import com.qh.Modal.BasicInfo;
import com.qh.Modal.LoginIofo;
import com.qh.Modal.MyTableModel;
import com.qh.Tools.JDBC;
import com.qh.Tools.GetRelativePaths;
public class StayManageFrame
{
private JTable Table;
private List list;
private JComboBox comboBox,comboBox_2;
//存放列名
private Vector<String> titles=new Vector();
//存放数据
private Vector<Vector<Object>> data=new Vector<>();
JFrame frame =new JFrame("住宿管理");
private JButton btnNewButton;
private JButton btnNewButton_1;
private JButton btnNewButton_2;
private JScrollBar scrollBar;
public StayManageFrame()
{
//表格的相关操作
//初始化列名
titles.addElement("序号");
titles.addElement("姓名");
titles.addElement("性别");
titles.addElement("房间号");
titles.addElement("床位号");
titles.addElement("电话");
titles.addElement("状态");
//连接数据库
JDBC jdbcConnection=new JDBC();
//获取所有老人信息
try {
String sql="select * from ZhuSuXinXi;";
ResultSet res=jdbcConnection.executeQuery(sql);
int count=1; //序号
while(res.next())
{
Vector<Object> dataRow=new Vector<>(); //一行数据
dataRow.add(count++);
dataRow.add(res.getString("name"));
dataRow.add(res.getString("sex"));
dataRow.add(res.getString("roomnum"));
dataRow.add(res.getString("bednum"));
dataRow.add(res.getString("tel"));
dataRow.add(res.getString("state"));
data.add(dataRow);
}
// System.out.println(data);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//用列名和数据创建表格模型
MyTableModel model=new MyTableModel(data,titles);
//用模型来初始化表格
Table=new JTable(model);
//获取表格头
JTableHeader departmentHeader=Table.getTableHeader();
//获取表格体
Table.setFont(new Font(null,Font.PLAIN,12));
Table.setForeground(Color.BLACK);
Table.setGridColor(Color.BLACK);
Table.setRowHeight(20);
Table.setSelectionBackground(Color.yellow);
Table.setSelectionForeground(Color.red);
Table.setBounds(0,10,200,100);
//设置单行选择
Table.getSelectionModel().setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
//调整表格
TableColumn columnCount=Table.getColumn(titles.get(0)); //获取表格列
TableColumn columnNo=Table.getColumn(titles.get(1));
TableColumn columnName=Table.getColumn(titles.get(2));
TableColumn columnType=Table.getColumn(titles.get(3));
TableColumn columnTyp=Table.getColumn(titles.get(4));
TableColumn columnTe=Table.getColumn(titles.get(5));
columnCount.setMaxWidth(40); //调整其最大宽度
columnNo.setMaxWidth(80);
columnType.setMaxWidth(40);
columnName.setMaxWidth(80);
columnTe.setMinWidth(100);
columnTyp.setMaxWidth(40);
frame.setBounds(100, 100, 533, 345);
frame.setDefaultCloseOperation(frame.EXIT_ON_CLOSE);
frame.getContentPane().setLayout(null);
frame.setResizable(false);
JScrollPane scrollPane = new JScrollPane(Table);
scrollPane.setBounds(0, 0, 521, 143);
frame.getContentPane().add(scrollPane);
scrollBar = new JScrollBar();
scrollPane.setRowHeaderView(scrollBar);
btnNewButton = new JButton("点 击 添 加");
btnNewButton.setBounds(313, 153, 155, 31);
btnNewButton.setFont(new Font("楷体", Font.BOLD | Font.ITALIC, 15));
frame.getContentPane().add(btnNewButton);
btnNewButton_1 = new JButton("点 击 删 除");
btnNewButton_1.setBounds(313, 202, 155, 31);
btnNewButton_1.setFont(new Font("楷体", Font.BOLD | Font.ITALIC, 15));
frame.getContentPane().add(btnNewButton_1);
btnNewButton_2 = new JButton("点 击 修 改");
btnNewButton_2.setBounds(313, 254, 155, 31);
btnNewButton_2.setFont(new Font("楷体", Font.BOLD | Font.ITALIC, 15));
frame.getContentPane().add(btnNewButton_2);
JLabel lblNewLabel = new JLabel("New label");
lblNewLabel.setBounds(0, 141, 242, 179);
ImageIcon loginIcon=GetRelativePaths.add("Every.jpg");
lblNewLabel.setIcon(loginIcon);
lblNewLabel.setOpaque(true);
frame.getContentPane().add(lblNewLabel);
frame.setDefaultCloseOperation(frame.HIDE_ON_CLOSE);
frame.setResizable(false);
frame.setVisible(true);
frame.validate();
//删除功能
btnNewButton_1.addActionListener(new ActionListener()
{
@Override
public void actionPerformed(ActionEvent e)
{
try {
int result=JOptionPane.showConfirmDialog(frame, "确定删除该老人的住宿信息?","提示",JOptionPane.YES_NO_OPTION);
if(result==JOptionPane.YES_OPTION)
{
int selectedRow=Table.getSelectedRow();
//在数据库中删除这条数据
String oldNo=(String) model.getValueAt(selectedRow, 1);
String sql="delete from ZhuSuXinXi where name='"+oldNo+"'";
jdbcConnection.executeUpdate(sql);
int alterRow=selectedRow+1;
for(int i=alterRow;i<model.getRowCount();i++)
{
model.setValueAt(alterRow++, i, 0); //序号更改
}
model.removeRow(selectedRow); //在模型中移除该列
}
}catch(Exception e1) {
JOptionPane.showMessageDialog(null, "请选择需要删除的信息!");
}
}
});
//修改功能
btnNewButton_2.addActionListener(new ActionListener()
{
@Override
public void actionPerformed(ActionEvent arg0) {
// TODO Auto-generated method stub
try {
StayEditorFrame stayeditorFrame=new StayEditorFrame(Table.getSelectedRow(),model);
}catch(Exception e){
JOptionPane.showMessageDialog(null, "请选择需要修改的信息!");
}
}
});
//添加功能
btnNewButton.addActionListener(new ActionListener()
{
@Override
public void actionPerformed(ActionEvent arg0) {
// TODO Auto-generated method stub
StayAddFrame stayaddFrame=new StayAddFrame();
}
});
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于Java语言实现养老院信息管理系统(SQL Server数据库).zip (102个子文件)
JDBC.class 6KB
StayManageFrame.class 6KB
FeeManageFrame.class 6KB
BasicManageFrame.class 5KB
PriStayFrame.class 5KB
PriFeeFrame.class 5KB
PriBasicFrame.class 5KB
StayEditorFrame.class 4KB
BasicEditorFrame.class 3KB
AboutUsFrame.class 3KB
StayAddFrame.class 3KB
FeeAddFrame.class 3KB
BasicAddFrame.class 3KB
LoginFrame.class 3KB
PassModiFrame.class 3KB
UserFrame.class 3KB
AdminFrame.class 3KB
StayEditorFrame$1.class 2KB
RegisterFrame.class 2KB
BasicEditorFrame$1.class 2KB
BasicManageFrame$1.class 2KB
StayManageFrame$1.class 2KB
FeeManageFrame$1.class 2KB
StayAddFrame$RegisterListener.class 2KB
FeeAddFrame$RegisterListener.class 2KB
PassModiFrame$PassmodiListener.class 2KB
BasicAddFrame$RegisterListener.class 2KB
UserFrame$MyTreeListener_1.class 2KB
LoginFrame$adminLoginListener.class 2KB
LoginFrame$userLoginListener.class 2KB
AdminFrame$MyTreeListener_1.class 2KB
RegisterFrame$RegisterListener.class 1KB
ServiceTenetFrame.class 1KB
BasicManageFrame$2.class 1KB
StayManageFrame$2.class 1KB
UserFrame$1.class 1KB
BasicInfo.class 1KB
MyTableModel.class 1KB
AdminFrame$1.class 1023B
GetRelativePaths.class 910B
LoginIofo.class 907B
BasicEditorFrame$2.class 862B
StayEditorFrame$2.class 856B
LoginFrame$registerListener.class 832B
BasicManageFrame$3.class 818B
FeeManageFrame$3.class 811B
StayManageFrame$3.class 810B
BasicAddFrame$1.class 805B
PriBasicFrame$1.class 805B
PriBasicFrame$2.class 805B
FeeManageFrame$2.class 801B
PriStayFrame$1.class 799B
StayAddFrame$1.class 799B
PriStayFrame$2.class 799B
PriFeeFrame$2.class 793B
FeeAddFrame$1.class 793B
PriFeeFrame$1.class 793B
PassModiFrame$1.class 737B
Main.class 473B
StayManageFrame.java 6KB
BasicManageFrame.java 6KB
FeeManageFrame.java 6KB
StayEditorFrame.java 5KB
StayAddFrame.java 5KB
FeeAddFrame.java 5KB
BasicEditorFrame.java 5KB
PriStayFrame.java 5KB
PriFeeFrame.java 5KB
BasicAddFrame.java 4KB
PriBasicFrame.java 4KB
LoginFrame.java 4KB
PassModiFrame.java 3KB
UserFrame.java 3KB
AdminFrame.java 3KB
AboutUsFrame.java 2KB
RegisterFrame.java 2KB
ServiceTenetFrame.java 1KB
BasicInfo.java 603B
LoginIofo.java 511B
Main.java 245B
User.jpg 116KB
User.jpg 116KB
Login.jpg 69KB
Login.jpg 69KB
Text.jpg 64KB
Text.jpg 64KB
Aboutus.jpg 61KB
Aboutus.jpg 61KB
Register.jpg 34KB
Register.jpg 34KB
Tenet2.jpg 26KB
Tenet2.jpg 26KB
Tenet1.jpg 25KB
Tenet1.jpg 25KB
Every.jpg 24KB
Every.jpg 24KB
Editor.jpg 10KB
Editor.jpg 10KB
Fee.jpg 9KB
Fee.jpg 9KB
共 102 条
- 1
- 2
资源评论
博士僧小星
- 粉丝: 1907
- 资源: 5877
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功