lianxiwomen.java

教材管理系统

package bookmanager;

import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.*;
import java.sql.*; //引入包java.sql.*;
import javax.swing.table.*; //引入包sqljavax.swing.table.*;
import java.util.*; //引入包sqljava.util*;
import java.awt.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class lianxiwomen
    extends JFrame {
  //定义结果集
  ResultSet rs;
  //定义数据库操作对象
  private DBManager db = new DBManager();



  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JTextField jTextFieldusername = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField jTextFielddepartment = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextFieldprofessional = new JTextField();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JTextField jTextFieldlydate = new JTextField();
  JButton jButtonAdd = new JButton();
  JTextArea jTextArealynr = new JTextArea();

  public lianxiwomen() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public static void main(String[] args) {
 lianxiwomen lianxiwomen = new lianxiwomen();
  }

  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("用户名");
    xYLayout1.setWidth(588);
    xYLayout1.setHeight(462);
    this.getContentPane().setLayout(xYLayout1);
    jTextFieldusername.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldusername.setText("");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("所属院系");
    jTextFielddepartment.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFielddepartment.setText("");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("所在专业");
    jTextFieldprofessional.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldprofessional.setText("");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("留言内容");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("留言时间");
    jTextFieldlydate.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldlydate.setText("");
    jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonAdd.setText("留言");
    jTextArealynr.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextArealynr.setText("");
    this.getContentPane().add(jLabel1, new XYConstraints(60, 34, 55, 31));
    this.getContentPane().add(jLabel3, new XYConstraints(320, 36, 76, 27));
    this.getContentPane().add(jTextFieldprofessional, new XYConstraints(394, 32, 147, 27));
    this.getContentPane().add(jLabel5, new XYConstraints(313, 81, 73, 36));
    this.getContentPane().add(jTextFieldlydate,    new XYConstraints(395, 86, 143, 30));
    this.getContentPane().add(jTextFieldusername, new XYConstraints(144, 28, 153, 28));
    this.getContentPane().add(jLabel2, new XYConstraints(57, 85, 77, 27));
    this.getContentPane().add(jTextFielddepartment,  new XYConstraints(146, 80, 146, 30));
    this.getContentPane().add(jLabel4, new XYConstraints(55, 122, 82, 31));
    this.getContentPane().add(jButtonAdd,  new XYConstraints(470, 381, 85, 36));
    this.getContentPane().add(jTextArealynr,   new XYConstraints(61, 164, 485, 201));
    jButtonAdd.addMouseListener(new lianxiwomen_jButtonAdd_mouseAdapter(this));

  }

void jButtonAdd_mouseClicked(MouseEvent e) {
  String strSQL;
  //添加一条新记录

    //校验ISBN号是否为空
    if(jTextFieldusername.getText().trim().equals("")){
         JOptionPane.showMessageDialog(null, "用户名不许为空！");
         return;

       }
   //校验书名是否为空
    if (jTextFielddepartment.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "所属院系不许为空！");
      return;
    }
    //校验作者是否为空
    if (jTextFieldprofessional.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "所在专业不许为空！");
      return;
    }
    //校验版本号是否为空
    if(jTextFieldlydate.getText().trim().equals("")){
         JOptionPane.showMessageDialog(null, "留言日期不许为空！");
         return;

       }


    //校验出版社是否为空
    if (jTextArealynr.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "留言内容不许为空！");
      return;
    }





     //生成sql操作语句

      strSQL = "insert into ly(username,department,professional,lydate,lynr) values ('";
       strSQL = strSQL + jTextFieldusername.getText().trim() + "','";
       strSQL = strSQL + jTextFielddepartment.getText().trim() + "','";
       strSQL = strSQL + jTextFieldprofessional.getText().trim() + "','";
       strSQL = strSQL + jTextFieldlydate.getText().trim() + "','";
       strSQL = strSQL + jTextArealynr.getText().trim() +"','";


     //由数据库操作对象执行数据库操作，并返回操作成功失败的提示信息
     if (db.executeSql(strSQL)) {
       JOptionPane.showMessageDialog(null, "成功添加！");
     }
     else {
       JOptionPane.showMessageDialog(null, " 添加失败，请重新操作！");
     }
   }
  }
class lianxiwomen_jButtonAdd_mouseAdapter
  extends java.awt.event.MouseAdapter {
lianxiwomen adaptee;

lianxiwomen_jButtonAdd_mouseAdapter(lianxiwomen adaptee) {
  this.adaptee = adaptee;
}

public void mouseClicked(MouseEvent e) {
  adaptee.jButtonAdd_mouseClicked(e);
}
}