rukuframe.java

java 编写的图书管理系统源代码 密码和用户名都是123

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class RuKuFrame extends Frame implements ActionListener
{
  		Label label1 = new Label("图书编号");
  		Label label2 = new Label("书名");
  		Label label3 = new Label("作者");
  		Label label4 = new Label("出版社");
  		Label label5 = new Label("数量");
  		Label label6 = new Label("价格");
		Label label7 =new Label();
  		TextField textField2 = new TextField();
  		TextField textField3 = new TextField();
  		TextField textField4 = new TextField();
  		TextField textField1 = new TextField();
  		TextField textField5 = new TextField();
  		TextField textField6 = new TextField();
 		Button button1 = new Button("确定");
 		Button button2 = new Button("取消");
 		
	Connection conn;
  	Statement stmt;
  	ResultSet rs;  
    	String strurl;
	
        public RuKuFrame() throws Exception
	{
		
		
        super("图书入库窗口");

		

		setSize(480,300);
		setLayout(null);
		setBackground(new Color(110,200,150)); 
		this.setLocation(200,200);
    	button2.setBounds(219, 228, 89, 25);
	button1.addActionListener(this);
    	button1.setBounds(68, 226, 83, 23);
        button2.addActionListener(this);


    	textField6.setBounds(271, 169, 76, 20);
    	textField5.setBounds(271, 126, 76, 20);
    	textField1.setBounds(105, 86, 76, 20);
    	textField4.setBounds(271, 86, 76, 20);
    	textField3.setBounds(105, 170, 76, 20);
    	textField2.setBounds(105, 126, 76, 20);
    
    
    	label1.setBounds(45, 86, 57, 19);
    	label2.setBounds(45, 126, 57, 19);
    	label3.setBounds(45, 170, 57, 19);
   	label4.setBounds(210, 86, 53, 19);
    	label5.setBounds(210, 126, 57, 19);
    	label6.setBounds(210, 170, 57, 19);
    	label7.setBounds(68,250,83,40);
    	
    
    	add(button1);
    	add(button2);
    	add(label1);
    	add(label2);
	add(label7);
   		add(label3);
    	add(textField3);
   		add(textField2);
   		add(textField1);
    	add(label4);
   		add(label5);
   		add(label6);
   		add(textField6);
   		add(textField5);
  		add(textField4);
	strurl ="jdbc:odbc:Library";

    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	conn = DriverManager.getConnection(strurl);
    	stmt = conn.createStatement();
		
		
		setVisible(true);
                addWindowListener(new WindowAdapter(){
		public void windowClosing(WindowEvent e){
				dispose();
				setVisible(false);
			}
		}); 
	}
	public void actionPerformed(ActionEvent e)
	{
		String str=e.getActionCommand();
		if (str.equals("确定"))
		{
			if(textField1.getText().equals(""))
			{
				label7.setText("输入不能为空");
			}
			else{
			try
			{
			 rs = stmt.executeQuery("select * from TSB where 图书编号 ='"+textField1.getText()+"'" );
			if(rs.next()){
        				JOptionPane.showMessageDialog(null, "字段存在重新输入",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
				textField1.setText("");
				textField2.setText("");
				textField3.setText("");
				textField4.setText("");
				textField5.setText("");
				textField6.setText("");
			}
			else{
       			stmt.execute(
            			"insert into TSB(图书编号,书名,作者,出版社,数量,价格) values ('" +
            			textField1.getText() + "','" + textField2.getText() + "','" +
            			textField3.getText() + "','" + textField4.getText() + "','" +
            			textField5.getText() +"','"+ textField6.getText()+ "')");
				textField1.setText("");
				textField2.setText("");
				textField3.setText("");
				textField4.setText("");
				textField5.setText("");
				textField6.setText("");
        			label7.setText("输入成功");
				}
						
			}
      			catch (Exception eg) {
        		label7.setText("输入错误");
			eg.printStackTrace();
			}
			}

		}
                if(str.equals("取消"))
                {
                    setVisible(false);
                 }
	
	}

}