increaseframe.java

java实现的工资管理系统 可以运行的源代码

package salary;
import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;

/*public class IncreaseFrame 
{
	public static void main(String[] args)
	{
		Inc_Frame ifr=new Inc_Frame("增加员工");
	}
}*/

public  class IncreaseFrame extends JFrame
    {
	JLabel jLabel1,jLabel2,jLabel3,jLabel4;
	JLabel jLabel5,jLabel6,jLabel7,jLabel8;
	JTextField jtf1,jtf2,jtf3,jtf6,jtf7,jtf8;
	JComboBox jcb1,jcb2;
	JButton jbtn,jbtn1;
	IncreaseFrame(String s)
	{
		super(s);
		setLayout(null);
		setBounds(200,200,300,350);
		jLabel1=new JLabel("员工号:");
		jLabel2=new JLabel("姓名:");
		jLabel3=new JLabel("密码:");
		jLabel4=new JLabel("职称:");
		jLabel5=new JLabel("性别:");
		jLabel6=new JLabel("联系电话:");
		jLabel7=new JLabel("文化程度:");
		jLabel8=new JLabel("工作单位:");
		jtf1=new JTextField();
		jtf2=new JTextField();
		jtf3=new JTextField();
		jcb1=new JComboBox();
		jcb1.addItem("讲师");
		jcb1.addItem("辅导员");
		jcb1.addItem("系主任");
		jcb1.addItem("教授");
		jcb1.addItem("校长");
		jcb1.addItem("助教");
		jcb2=new JComboBox();
		jcb2.addItem("男");
		jcb2.addItem("女");
		
		jtf6=new JTextField();
		jtf7=new JTextField();
		jtf8=new JTextField();
		jbtn=new JButton("增加");
		jbtn.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				add();
			}
		});
		jbtn1=new JButton("退出");
		jbtn1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
		});
		jLabel1.setBounds(60,20,50,20);
		jtf1.setBounds(115,20,100,20);
		jLabel2.setBounds(60,50,50,20);
		jtf2.setBounds(115,50,100,20);
		jLabel3.setBounds(60,80,50,20);
		jtf3.setBounds(115,80,100,20);
		jLabel4.setBounds(60,110,50,20);
		jcb1.setBounds(115,110,100,20);
		jLabel5.setBounds(60,140,50,20);
		jcb2.setBounds(115,140,50,20);
		jLabel6.setBounds(55,170,60,20);
		jtf6.setBounds(120,170,100,20);
		jLabel7.setBounds(55,200,60,20);
		jtf7.setBounds(120,200,100,20);
		jLabel8.setBounds(55,230,60,20);
		jtf8.setBounds(120,230,100,20);
		jbtn.setBounds(60,270,60,30);
		jbtn1.setBounds(180,270,60,30);
		Container con=getContentPane();
		con.add(jLabel1);
		con.add(jtf1);
		con.add(jLabel2);
		con.add(jtf2);
		con.add(jLabel3);
		con.add(jtf3);
		con.add(jLabel4);
		con.add(jcb1);
		con.add(jLabel5);
		con.add(jcb2);
		con.add(jLabel6);
		con.add(jtf6);
		con.add(jLabel7);
		con.add(jtf7);
		con.add(jLabel8);
		con.add(jtf8);
		con.add(jbtn);
		con.add(jbtn1);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setVisible(true);
		
	}
	void add()
	{
		try
		{
			String str1,str2,str3,str4,str5,str6,str7,str8;
			str1=jtf1.getText();
			str2=jtf2.getText();
			str3=jtf3.getText();
			System.out.println(str3.length());
			str4=(String)jcb1.getSelectedItem();
			str5=(String)jcb2.getSelectedItem();
			str6=jtf6.getText();
			str7=jtf7.getText();
			str8=jtf8.getText();
			//if(((str1==null)||(str2==null)||(str3==null)||(str7==null)||(str8==null)))
			if(str1.equals("")||str2.equals("")||str3.equals("")||str7.equals("")||str8.equals(""))
			{
				JOptionPane.showMessageDialog(this, "请完整输入","错误",JOptionPane.ERROR_MESSAGE);
			}
			else
			{
					try
					{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					}
					catch(ClassNotFoundException e){}
					Connection con=DriverManager.getConnection("jdbc:odbc:salary","","");
					PreparedStatement psmt=con.prepareStatement("insert into employee_info values(?,?,?,?,?,?,?,?)");
					psmt.setString(1,str1);
					psmt.setString(2,str2);
					psmt.setString(3,str3);
					psmt.setString(4,str4);
					psmt.setString(5,str5);
					psmt.setString(6,str6);
					psmt.setString(7,str7);
					psmt.setString(8,str8);
					//JOptionPane.showMessageDialog(this, "添加成功！","添加",JOptionPane.ERROR_MESSAGE);
					psmt.executeUpdate();
					//JOptionPane.showMessageDialog(this, "添加成功！","添加",JOptionPane.ERROR_MESSAGE);
					//System.out.println("Hello");
					JOptionPane.showMessageDialog(this, "添加成功！","添加",JOptionPane.INFORMATION_MESSAGE);
					dispose();
					psmt.close();
					con.close();
			  }
					
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(this, "员工号重复","错误",JOptionPane.ERROR_MESSAGE);
			//e.printStackTrace();}
		}
	}
	
}