📄 mainframe.java
字号:
.addComponent(jButton1)
.addGap(67, 67, 67))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 548, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(14, 14, 14)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(19, 19, 19)
.addComponent(jLabel2)
.addGap(14, 14, 14)
.addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(16, 16, 16)
.addComponent(jLabel3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(20, 20, 20)
.addComponent(jLabel5)
.addGap(17, 17, 17)
.addComponent(jScrollPane6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(19, 19, 19)
.addComponent(jLabel7)
.addGap(20, 20, 20)
.addComponent(jScrollPane7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(21, 21, 21)
.addComponent(jLabel6)
.addGap(18, 18, 18)
.addComponent(jScrollPane8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButtonSearch)
.addComponent(jButtonAdd)
.addComponent(jButtonDel)
.addComponent(jButtonModify)
.addComponent(jButton1))
.addContainerGap())
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
jEditorName.setText(""); jEditorAuthor.setText("");
jEditorDate.setText(""); jEditorDateLower.setText("");
jEditorDateUpper.setText(""); jEditorPress.setText("");
jEditorISBN.setText("");
}//GEN-LAST:event_jButton1ActionPerformed
private void jButtonDelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonDelActionPerformed
// TODO 将在此处添加您的处理代码：
flag = true;
String ISBN = jEditorISBN.getText();
String str = "delete from book where ISBN = '" + ISBN + "'";
try {
con = DriverManager.getConnection("jdbc:odbc:book", "", "");
sql = con.createStatement();
sql.executeUpdate(str);
con.close();
}catch(SQLException e) {
flag = false;
JOptionPane.showMessageDialog(null, str);
}
flag = false;
showAll();
}//GEN-LAST:event_jButtonDelActionPerformed
private void jButtonModifyActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonModifyActionPerformed
// TODO 将在此处添加您的处理代码：
flag = true;
String name, author, press, date, ISBN;
name = jEditorName.getText(); author = jEditorAuthor.getText();
press = jEditorPress.getText(); ISBN = jEditorISBN.getText();
date = jEditorDate.getText();
if(name.isEmpty() || author.isEmpty() || press.isEmpty() ||
ISBN.isEmpty() || date.isEmpty()) {
JOptionPane.showMessageDialog(null, "请将信息填写完整!");
return;
}
String str = "update book set name = '" + name + "', ";
str = str + "author = '" + author + "',";
str = str + "press = '" + press + "'";
//str = str + "date = #" + date + "# ";
str = str + "where ISBN = '" + ISBN + "'";
try {
con = DriverManager.getConnection("jdbc:odbc:book", "", "");
sql = con.createStatement();
sql.executeUpdate(str);
con.close();
}catch(SQLException e) {
flag = false;
JOptionPane.showMessageDialog(null, str);
}
showAll();
flag = false;
}//GEN-LAST:event_jButtonModifyActionPerformed
private void jButtonAddActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonAddActionPerformed
// TODO 将在此处添加您的处理代码：
flag = true;
String name, author, press, date, ISBN;
name = jEditorName.getText(); author = jEditorAuthor.getText();
press = jEditorPress.getText(); ISBN = jEditorISBN.getText();
date = jEditorDate.getText();
if(name.isEmpty() || author.isEmpty() || press.isEmpty() ||
ISBN.isEmpty() || date.isEmpty()) {
JOptionPane.showMessageDialog(null, "请将信息填写完整!");
return;
}
String str = "insert into book values('" + name + "','" + author + "','"
+ press + "','" + date + "','" + ISBN + "')";
try {
con = DriverManager.getConnection("jdbc:odbc:book", "", "");
sql = con.createStatement();
sql.executeUpdate(str);
con.close();
}catch(SQLException e) {
flag = false;
JOptionPane.showMessageDialog(null, str);
}
showAll();
flag = false;
}//GEN-LAST:event_jButtonAddActionPerformed
private void jButtonSearchActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonSearchActionPerformed
// TODO 将在此处添加您的处理代码：
flag = true;
String name = "'%", author = "'%", press = "'%", dateLower = "#", dateUpper = "#", ISBN = "'%";
name += jEditorName.getText(); author += jEditorAuthor.getText();
press += jEditorPress.getText(); dateLower += jEditorDateLower.getText();
dateUpper += jEditorDateUpper.getText(); ISBN += jEditorISBN.getText();
name.replaceAll(" ", "%"); name.replaceAll(" ", "%"); name.replaceAll(" ", "%");
author.replaceAll(" ", "%"); author.replaceAll(" ", "%"); author.replaceAll(" ", "%");
press.replaceAll(" ", "%"); press.replaceAll(" ", "%"); press.replaceAll(" ", "%");
ISBN.replaceAll(" ", "%"); ISBN.replaceAll(" ", "%"); ISBN.replaceAll(" ", "%");
dateLower += "#"; dateUpper += "#";
name += "%'"; author += "%'"; press += "%'"; ISBN += "%'";
if(dateLower.equals("##"))
dateLower = "#1/1/1970#";
if(dateUpper.equals("##"))
dateUpper = "#12/31/2010#";
String str = "select * from book where name like " + name;
str = str + " and author like " + author;
str = str + " and press like " + press;
str = str + " and ISBN like " + ISBN;
str = str + " and date >= " + dateLower;
str = str + " and date <= " + dateUpper;
try {
con = DriverManager.getConnection("jdbc:odbc:book", "", "");
sql = con.createStatement();
rs = sql.executeQuery(str);
//JOptionPane.showMessageDialog(null, str);
while(jTableBook.getRowCount() > 0)
tableModel.removeRow(0);
while(rs.next()) {
Vector row = new Vector();
name = rs.getString(1); row.add(name);
author = rs.getString(2); row.add(author);
press = rs.getString(3); row.add(press);
Date date = rs.getDate(4); row.add(date);
ISBN = rs.getString(5); row.add(ISBN);
tableModel.addRow(row);
}
con.close();
}catch(SQLException e) {
flag = false;
JOptionPane.showMessageDialog(null, str);
}
flag = false;
}//GEN-LAST:event_jButtonSearchActionPerformed
/**
* @param args the command line arguments
*/
// 变量声明 - 不进行修改//GEN-BEGIN:variables
private javax.swing.JButton jButton1;
private javax.swing.JButton jButtonAdd;
private javax.swing.JButton jButtonDel;
private javax.swing.JButton jButtonModify;
private javax.swing.JButton jButtonSearch;
private javax.swing.JEditorPane jEditorAuthor;
private javax.swing.JEditorPane jEditorDate;
private javax.swing.JEditorPane jEditorDateLower;
private javax.swing.JEditorPane jEditorDateUpper;
private javax.swing.JEditorPane jEditorISBN;
private javax.swing.JEditorPane jEditorName;
private javax.swing.JEditorPane jEditorPress;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JScrollPane jScrollPane4;
private javax.swing.JScrollPane jScrollPane5;
private javax.swing.JScrollPane jScrollPane6;
private javax.swing.JScrollPane jScrollPane7;
private javax.swing.JScrollPane jScrollPane8;
private javax.swing.JTable jTableBook;
// 变量声明结束//GEN-END:variables
public DefaultTableModel tableModel = new DefaultTableModel(
new Object [0][5],
new String [] {"书名", "作者", "出版社", "出版日期", "ISBN"}) {
public boolean isCellEditable(int row, int column) {
return false;
}
};
private Connection con;
private Statement sql;
private ResultSet rs;
boolean flag = false;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -