demo.java

自己编写的一个程序

import java.awt.Color;
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.SQLException;
import javax.swing.JButton;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JTextPane;


public class Demo extends JFrame {

	public static void main(String args[]) {
		try {
			Demo frame = new Demo();
			frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public Demo() {
		super("职工工资管理系统");
		getContentPane().setLayout(null);
		setBounds(130, 130, 695, 360);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JTextArea text = new JTextArea();
		text.setEditable(false);
		text.setText("ID"+"\t"+"姓名"+"\t"+"性别"+"\t"+"年龄"+"\t"+"工资"+"\t");
		text.setBounds(0, 0, 695, 360);
		getContentPane().add(text);

		final JMenuBar menuBar = new JMenuBar();
		final JMenu menu=new JMenu("菜单");
		final JMenuItem menu1=new JMenuItem("添加");
		menu1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					Add frame = new Add();
					frame.setVisible(true);
					
				} catch (Exception ee) {
					ee.printStackTrace();
				}
				
			}
		});
		final JMenuItem menu2=new JMenuItem("查询");
		menu2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				text.setText("ID"+"\t"+"姓名"+"\t"+"性别"+"\t"+"年龄"+"\t"+"工资"+"\t");
				try{
					//加载JDBC-ODBC桥驱动程序
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException ex){
					text.setText(ex.getMessage());
					System.exit(-1);
				}
				try{
					
					String URL="jdbc:odbc:职工工资信息";
			
					Connection con=DriverManager.getConnection(URL);

					
					String n1="select * FROM 职工工资信息 ";
					PreparedStatement stmt=con.prepareStatement(n1);
					ResultSet rs=stmt.executeQuery();
					Integer count=new Integer(1);
					String[] s=new String[11];
					while(rs.next()){
						text.append("\n");
						s[0]=count.toString();
						count++;
						text.append(s[0]+"\t");
						s[1]=rs.getString("职工姓名");
						text.append(s[1]+"\t");
						s[2]=rs.getString("性别");
						text.append(s[2]+"\t");
						s[3]=rs.getString("年龄");
						text.append(s[3]+"\t");
						s[4]=rs.getString("月薪");
						text.append(s[4]+"\n");
					}

					
					rs.close();
					stmt.close();
					con.close();
				}
				catch(SQLException ex){
					text.setText(ex.getMessage());
				}
			}
		});
		final JMenuItem menu3=new JMenuItem("删除");
		menu3.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					Delete frame = new Delete();
					frame.setVisible(true);
					frame.setLocation(130,130+360);
						
				} catch (Exception e1) {
					e1.printStackTrace();
				}
			}
		});
		final JMenuItem menu4=new JMenuItem("修改");
		menu4.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					Change frame = new Change();
					frame.setVisible(true);
				} catch (Exception e2) {
					e2.printStackTrace();
				}
			}
		});
	
		setJMenuBar(menuBar);
		menuBar.add(menu);
	
		menu.add(menu1);
		menu.add(menu2);
		menu.add(menu3);
		menu.add(menu4);
		//
	}
	
	

}