inbooksform.java

来自「java图书销售系统。。。。。。。。。。。。。。。。。。。。」· Java 代码 · 共 155 行

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;

   
   public class InBooksForm extends JFrame {
	  /**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private JFrame frame ;
	  private JPanel p1,p2;
	  private JLabel l1,l2,l3,l4,l5,l6,l7;
	  private JTextField f1,f2,f3,f4,f5,f6,f7;
	  private JButton b1,b2;
	  DBClass db = new DBClass();
	  Statement stmt = db.getStmt();	  
      Connection con = db.getConn();      
	  ResultSet rs = null;
	  private String str1;
	  private String str2;
	  private String str3;
	  private String str4;
	  private String str5;
	  private String str6;
	  private String str7;
	  private PreparedStatement prep;
	  
	   public InBooksForm(){
		 frame = new JFrame();		
		 p1 = new JPanel();
		 p2 = new JPanel();
		 l1 = new JLabel("日          期");
		 l2 = new JLabel("图书编号");
		 l3 = new JLabel("图书名称");
		 l4 = new JLabel("图书单价");
		 l5 = new JLabel("图书数量");
		 l6 = new JLabel("总          价");
		 l7 = new JLabel("入库单编号");
		 f1 = new JTextField(10);	 
		 f2 = new JTextField(10);
		 f3 = new JTextField(10);
		 f4 = new JTextField(10);
		 f5 = new JTextField(10);
		 f6 = new JTextField(10);
		 f7 = new JTextField(10);
		 b1 = new JButton("确   定"); 
		 b2 = new JButton("取   消"); 
		 str1 = f1.getText().trim();
		 str2 = f2.getText().trim();
		 str3 = f3.getText().trim();
		 str4 = f4.getText().trim();
		 str5 = f5.getText().trim();
		 str6 = f6.getText().trim();
		 str7 = f7.getText().trim();
	   }
	   
	   public void InFrame(){
		   p1.setLayout(new GridLayout(7,2));
		   p1.add(l1);
		   p1.add(f1);
		   p1.add(l2);
		   p1.add(f2);
		   p1.add(l3);
		   p1.add(f3);
		   p1.add(l4);
		   p1.add(f4);
		   p1.add(l5);
		   p1.add(f5);
		   p1.add(l6);
		   p1.add(f6);
		   p1.add(l7);
		   p1.add(f7);
		   frame.getContentPane().add(p1,BorderLayout.CENTER);
		   p2.setLayout(new GridLayout(1,1));
		   b1.addActionListener( new action());
		   p2.add(b1);
		   b2.addActionListener(new action());
		   p2.add(b2);
		   frame.getContentPane().add(p2,BorderLayout.SOUTH);
		   frame.setVisible(true);
		   frame.setSize(280,320);
		   frame.setTitle("入库登记表");
		   
	   }
	   class action implements ActionListener{
		   public void actionPerformed(ActionEvent e){
			   if(e.getActionCommand()=="确   定"){
				   
				  /* try
				   {
					
					//stmt=con.createStatement();
					/*String sql="insert into InForm(日期,入库单编号,图书编号,图书名称,单价,数量,总价) values(?,?,?,?,?,?,?)";
					prep=con.prepareStatement(sql);
					
					prep.setString(1,str1);
					prep.setString(2,str2);
					prep.setString(3,str3);
					prep.setString(4,str4);
					prep.setString(5,str5);
					prep.setString(6,str6);
					prep.setString(7,str7);
				    rs = prep.executeQuery();*/
					/*prep = con.prepareStatement("insert into Inform values(?,?,?,?,?,?,?)");
					Object []line={str1,str2,str3,str4,str5,str6,str7};
					for(int i=1;i<=line.length;i++){
						prep.setObject(i,line[i-1]);
					}
					prep.executeQuery();
					prep.close();
					con.close();
					JOptionPane.showMessageDialog(null,"已入库",null,JOptionPane.PLAIN_MESSAGE);
					
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}*/
				   JOptionPane.showMessageDialog(null,"已入库",null,JOptionPane.PLAIN_MESSAGE);
				
				
			
		   
			   }else if(e.getActionCommand()=="取   消"){
				   frame.setVisible(false);
				   				  			   
			   }
			   
      }
		   
	   }
	   public static void main(String[] args){
		   InBooksForm f = new InBooksForm();
		   f.InFrame();
		   
		   
	   }
	   
   }