addtitleframe.java

图书管理系统的设计与实现

package newLibrary;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.lang.*;
import java.sql.*;



public class AddTitleFrame extends JFrame
{
	/**************声明变量************/
	private JPanel ContentPane;
	private JLabel jlab1 = new JLabel();
	private JLabel jlab2 = new JLabel();
	private JLabel jlab3 = new JLabel();
	private JLabel jlab4 = new JLabel();
	private JLabel jlab5 = new JLabel();
	private JLabel jlab6= new JLabel();
	private JLabel jlab7 = new JLabel();
	private JLabel jlab8 = new JLabel();
	private JLabel jlab9 = new JLabel();

	private JTextField jtextfield1 = new JTextField();
	private JTextField jtextfield2 = new JTextField();
	private JTextField jtextfield3 = new JTextField();
	private JTextField jtextfield4 = new JTextField();
	private JTextField jtextfield5 = new JTextField();

	private JComboBox jcombobox1 = new JComboBox();
	private JComboBox jcombobox2 = new JComboBox();
	private JComboBox jcombobox3 = new JComboBox();

	private JTextArea jtextarea = new JTextArea();
	private JButton sure = new JButton();

	public  AddTitleFrame()
	{
		this.setBounds(320,160,400,350);
		this.setTitle("添加图书信息");//窗体标题
	    ContentPane =(JPanel)this.getContentPane();//将容器转化为JPanel
	    ContentPane.setLayout(null);//设置可更改性
	    ContentPane.setBackground(Color.LIGHT_GRAY);

		/***************设置标签的属性*****************/
		jlab1.setText("书号");
		jlab1.setBounds(new Rectangle(30, 11, 51, 33));
		jlab1.setForeground(Color.black);
		jlab2.setText("书名");
		jlab2.setBounds(new Rectangle(162, 11, 28, 33));
		jlab2.setForeground(Color.black);
		jlab3.setText("借出");
		jlab3.setBounds(new Rectangle(241, 11, 28, 33));
		jlab3.setForeground(Color.black);
		jlab4.setText("出版日期");
		jlab4.setBounds(new Rectangle(31, 53, 55, 33));
		jlab4.setForeground(Color.black);
		jlab5.setText("图书分类");
		jlab5.setBounds(new Rectangle(241, 53, 55, 33));
		jlab5.setForeground(Color.black);
		jlab6.setText("作者");
		jlab6.setBounds(new Rectangle(163, 53, 26, 33));
		jlab6.setForeground(Color.black);
		jlab7.setText("系别");
		jlab7.setBounds(new Rectangle(30, 94, 50, 33));
		jlab7.setForeground(Color.black);
		jlab8.setText("出版社");
		jlab8.setBounds(new Rectangle(163, 94, 66, 33));
		jlab8.setForeground(Color.black);
		jlab9.setText("备  注");
		jlab9.setBounds(new Rectangle(27, 132, 50, 33));
		jlab9.setForeground(Color.black);

		/****************设置文本框的属性*****************/
		jtextfield1.setText("");//书号
		jtextfield1.setBounds(new Rectangle(86, 16, 74, 22));
		jtextfield2.setText("");//书名
		jtextfield2.setBounds(new Rectangle(192, 16, 44, 22));
		jtextfield3.setText("YY-MM-DD");//出版日期
		jtextfield3.setBounds(new Rectangle(86, 58, 74, 22));
		jtextfield4.setText("");//作者
		jtextfield4.setBounds(new Rectangle(191, 58, 44, 22));
		jtextfield5.setText("");//出版社
		jtextfield5.setBounds(new Rectangle(210, 99, 158, 22));

		/********************添加下拉菜单的选象**********************/
		jcombobox1.setBounds(new Rectangle(275, 15, 50, 25));
		jcombobox1.addItem("否");
		jcombobox1.addItem("是");
		jcombobox1.setForeground(Color.LIGHT_GRAY);
		jcombobox1.setBackground(Color.white);

		/***************添加下拉菜单的选象***************/
		jcombobox2.setBounds(new Rectangle(296, 57, 72, 25));
		jcombobox2.addItem("科技");
		jcombobox2.addItem("文学");
		jcombobox2.addItem("其他");
		jcombobox2.setForeground(Color.LIGHT_GRAY);
		jcombobox2.setBackground(Color.white);


		jcombobox3.setBounds(new Rectangle(86, 98, 75, 25));
		/************添加下拉菜单的选象******************/
		jcombobox3.addItem("计算机");
		jcombobox3.addItem("经济系");
		jcombobox3.addItem("机械系");
		jcombobox3.addItem("管理系");
		jcombobox3.addItem("信息系");
		jcombobox3.addItem("外语系");
		jcombobox3.setForeground(Color.LIGHT_GRAY);
		jcombobox3.setBackground(Color.white);


		jtextarea.setText("");
		jtextarea.setBounds(new Rectangle(84, 139, 285, 92));

		sure.setText("增加");//设置命令按钮
		sure.setBounds(new Rectangle(156, 244, 89, 22));
		sure.addActionListener(new sure_actionperformed());//设置动作监听

		/**************把各个控件加到面板中去************/
		ContentPane.add(jlab1);
		ContentPane.add(jlab2);
		ContentPane.add(jlab3);
		ContentPane.add(jlab4);
		ContentPane.add(jlab5);
		ContentPane.add(jlab6);
		ContentPane.add(jlab7);
		ContentPane.add(jlab8);
		ContentPane.add(jlab9);

		/**************将文本框加到面板中去***********/
		ContentPane.add(jtextfield1);
		ContentPane.add(jtextfield2);
		ContentPane.add(jtextfield3);
		ContentPane.add(jtextfield4);
		ContentPane.add(jtextfield5);

		/************将下拉框添加到面板中***********/
		ContentPane.add(jcombobox1);
		ContentPane.add(jcombobox2);
		ContentPane.add(jcombobox3);

		/**************将文本区域和命令按钮添加************/
		ContentPane.add(jtextarea);
		ContentPane.add(sure);

		this.setVisible(true);//设置可见性
	}
	class sure_actionperformed implements ActionListener //设置动作按钮的监听
	{
		public void actionPerformed(ActionEvent e) //创建方法
		{
			try
			{
				/****************连接数据库(JDBC)******************/
				String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=student.mdb";
      			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      			Connection conn = DriverManager.getConnection(strurl);
      			Statement stmt = conn.createStatement();
      			/***********建立记录集并查询输入的书号和表中存在的记录是不是一样**************/
      			ResultSet rs = stmt.executeQuery("select * from StuInfo where 书号='"+ jtextfield1.getText() +"' ");

      			/*判断指针并向下移动*/
      			if(rs.next())
      			{
      				//报告错误
      				JOptionPane.showMessageDialog(null, "此书号已经存在.", "警告",
                                      JOptionPane.WARNING_MESSAGE);
        			return;
      			}
      			/***********将注册信息写到数据库中去************/
      			stmt.executeUpdate("insert into StuInfo(书号,系别,出版社,书名,借出,出版日期,作者,图书分类,备注) values ('"+jtextfield1.getText()+"','"+jcombobox3.getSelectedItem()+"','"+jtextfield5.getText()+"','"+jtextfield2.getText()+"','"+jcombobox1.getSelectedItem()+"','"+jtextfield3.getText()+"','"+jtextfield4.getText()+"','"+jcombobox2.getSelectedItem()+"','"+jtextarea.getText()+"')");

      			/************注册成功后并把信息清空*************/
      			jtextfield1.setText("");
      			jtextfield2.setText("");
      			jtextfield3.setText("");
      			jtextfield4.setText("");
      			jtextfield5.setText("");
      			jtextarea.setText("");
      			JOptionPane.showMessageDialog(null, "添加信息成功!");
      			TitleInfoWindow allinfo = new TitleInfoWindow();
			}
			catch (Exception ee)
			{
      			JOptionPane.showMessageDialog(null, "各项不能为空,\n日期格式要正确!然后重试.", "警告",
                                    JOptionPane.WARNING_MESSAGE);
      			ee.printStackTrace();
    		}
		}
	}

}