📄 bianji.java
字号:
/*
* Bianji.java
*
* Created on 2008年1月14日, 上午9:33
*/
package book;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import book.*;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.WindowAdapter;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
public class Bianji extends javax.swing.JFrame {
Database db=new Database();
Connection con;
Statement stmt;
ResultSet rs;
String book_no;
String book_name;
String writer;
String printer;
String details;
String[] column={"书号", "书名", "作者", "出版社", "详细信息"};
DefaultTableModel dm=new DefaultTableModel(column, 0){};
String sql="select * from book_jbxx";
Chaxun chaxun=new Chaxun();
public Bianji() {
initComponents();
String f=this.Xianshi(sql,jTable1,dm);
if(f=="go on"){ }
else{
JOptionPane.showMessageDialog(null,"加载数据失败"+f);
}
}
public String Xianshi(String sql,JTable table,DefaultTableModel dm){
int r=table.getRowCount();
String rturn=db.link();
String f="";
if(rturn=="y"){
try{
ResultSet rs=db.getResult(sql);
while(rs.next()) {
book_no=rs.getString(1);
book_name=rs.getString(2);
writer=rs.getString(3);
printer=rs.getString(4);
details=rs.getString(5);
Object[] row={book_no,book_name,writer,printer,details};
dm.addRow(row);
}
table.setModel(dm);
table.updateUI();
f="go on";
}catch(SQLException e){
f=e.toString();
}
finally{db.cutlink();}
}
else
{
JOptionPane.showMessageDialog(null,rturn);
}
return f;
}
public String del_book(JTable table,DefaultTableModel dm){
String f="";
try{
db.link();
int del_row=table.getSelectedRow();
String ID=table.getValueAt(del_row,0).toString().trim();
String sql="delete from book_jbxx where book_no ='"+ID+"'";
System.out.println(sql);
try{
stmt.executeUpdate(sql);
}catch(Exception e){f=e.toString();}
JOptionPane.showMessageDialog(null,"确认要删除记录吗？");
dm.removeRow(del_row);
table.updateUI();
f="y";
}catch(Exception e){f=e.toString();}
finally{
db.cutlink();
}
return f;
}
// <editor-fold defaultstate="collapsed" desc=" 初始化 ">
private void initComponents() {
jComboBox1 = new javax.swing.JComboBox();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jTextField3 = new javax.swing.JTextField();
jButton3 = new javax.swing.JButton();
jButton1 = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jComboBox2 = new javax.swing.JComboBox();
jButton2 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jButton5 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "\u4e66\u540d", "\u4e66\u53f7", "\u4f5c\u8005", "\u51fa\u7248\u793e", "\u5206\u7c7b\u53f7" }));
jLabel3.setText("\u68c0\u7d22\u7ed3\u679c\uff1a");
jLabel4.setText("\u5173\u952e\u5b57\uff1a");
jButton3.setText("\u67e5\u8be2");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton1.setText("\u9000\u51fa");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
jScrollPane1.setViewportView(jTable1);
jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "\u524d\u65b9\u4e00\u81f4", "\u4e2d\u95f4\u4e00\u81f4", "\u540e\u65b9\u4e00\u81f4", "\u5b8c\u5168\u4e00\u81f4" }));
jButton2.setText("\u63d2\u5165");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton4.setText("\u5220\u9664");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jButton5.setText("\u5237\u65b0");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 460, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel3)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(17, 17, 17)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(31, 31, 31)
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(22, 22, 22)
.addComponent(jButton3)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(94, Short.MAX_VALUE)
.addComponent(jButton5)
.addGap(16, 16, 16)
.addComponent(jButton2)
.addGap(14, 14, 14)
.addComponent(jButton4)
.addGap(20, 20, 20)
.addComponent(jButton1)
.addGap(108, 108, 108))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton3))
.addGap(18, 18, 18)
.addComponent(jLabel3)
.addGap(0, 0, 0)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 239, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton5)
.addComponent(jButton2)
.addComponent(jButton4))
.addContainerGap(26, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO 将在此处添加您的处理代码：退出
int n= JOptionPane.showConfirmDialog(jFrame,"确定退出吗？","退出...",JOptionPane.YES_NO_OPTION);
if(n == JOptionPane.YES_OPTION)
this.hide();
else if(n == JOptionPane.NO_OPTION){}
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO 将在此处添加您的处理代码：插入
Charu charu=new Charu();
charu.show();
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO 将在此处添加您的处理代码：查询
dm=new DefaultTableModel(column, 0){};
jTable1.setModel(dm);
jTable1.updateUI();
Bianjibutton();
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO 将在此处添加您的处理代码：删除
String f= del_book(jTable1,dm);
if(f=="y"){
JOptionPane.showMessageDialog(null,"删除成功");
}
else{
JOptionPane.showMessageDialog(null,"删除失败"+f);
}
}
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO 将在此处添加您的处理代码：刷新
dm.setRowCount(0);
String sql="select * from book_xxxx";
String f=this.Xianshi(sql,jTable1,dm);
if(f=="go on"){ }
else{
JOptionPane.showMessageDialog(null,"加载数据失败"+f);
}
}
void Bianjibutton(){
String limit1=jComboBox1.getSelectedItem().toString();
if(limit1=="书名") sql+=" where book_name ";
if(limit1=="书号") sql+=" where book_no ";
if(limit1=="作者") sql+=" where writer ";
if(limit1=="出版社") sql+=" where printer ";
if(limit1=="分类号") sql+=" where classifyID ";
String limit=this.jTextField3.getText().toString();
String limit2=jComboBox2.getSelectedItem().toString();
if(limit2=="前方一致") sql+="like '"+limit+"%'";
if(limit2=="中间一致") sql+="like '%"+limit+"%'";
if(limit2=="后方一致") sql+="like '%"+limit+"'";
if(limit2=="完全一致") sql+="= '"+limit+"'";
String f=this.Xianshi(sql,jTable1,dm);
if(f=="go on"){ }
else{
JOptionPane.showMessageDialog(null,"加载数据失败"+f);
}
}
// 变量声明 - 不进行修改
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField3;
JFrame jFrame;
// 变量声明结束
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -