transactcard.java

Java 图书馆管理系统 Java 图书馆管理系统原代码,包括一些最基本的功能,非常实用.

package 图书馆;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
/**
 * 
 * @author hp
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class TransactCard implements ActionListener
{private  JButton btn1,btn2;
 private  JTextField tfd1,tfd3,tfd4,tfd5,tfd6,tfd7,tfd8,tfd9;
 private  JComboBox jcb1,jcb3;
 private  PreparedStatement pstmt1;
 private  Connection con;
 private  JFrame frame;
 private  PreparedStatement pstmt2;
 private JPasswordField jpdf ;
 /**
  * 构造函数
  *
  */
	public TransactCard()
	{
	 frame=new JFrame("图书证办理");
		Container content=frame.getContentPane();
	/**
	 * 面板设置
	 */
		content.setLayout(new BorderLayout());
		JPanel Jpl=new JPanel();
		JPanel Jpl2=new JPanel();
		Jpl.setLayout(new GridLayout(9,2,2,6));
		Jpl2.setLayout(new GridLayout(1,2,2,0));
		JLabel lb1=new JLabel("姓名:");
		JLabel lb2=new JLabel("密码:");
		JLabel lb3=new JLabel("性别:");
		JLabel lb4=new JLabel("身份:");
		JLabel lb5=new JLabel("单位:");
		JLabel lb6=new JLabel("证件号码:");
		JLabel lb7=new JLabel("借书证号:");
		JLabel lb8=new JLabel("注册日期:");
		JLabel lb9=new JLabel("有效日期:");
		
		btn1=new JButton("添加");
		btn2=new JButton("退出");
		btn1.addActionListener(this);
		btn2.addActionListener(this);
		
		String[] str_sex={"男","女"};
		String[] str_office={"计算机系","电子系","商学系","机电系","外语系","其他"};
		jcb1=new JComboBox(str_sex);
		jcb3=new JComboBox(str_office);
		
		tfd1=new JTextField();
		tfd3=new JTextField();
		tfd4=new JTextField();
		tfd5=new JTextField();
		tfd6=new JTextField();
		tfd7=new JTextField();
		tfd8=new JTextField();
		tfd9=new JTextField();
		
       jpdf = new JPasswordField();
       
		Jpl.add(lb1);
		Jpl.add(tfd1);
		Jpl.add(lb2);
		Jpl.add(jpdf);		
		Jpl.add(lb3);
		Jpl.add(jcb1);
		Jpl.add(lb4);
		Jpl.add(tfd4);
		Jpl.add(lb5);
		Jpl.add(jcb3);
		Jpl.add(lb6);
		Jpl.add(tfd6);
		Jpl.add(lb7);
		Jpl.add(tfd7);
		Jpl.add(lb8);
		Jpl.add(tfd8);
		Jpl.add(lb9);
		Jpl.add(tfd9);
		
		Jpl2.add(btn1);
		Jpl2.add(btn2);

		content.add(Jpl,BorderLayout.CENTER);
		content.add(Jpl2,BorderLayout.SOUTH);
		frame.setSize(450,400);
		frame.setVisible(true);
		/**
		 * 连接数据库
		 */
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String sqlStr1;
			sqlStr1 = "insert into userziliao( 姓名 ,密码, 性别, 身份, 单位, 证件号码,借书证号,注册日期, 有效日期 ) " +
					" values (?,?,?,?,?,?,?,?,?) " ;
			con=DriverManager.getConnection("jdbc:odbc:demo");
			 pstmt1 = con.prepareStatement(sqlStr1);

		   }
		   catch(SQLException e)
		   {		   	
		   }
		   catch(ClassNotFoundException cnfe)
		   {
		   }
	}
	/**
	 * 事件处理
	 */
	public void actionPerformed(ActionEvent e){
	 String str1,str2,str3,str4,str5,str6,str7,str8,str9;
	 str1=tfd1.getText().trim();
	 str2 = jpdf.getText().trim() ;
	 str3=jcb1.getSelectedItem().toString();
	 str4=tfd4.getText().trim();
	 str5=jcb3.getSelectedItem().toString();
	 str6=tfd6.getText().trim();
	 str7=tfd7.getText().trim();
	 str8=tfd8.getText().trim();
	 str9=tfd9.getText().trim();
	 int result;
	 try{	 
	 	 Object obj=(JButton)e.getSource();
	  if(obj==btn1)
	   {
	  	if (str1.equals("") | str2.equals("") | str3.equals("")
				| str4.equals("") | str5.equals("")| str6.equals("")) {
			JOptionPane.showMessageDialog(frame, "can't be null");
			return;
		}
	  pstmt1.setString(1,str1);
	  pstmt1.setString(2,str2);
	  pstmt1.setString(3,str3);
	  pstmt1.setString(4,str4);
	  pstmt1.setString(5,str5);
	  pstmt1.setString(6,str6);
	  pstmt1.setString(7,str7);
	  pstmt1.setString(8,str8);
	  pstmt1.setString(9,str9);
	  
	  result = pstmt1.executeUpdate();   
	  if (result > 0) {
		JOptionPane.showMessageDialog(frame, "add successfully!");
	}
		tfd1.setText("");
		jpdf.setText("");
		tfd3.setText("");
		tfd4.setText("");
		tfd5.setText("");
		tfd6.setText("");	
		tfd7.setText("");	
		tfd8.setText("");	
		tfd9.setText("");	
	   }else if(obj==btn2)
	    {
	  pstmt1.close();
	  con.close();	  
	  frame.dispose();
	  
	 }
	 }
	  catch(SQLException sqle)
	      {System.err.println(sqle.getMessage());
	      }
	}
	/**
	 * 主函数
	 * @param args
	 */
	public static void main(String[]args)
	{
		new TransactCard();
	}
}