📄 booksinfosystempanel.java
字号:
while(rs.next())
count++;
rs.first();
data = new String[count][title.length];
for(int i=0;i<count;i++)
{
for(int j=0;j<title.length;j++)
{
data[i][j] = rs.getString(j+2).trim();
}
rs.next();
}
DefaultTableModel model = new DefaultTableModel(data,title);
jTeaRightTop.setModel(model);
jTeaRightTop.updateUI();
db.myClose(1);
}
catch(SQLException sex)
{
System.out.println(sex.toString());
// sex.printStackTrace();
}
}
public void display()
{
DefaultMutableTreeNode clickNode = (DefaultMutableTreeNode) jTreBooks.getLastSelectedPathComponent();
String sql="";
String bti="";
//数据库表没有见
if (clickNode != null ) {
//查询条件许转换
if(clickNode.toString().trim().equals("所有图书"))
{
bti="%";
}
else
{
sql = "select TypeID from BooksType where typeName='" +
clickNode.toString().trim() + "'";
db.search(sql);
try {
if (db.rs.next())
bti = db.rs.getString(1).trim();
} catch (SQLException ex) {
System.out.println(ex.toString());
}
db.myClose(1);
}
sql = "select * from booksInfo where bookTypeID like'"+bti.trim()+"'+'%'";
jlbM.setText(clickNode.toString().trim()+"类 图书信息列表");
jtxBookType1.setText(clickNode.toString().trim());
// jtxBookType2.setText(clickNode.toString().trim());
fenlei=clickNode.toString().trim();
tableDisp(sql);
}
}
public void jtxBookNum2_mouseClicked(MouseEvent e) {
inputBooksNum(jtxBookNum2);
}
public void inputBooksNum(JTextField a)
{
String bianhao="";
try {
bianhao= JOptionPane.showInputDialog(null,"请输入需要增加图书的编号 例如 ","W00020070800000001").trim();
} catch (Exception ex) {
// JOptionPane.showMessageDialog(null, "你没有输入读者信息");
}
if(!bianhao.equals("")){
if ((int)bianhao.charAt(0)>='A' && (int)bianhao.charAt(0) <= 'Z' ) {
//查询此编号的图书
if(bianhao.trim().length()!=20)
JOptionPane.showMessageDialog(null,"输入的编号有误！！\n请核对后再输入");
else
{
a.setText(bianhao);
//JOptionPane.showMessageDialog(null,bianhao.trim().subSequence(0,2));
//更新表
String sqlq="select * from booksInfo where bookTypeID like'"+bianhao.trim().subSequence(0,1)+"'+'%'";
tableDisp(sqlq);
//更新界面文本框
}
}
}
}
public void jtxBookNum1_mouseClicked(MouseEvent e) {
String name = jtxBookName1.getText().trim();
String fenlei =jtxBookType1.getText().trim();
String chubanshe = jtxBookConcern1.getText().trim();
String zuozhe = jtxBookAuthor.getText().trim();
String dingjia = jtxBookPurchaseMoney.getText().trim();
String yuzhong = jtxBookLanguage.getText().trim();
String shujiaweizhi = jtxBookStation.getText().trim();
String shuliang = jtxBookBorrowMoneyNum1.getText().trim();
int sl=0;
float dj=0;
if (name.equals(""))
JOptionPane.showMessageDialog(null, "图书名称不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (fenlei.equals("请点击左边的类型选择"))
JOptionPane.showMessageDialog(null, "图书分类没有选择，请选择左边的图书类型`", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (chubanshe.equals(""))
JOptionPane.showMessageDialog(null, "图书出版社不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (zuozhe.equals(""))
JOptionPane.showMessageDialog(null, "图书著者不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (shuliang.equals(""))
JOptionPane.showMessageDialog(null, "图书的数量不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (shujiaweizhi.equals(""))
JOptionPane.showMessageDialog(null, "图书存放的位置不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (yuzhong.equals(""))
JOptionPane.showMessageDialog(null, "图书的语言种类不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (dingjia.equals(""))
JOptionPane.showMessageDialog(null, "图书定价不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else{
// JOptionPane.showMessageDialog(null, "OK");
booksNumber(jtxBookNum1 );
btnAddInfo.setEnabled(true);
}
}
//生成书的编号
public void booksNumber(JTextField jtx)
{
String typename =jtxBookType1.getText().trim();
String sql = "select top 1 booksNum,borrowMoneyNum from booksInfo order by id desc";
String sql2 = "select typeID from BooksType where typeName='"+typename+"'";
String bianhao="";
String tynum="";
String time="";
long num=0;
ResultSet re=null;
//获得总编号
re=db.search(sql);
try {
if( re.next())
{
bianhao=re.getString(1).trim();
bianhao=bianhao.substring(bianhao.length()-8);
num=re.getInt(2);
}
} catch (SQLException ex) {
System.out.println(ex.toString());
ex.printStackTrace();
}
db.myClose(1);
if(!bianhao.equals(""))
num=num+Integer.parseInt(bianhao);
bianhao=""+num;
while(bianhao.length()<8)
bianhao="0"+bianhao;
//获得类型
re=db.search(sql2);
try {
if( re.next())
{
tynum=re.getString(1).trim();
bh=tynum;
}
} catch (SQLException ex) {
System.out.println(ex.toString());
ex.printStackTrace();
}
db.myClose(1);
while(tynum.length()<4)
tynum=tynum+"0";
time=SystemFrame1.dateTime;
jtx.setText(tynum+time+bianhao);
//JOptionPane.showMessageDialog(null,bh);
}
public void btnAddInfo_actionPerformed(ActionEvent e) {
beizhu=JOptionPane.showInputDialog(null,"请输入备注信息，\n例如","内容提要...");
}
public void btnQueRen_actionPerformed(ActionEvent e) {
String name = jtxBookName1.getText().trim();
String booksNum = "";
String fenlei =jtxBookType1.getText().trim();
String chubanshe = jtxBookConcern1.getText().trim();
String zuozhe = jtxBookAuthor.getText().trim();
String dingjia = jtxBookPurchaseMoney.getText().trim();
String yuzhong = jtxBookLanguage.getText().trim();
String shujiaweizhi = jtxBookStation.getText().trim();
String shuliang = jtxBookBorrowMoneyNum1.getText().trim();
int sl=0;
float dj=0;
if (name.equals(""))
JOptionPane.showMessageDialog(null, "图书名称不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (fenlei.equals("请点击左边的类型选择"))
JOptionPane.showMessageDialog(null, "图书分类没有选择，请选择左边的图书类型`", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (chubanshe.equals(""))
JOptionPane.showMessageDialog(null, "图书出版社不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (zuozhe.equals(""))
JOptionPane.showMessageDialog(null, "图书著者不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (shuliang.equals(""))
JOptionPane.showMessageDialog(null, "图书的数量不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (shujiaweizhi.equals(""))
JOptionPane.showMessageDialog(null, "图书存放的位置不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (yuzhong.equals(""))
JOptionPane.showMessageDialog(null, "图书的语言种类不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else if (dingjia.equals(""))
JOptionPane.showMessageDialog(null, "图书定价不能为空，请继续填写```", "信息填写错误",
JOptionPane.ERROR_MESSAGE);
else
{
try {
sl = Integer.parseInt(shuliang);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "图书的 数量 只能是数字！！！，请继续填写```",
"数量填写错误",
JOptionPane.ERROR_MESSAGE);
return;
}
try {
dj = Float.parseFloat(dingjia);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "图书的 定价 只能是数字！！！，请继续填写```",
"数量填写错误",
JOptionPane.ERROR_MESSAGE);
return;
}
booksNumber(jtxBookNum1);
booksNum = jtxBookNum1.getText().trim();
String sqlbook = "insert into booksInfo (booksName,booksNum,bookTypeId,bookAuthor, bookConcern,borrowMoneyNum,purchaseMoney,bookLanguage,booksLairage,lairagehandlers,remark) values(?,?,?,?,?,?,?,default,default,?,?)";
PreparedStatement pe=null;
ResultSet rs=null;
try {
pe = db.conn.prepareStatement(sqlbook);
pe.setString(1,name);
pe.setString(2,booksNum);
pe.setString(3,bh);
pe.setString(4,zuozhe);
pe.setString(5,chubanshe);
pe.setInt(6,sl);
pe.setFloat(7,dj);
pe.setString(8,SystemFrame1.login);
pe.setString(9,beizhu);
if(db.add(pe)){
db.myClose(1);
JOptionPane.showMessageDialog(null, "增加成功");
loginTree();
String sql1="select * from booksInfo where bookTypeID='"+bh+"'";
tableDisp(sql1);
btnAddInfo.setEnabled(false);
qingchu();
}
else
JOptionPane.showMessageDialog(null, "添加失败");
} catch (SQLException ex1) {
}
}
}
public void qingchu()
{
jtxBookName1.setText("");
jtxBookType1.setText("请点击左边的类型选择");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -