package sql.view;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.List;
import javax.swing.JButton;
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.ListSelectionModel;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import sql.Utils;
import sql.Info.AdminInfo;
import sql.Info.CardInfo;
import sql.Info.ComputerInfo;
import sql.Info.RecordInfo;
import sql.dao.AdminDao;
import sql.dao.CardDao;
import sql.dao.ComputerDao;
import sql.dao.RecordDao;
import sql.view.LoginPanel.MyActionListener;
public class MainPanel extends JPanel implements ActionListener {
public JLabel lblMsg = null;
private JTextField tfstuComputer, tfstuNumber;
private JButton btnCard, btnComputer, bntend, bntbianji, bntrecord,bntxia;
private JTable table = null;
private JTable table1 = null;
private List<CardInfo> cardList = null;
private List<ComputerInfo> computerList = null;
private List<RecordInfo> recordList = null;
private boolean showCardList;
private boolean showrecordList;
private static final String[] cardColumnName = { "账号", "密码", "用户名", "余额", "状态" };
private static final String[] computerColumnName = { "电脑号", "状态", "区域", "配置" };
private static final String[] recordColumnName = { "流水号", "机器号", "卡号", "上机时间" };
private AbstractTableModel tm = new AbstractTableModel() {
private static final long serialVersionUID = 5424929509142118524L;
// 返回表格中每列的列名
public String getColumnName(int column) {
if (showCardList) {
return cardColumnName[column];
} else {
return computerColumnName[column];
}
}
// 返回每列的数据类型
public java.lang.Class<?> getColumnClass(int columnIndex) {
if (showCardList) {
return String.class;
} else {
return String.class;
}
}
// 返回单元格是否允许编辑
public boolean isCellEditable(int rowIndex, int columnIndex) {
return false;
}
// 返回表格中数据的行数
public int getRowCount() {
if (showCardList) {
if (cardList != null) {
return cardList.size();
}
} else {
if (computerList != null) {
return computerList.size();
}
}
return 0;
}
// 返回列数
public int getColumnCount() {
if (showCardList) {
return cardColumnName.length;
} else {
return computerColumnName.length;
}
}
// 返回每个单元格中的数据
public Object getValueAt(int rowIndex, int columnIndex) {
Object result = null;
if (showCardList) {
CardInfo info = cardList.get(rowIndex);
switch (columnIndex) {
case 0:
result = info.getCARDID();
break;
case 1:
result = info.getPASSWORD();
break;
case 2:
result = info.getUSERNAME();
break;
case 3:
result = info.getBALANCE();
break;
case 4:
result = info.getSTATUSS();
break;
}
return result;
} else {
ComputerInfo cominfo = computerList.get(rowIndex);
switch (columnIndex) {
case 0:
result = cominfo.getCOMPUTERID();
break;
case 1:
result = cominfo.getSTATUSS();
break;
case 2:
result = cominfo.getPOSITION();
break;
case 3:
result = cominfo.getNOTES();
break;
}
return result;
}
}
};
private AbstractTableModel tm1 = new AbstractTableModel() {
// 返回表格中每列的列名
public String getColumnName(int column) {
return recordColumnName[column];
}
// 返回每列的数据类型
public java.lang.Class<?> getColumnClass(int columnIndex) {
if (columnIndex == 0) {
return Integer.class;
}
return String.class;
}
// 返回单元格是否允许编辑
public boolean isCellEditable(int rowIndex, int columnIndex) {
return false;
}
// 返回表格中数据的行数
public int getRowCount() {
if (recordList != null) {
return recordList.size();
}
return 0;
}
// 返回列数
public int getColumnCount() {
return recordColumnName.length;
}
// 返回每个单元格中的数据
public Object getValueAt(int rowIndex, int columnIndex) {
Object result = null;
RecordInfo info = recordList.get(rowIndex);
switch (columnIndex) {
case 0:
result = info.getLIU();
break;
case 1:
result = info.getCOMPUTERID();
break;
case 2:
result = info.getCARDID();
break;
case 3:
result = info.getBEGINTIME();
break;
}
return result;
}
};
public MainPanel() {
super.setPreferredSize(new Dimension(800, 600));
super.setBackground(Color.PINK);
// 设置布局管理器
this.setLayout(new GridBagLayout());
// 电脑号
JLabel lbl = new JLabel("电脑号:");
GridBagConstraints gbc = Utils.getGBC(0, 0, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.EAST);
this.add(lbl, gbc);
tfstuComputer = new JTextField(14);
gbc = Utils.getGBC(1, 0, 1, 1, 1, 0, GridBagConstraints.HORIZONTAL, GridBagConstraints.CENTER);
this.add(tfstuComputer, gbc);
// 卡号
lbl = new JLabel("卡号:");
gbc = Utils.getGBC(2, 0, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.EAST);
this.add(lbl, gbc);
tfstuNumber = new JTextField(14);
gbc = Utils.getGBC(3, 0, 1, 1, 1, 0, GridBagConstraints.HORIZONTAL, GridBagConstraints.CENTER);
this.add(tfstuNumber, gbc);
// 按钮
btnCard = new JButton("卡号信息");
btnCard.addActionListener(this);
gbc = Utils.getGBC(5, 0, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.CENTER);
this.add(btnCard, gbc);
btnComputer = new JButton("电脑信息");
btnComputer.addActionListener(this);
gbc = Utils.getGBC(4, 0, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.CENTER);
this.add(btnComputer, gbc);
// 查询结果
table = new JTable(tm);
table.getSelectionModel().setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
table.setFillsViewportHeight(true);
JScrollPane sp = new JScrollPane(table);
gbc = Utils.getGBC(0, 1, 6, 1, 1, 1, GridBagConstraints.BOTH, GridBagConstraints.CENTER);
this.add(sp, gbc);
table1 = new JTable(tm1);
table1.getSelectionModel().setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
table1.setFillsViewportHeight(true);
JScrollPane sp1 = new JScrollPane(table1);
gbc = Utils.getGBC(0, 2, 6, 1, 1, 1, GridBagConstraints.BOTH, GridBagConstraints.CENTER);
this.add(sp1, gbc);
// 第三行
bntrecord = new JButton("上机信息");
bntrecord.addActionListener(this);
gbc = Utils.getGBC(0, 3, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.EAST);
this.add(bntrecord, gbc);
/*
bntxia = new JButton("下机");
bntxia.addActionListener(this);
gbc = Utils.getGBC(3, 3, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.CENTER);
this.add(bntxia, gbc);
*/
bntend = new JButton("删除");
bntend.addActionListener(this);
gbc = Utils.getGBC(4, 3, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.CENTER);
this.add(bntend, gbc);
bntbianji = new JButton("编辑");
bntbianji.addActionListener(this);
gbc = Utils.getGBC(5, 3, 1, 1, 0, 0, GridBagConstraints.NONE, GridBagConstraints.CENTER);
this.add(bntbianji, gbc);
}
@Override
public void actionPerformed(ActionEvent e) {
if (e.getSource() == this.btnCard) {
String CARDID = this.tfstuNumber.getText().trim();
cardList = new CardDao().searchByName(CARDID);
showCardList = true;
// 触发事件
tm.fireTableDataChanged();
tm.fireTableStructureChanged();
} else if (e.getSource() == this.btn
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
海克斯网吧管理系统.rar (66个子文件)
sss.sql 4KB
2019-12-11-1637-36.mp4 22.94MB
数据库海克斯网吧管理系统最终稿.docx 326KB
sql
.project 379B
bin
sql
Info
ComputerInfo.class 1KB
RecordInfo.class 2KB
CardInfo.class 1KB
AdminInfo.class 933B
MajorInfo.class 1KB
dao
RecordDao.class 3KB
AdminDao.class 2KB
CardDao.class 5KB
ComputerDao.class 4KB
MajorDao.class 3KB
view
RecordMangementFrame$RecordADDPanel.class 3KB
EndFrame.class 2KB
RecordMangementFrame$1.class 862B
LoginFrame.class 628B
CardMangementFrame$CardADDPanel.class 4KB
EndFrame$1.class 1KB
ComputerMangementFrame.class 2KB
MainPanel$2.class 2KB
MainPanel$1.class 2KB
EndPanel.class 606B
MainFrame$1.class 2KB
CardMangementFrame$1.class 848B
MainPanel.class 7KB
LoginPanel.class 3KB
MainFrame.class 2KB
BeginFrame.class 579B
ComputerMangementFrame$ComputerADDPanel.class 4KB
CardMangementFrame.class 2KB
RecordMangementFrame.class 1KB
ComputerMangementFrame$1.class 876B
LoginPanel$MyActionListener.class 3KB
sql.class 483B
DBUtlis.class 1KB
Utils.class 906B
.settings
org.eclipse.jdt.core.prefs 714B
org.eclipse.ltk.core.refactoring.prefs 106B
src
sql
DBUtlis.java 876B
Info
CardInfo.java 803B
MajorInfo.java 520B
ComputerInfo.java 675B
AdminInfo.java 497B
RecordInfo.java 1KB
sql.java 199B
dao
MajorDao.java 2KB
CardDao.java 4KB
RecordDao.java 2KB
ComputerDao.java 3KB
AdminDao.java 2KB
view
EndFrame.java 2KB
MainFrame.java 3KB
ComputerMangementFrame.java 5KB
CardMangementFrame.java 6KB
EndPanel.java 407B
LoginPanel.java 5KB
RecordMangementFrame.java 4KB
MainPanel.java 11KB
BeginFrame.java 327B
LoginFrame.java 492B
Utils.java 503B
.classpath 474B
lib
mysql-connector-java-5.1.26-bin.jar 836KB
基于MySQL+JavaSE的网吧管理系统.pptx 1.1MB
共 66 条
- 1
资源评论
- Shiichiro2022-07-16资源质量不错,和资源描述一致,内容详细,对我很有用。
- weixin_523842822021-12-22用户下载后在一定时间内未进行评价,系统默认好评。
- 双艺齐全2023-06-12总算找到了自己想要的资源,对自己的启发很大,感谢分享~
- as133212021-12-26用户下载后在一定时间内未进行评价,系统默认好评。
凌逸丶
- 粉丝: 4
- 资源: 4
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功