📄 frmbook.java
字号:
*/
public void tblData_mousePressed(MouseEvent e) {
String str=String.valueOf(tblData.getValueAt(tblData.getSelectedRow(),0));
pnlBookManage_Delete.txtNumber.setText(str);
pnlBookManage_ModifyToSearch.txtNumber.setText(str);
pnlLendNumber_Delete.txtLendNumber.setText(str);
pnlLendNumber_Modify.txtLendNumber.setText(str);
/*
SearchContent=new ArrayList();
for(int i=0;i<tblData.getColumnCount();i++)
{
String str1=String.valueOf(tblData.getValueAt(tblData.getSelectedRow(),i));
SearchContent.add(str1);
}*/
}
/**
* 图书报损菜单
* @param e ActionEvent
*/
public void mnuDelete_actionPerformed(ActionEvent e) {
page=0;
pnlBookManage_Delete pmd=new pnlBookManage_Delete(this);
spnV.setTopComponent(pmd);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书管理","图书报损");
}
/**
* 图书修改菜单
* @param e ActionEvent
*/
public void mnuModify_actionPerformed(ActionEvent e) {
page=0;
pnlBookManage_ModifyToSearch bms=new pnlBookManage_ModifyToSearch(this);
spnV.setTopComponent(bms);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书管理","图书修改");
}
/**
* 开证菜单
*/
public void mnuLendNumberAdd_actionPerformed(ActionEvent e) {
page=0;
pnlLendNumber_Add lna=new pnlLendNumber_Add(this);
spnV.setTopComponent(lna);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData,clsLendNumber_condb.rsLN);
String tab="lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLendNumberInfo(),tab);
this.StateContent("借书证管理","开证");
}
/**
* 销证菜单
* @param e ActionEvent
*/
public void mnuLendNumberDelete_actionPerformed(ActionEvent e) {
page=0;
pnlLendNumber_Delete lnd=new pnlLendNumber_Delete(this);
spnV.setTopComponent(lnd);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData,clsLendNumber_condb.rsLN);
String tab="lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLendNumberInfo(),tab);
this.StateContent("借书证管理","销证");
}
/**
* 借书证修改菜单
* @param e ActionEvent
*/
public void mnuLendNumberModify_actionPerformed(ActionEvent e) {
page=0;
pnlLendNumber_Modify lnm=new pnlLendNumber_Modify(this);
spnV.setTopComponent(lnm);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData,clsLendNumber_condb.rsLN);
String tab="lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLN,tab);
this.StateContent("借书证管理","借书证修改");
}
/**
* 借书证查找菜单
* @param e ActionEvent
*/
public void mnuLendNumberSearch_actionPerformed(ActionEvent e) {
page=0;
pnlLendNumber_Search lns=new pnlLendNumber_Search(this);
spnV.setTopComponent(lns);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData,clsLendNumber_condb.rsLN);
String tab="lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLN,tab);
this.StateContent("借书证管理","借书证查找");
}
/**
* 借书菜单
* @param e ActionEvent
*/
public void mnuLendBook_actionPerformed(ActionEvent e) {
page=0;
pnlLendBook_Lend lbl=new pnlLendBook_Lend(this);
spnV.setTopComponent(lbl);
clsLendBook_condb.initSearch();
clsLendBook_condb.initInfo(this.tblData,clsLendBook_condb.rsLbl);
String tab="lendbook";
this.DataPane(clsLendBook_condb.rsLend(),tab);
this.StateContent("借阅管理","借书");
}
/**
* 还书菜单
* @param e ActionEvent
*/
public void mnuReturnBook_actionPerformed(ActionEvent e) {
page=0;
pnlLendBook_Return lbr=new pnlLendBook_Return(this);
spnV.setTopComponent(lbr);
clsLendBook_condb.initSearch_return();
clsLendBook_condb.initInfo(this.tblData,clsLendBook_condb.rsLbr);
String tab="returnbook";
this.DataPane(clsLendBook_condb.rsReturn(),tab);
this.StateContent("借阅管理","还书");
}
/**
* 组合查询菜单
* @param e ActionEvent
*/
public void mnuSGroup_actionPerformed(ActionEvent e) {
page=0;
pnlSearch_Group sg=new pnlSearch_Group(this);
spnV.setTopComponent(sg);
JPanel p=new JPanel();
spnV.setBottomComponent(p);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书查询","组合查询");
}
/**
* 精确查询菜单
* @param e ActionEvent
*/
public void mnuSJName_actionPerformed(ActionEvent e) {
page=0;
pnlSearch_JName sjn=new pnlSearch_JName(this);
spnV.setTopComponent(sjn);
JPanel p=new JPanel();
spnV.setBottomComponent(p);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书查询","精确查询");
}
/**
* 模糊查询菜单
* @param e ActionEvent
*/
public void mnuSMName_actionPerformed(ActionEvent e) {
page=0;
pnlSearch_MName smn=new pnlSearch_MName(this);
spnV.setTopComponent(smn);
JPanel p=new JPanel();
spnV.setBottomComponent(p);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书查询","模糊查询");
}
/**
* 按作者查询菜单
* @param e ActionEvent
*/
public void mnuSAuthor_actionPerformed(ActionEvent e) {
page=0;
pnlSearch_Author sa=new pnlSearch_Author(this);
spnV.setTopComponent(sa);
JPanel p=new JPanel();
spnV.setBottomComponent(p);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书查询","按作者查询");
}
/**
* 按出版社查询菜单
* @param e ActionEvent
*/
public void mnuSPublish_actionPerformed(ActionEvent e) {
page=0;
pnlSearch_Publish sp=new pnlSearch_Publish(this);
spnV.setTopComponent(sp);
JPanel p=new JPanel();
spnV.setBottomComponent(p);
baconne.initSearch();
baconne.initInfo(tblData,baconne.rs);
ResultSet rsto=bookadd_condb.rsBook();
String tab="bookinfo";
this.DataPane(rsto,tab);
this.StateContent("图书查询","按出版社查询");
}
/**
* 关于菜单
* @param e ActionEvent
*/
public void mnuAbout_actionPerformed(ActionEvent e) {
About.getAbout();
this.StateContent("关于","关于");
}
/**
* 帮助菜单
* @param e ActionEvent
*/
public void mnuHelpDoc_actionPerformed(ActionEvent e) {
this.StateContent("关于","帮助");
}
/**
* 登陆菜单
* @param e ActionEvent
*/
public void mnuLogin_actionPerformed(ActionEvent e) {
Frmtrans ft=new Frmtrans();
ft.setVisible(true);
this.StateContent("用户管理","登陆");
}
/**
* 添加用户菜单
* @param e ActionEvent
*/
public void mnuUAdd_actionPerformed(ActionEvent e) {
FrmUser_Add ua=new FrmUser_Add();
ua.setLocation(100,100);
ua.setSize(450,300);
ua.setVisible(true);
this.StateContent("用户管理","添加用户");
}
/**
* 删除用户菜单
* @param e ActionEvent
*/
public void mnuUDelete_actionPerformed(ActionEvent e) {
FrmUser_Delete ud=new FrmUser_Delete();
ud.setLocation(100,100);
ud.setSize(400,300);
ud.setVisible(true);
this.StateContent("用户管理","删除用户");
}
/**
* 退出系统菜单
* @param e ActionEvent
*/
public void mnuExit_actionPerformed(ActionEvent e) {
this.dispose();
}
/**
* 树的值改变事件
* @param e TreeSelectionEvent
*/
public void treeBook_valueChanged(TreeSelectionEvent e) {
try
{
String name="";
DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeBook.
getLastSelectedPathComponent();
if (node.isLeaf()) {
name = node.toString();
}
if(name.equals("图书入库"))
{
page = 0;
pnlBookManage_add pbm = new pnlBookManage_add(this);
spnV.setTopComponent(pbm);
baconne.initSearch();
baconne.initInfo(tblData, baconne.rs);
ResultSet rsto = bookadd_condb.rsBook();
String tab = "bookinfo";
this.DataPane(rsto, tab);
this.StateContent("图书管理", "图书入库");
}
else if(name.equals("图书报损"))
{
page = 0;
pnlBookManage_Delete pmd = new pnlBookManage_Delete(this);
spnV.setTopComponent(pmd);
baconne.initSearch();
baconne.initInfo(tblData, baconne.rs);
ResultSet rsto = bookadd_condb.rsBook();
String tab = "bookinfo";
this.DataPane(rsto, tab);
this.StateContent("图书管理", "图书报损");
}
else if(name.equals("图书修改"))
{
page = 0;
pnlBookManage_ModifyToSearch bms = new
pnlBookManage_ModifyToSearch(this);
spnV.setTopComponent(bms);
baconne.initSearch();
baconne.initInfo(tblData, baconne.rs);
ResultSet rsto = bookadd_condb.rsBook();
String tab = "bookinfo";
this.DataPane(rsto, tab);
this.StateContent("图书管理", "图书修改");
}
else if(name.equals("借书"))
{
page=0;
pnlLendBook_Lend lbl = new pnlLendBook_Lend(this);
spnV.setTopComponent(lbl);
clsLendBook_condb.initSearch();
clsLendBook_condb.initInfo(this.tblData, clsLendBook_condb.rsLbl);
String tab="lendbook";
this.DataPane(clsLendBook_condb.rsLend(),tab);
this.StateContent("借阅管理","借书");
}
else if(name.equals("还书"))
{
page=0;
pnlLendBook_Return lbr = new pnlLendBook_Return(this);
spnV.setTopComponent(lbr);
clsLendBook_condb.initSearch_return();
clsLendBook_condb.initInfo(this.tblData, clsLendBook_condb.rsLbr);
String tab="returnbook";
this.DataPane(clsLendBook_condb.rsReturn(),tab);
this.StateContent("借阅管理","还书");
}
else if(name.equals("开证"))
{
page = 0;
pnlLendNumber_Add lna = new pnlLendNumber_Add(this);
spnV.setTopComponent(lna);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData, clsLendNumber_condb.rsLN);
String tab = "lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLN, tab);
this.StateContent("借书证管理", "开证");
}
else if(name.equals("销证"))
{
page = 0;
pnlLendNumber_Delete lnd = new pnlLendNumber_Delete(this);
spnV.setTopComponent(lnd);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData, clsLendNumber_condb.rsLN);
String tab = "lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLN, tab);
this.StateContent("借书证管理", "销证");
}
else if(name.equals("证号修改"))
{
page = 0;
pnlLendNumber_Modify lnm = new pnlLendNumber_Modify(this);
spnV.setTopComponent(lnm);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData, clsLendNumber_condb.rsLN);
String tab = "lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLN, tab);
this.StateContent("借书证管理", "借书证修改");
}
else if(name.equals("证号查找"))
{
page = 0;
pnlLendNumber_Search lns = new pnlLendNumber_Search(this);
spnV.setTopComponent(lns);
clsLendNumber_condb.initSearch();
clsLendNumber_condb.initInfo(tblData, clsLendNumber_condb.rsLN);
String tab = "lendnumberinfo";
this.DataPane(clsLendNumber_condb.rsLN, tab);
this.StateContent("借书证管理", "借书证查找");
}
else if(name.equals("登陆"))
{
Frmtrans ft = new Frmtrans();
ft.setVisible(true);
}
else if(name.equals("添加用户"))
{
FrmUser_Add ua = new FrmUser_Add();
ua.setLocation(100, 100);
ua.setSize(450, 300);
ua.setVisible(true);
}
else if(name.equals("删除用户"))
{
FrmUser_Delete ud = new FrmUser_Delete();
ud.setLocation(100, 100);
ud.setSize(400, 300);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -