text1.txt

JDBC 数据库嵌入java内

import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Ex10_2 implements ActionListener
{
    JFrame f=null;
	public Ex10_2()
	{
	    f=new JFrame("员工信息");
		Container contentPane=f.getContentPane();
		JPanel buttonPanel=new JPanel();
		JButton b=new JButton("员工登记");
		b.addActionListener(this);
		buttonPanel.add(b);
		b=new JButton("退出系统");
		b.addActionListener(this);
		buttonPanel.add(b);


		buttonPanel.setBorder(BorderFactory.createTitledBorder(
		    BorderFactory.createLineBorder(Color.blue,2),
			"员工登记系统",TitledBorder.CENTER,TitledBorder.TOP));
		contentPane.add(buttonPanel,BorderLayout.CENTER);


		JMenuBar mBar=new JMenuBar();
		JMenu selection=new JMenu("选项");
		JMenuItem regist=new JMenuItem("员工登记");
		JMenuItem sum=new JMenuItem("统计");
		selection.add(regist);
		selection.add(sum);
		JMenu sys=new JMenu("系统");
		JMenuItem exit=new JMenuItem("退出系统");
		sys.add(exit);
		mBar.add(selection);
		mBar.add(sys);
		f.setJMenuBar(mBar);
		regist.addActionListener(this);
		sum.addActionListener(this);
        exit.addActionListener(this);


		f.pack();
		f.setVisible(true);

		f.addWindowListener(new WindowAdapter(){
		     public void windowClosing(WindowEvent e){
			     System.exit(0);
		     }
		});
	}

    public void actionPerformed(ActionEvent e){
        String cmd=e.getActionCommand();
	    if(cmd.equals("员工登记")){
	        new RegistSystem(f);
	    } else if(cmd.equals("退出系统")){
	        System.exit(0);
	    } else if(cmd.equals("统计")){
    	try{
	        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		    Connection con=
		    DriverManager.getConnection("jdbc:odbc:PIMS","Test","1234");
		    Statement stmt=con.createStatement();
		    ResultSet rs=stmt.executeQuery("Select * From Person");
		    int i=0;
		    while(rs.next())  i=i+1;
		    JOptionPane.showMessageDialog(f,"共有"+i+"名员工");
		    stmt.close();
		    con.close();
	        }
	    catch(Exception ex){}
	    }
    }

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

}


class RegistSystem implements ActionListener
{
    JDialog dialog;
	JTextField tF1=new JTextField();
	JTextField tF2=new JTextField();
	JTextField tF3=new JTextField();
	JTextField tF4=new JTextField();
	JTextField tF5=new JTextField();
	JTextField tF6=new JTextField();
	RegistSystem(JFrame f){
	    dialog=new JDialog(f,"员工登记",true);
		Container dialogPane=dialog.getContentPane();
		dialogPane.setLayout(new GridLayout(7,2));

		dialogPane.add(new JLabel("员工编号:",SwingConstants.CENTER));
		dialogPane.add(tF1);
		dialogPane.add(new JLabel("员工姓名:",SwingConstants.CENTER));
		dialogPane.add(tF2);
		dialogPane.add(new JLabel("部门编号:",SwingConstants.CENTER));
		dialogPane.add(tF3);
		dialogPane.add(new JLabel("职务:",SwingConstants.CENTER));
		dialogPane.add(tF4);
		dialogPane.add(new JLabel("工资:",SwingConstants.CENTER));
		dialogPane.add(tF5);
		dialogPane.add(new JLabel("学历编号:",SwingConstants.CENTER));
		dialogPane.add(tF6);
		JButton b1=new JButton("确定");
		dialogPane.add(b1);
		JButton b2=new JButton("取消");
		dialogPane.add(b2);
		b1.addActionListener(this);
		b2.addActionListener(this);
		dialog.setBounds(200,150,400,130);
		dialog.show();
	}
	public void actionPerformed(ActionEvent e){
	    String cmd=e.getActionCommand();
		if(cmd.equals("确定")){
		    try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=
			DriverManager.getConnection("jdbc:odbc:PIMS","TEST","1234");
			Statement stmt=con.createStatement();
			int ID=Integer.parseInt(tF1.getText());
			String name=tF2.getText();
			int DepID=Integer.parseInt(tF3.getText());
			String Occupation=tF4.getText();
			int salary=Integer.parseInt(tF5.getText());
			int EduID=Integer.parseInt(tF6.getText());
			String SQLOrder="INSERT INTO Person VALUES("
			+ID+",'"+name+"',"+DepID+",'"+Occupation+"',"+salary+","+EduID+")";
			stmt.executeUpdate(SQLOrder);
			stmt.close();
			con.close();
			}
			catch(Exception ex){}
		}
		else if(cmd.equals("取消")){
		    dialog.dispose();
		}
	}
}