s_change.java

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

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

import java.awt.event.*;
import java.sql.*;

/*public class S_change 
{
	public static void main(String[] args)
	{
		S_c sc=new S_c("修改基本工资");
	}

}*/
public class S_change extends JFrame
{
	JComboBox jcb;
	JLabel jLabel1,jLabel2;
	JTextField jtf;
	JButton jbtn,jbtn1;
	S_change(String s)
	{
		super(s);
		setLayout(null);
		setBounds(200,200,300,200);
		jLabel1=new JLabel("请选择职位名称:");
		jLabel2=new JLabel("基本工资(元):");
		jbtn=new JButton("提交");
		jbtn1=new JButton("退出");
		jbtn1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
		});
		jcb=new JComboBox();
		jcb.addItem("讲师");
		jcb.addItem("辅导员");
		jcb.addItem("系主任");
		jcb.addItem("教授");
		jcb.addItem("校长");
		jcb.addItem("助教");
		jtf=new JTextField(10);
		jLabel1.setBounds(30,15,110,30);
		jcb.setBounds(145,20,80,20);
		jLabel2.setBounds(45,45,100,30);
		jtf.setBounds(145,50,50,20);
		jbtn.setBounds(60,100,60,30);
		jbtn1.setBounds(160,100,60,30);
		Container con=getContentPane();
		con.add(jLabel1);
		con.add(jcb);
		con.add(jLabel2);
		con.add(jtf);
		con.add(jbtn);
		con.add(jbtn1);
		jbtn.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e) 
			{
				// TODO 自动生成方法存根
				change();
				
			}
		});
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setVisible(true);
	}
	void change()
	{
		String str1,str3;
		float str2;
		str1=(String)jcb.getSelectedItem();
		str3=jtf.getText();
		if(str3.equals("")) JOptionPane.showMessageDialog(this, "请输入基本工资","提示",JOptionPane.INFORMATION_MESSAGE);
		else
		{
			str2=Float.parseFloat(str3);
			try {
				Class.forName("sun.jdbc.odbc.JbdcObdcDriver");
			} catch (ClassNotFoundException e) {}
			try {
				Connection con=DriverManager.getConnection("jdbc:odbc:salary","","");
				PreparedStatement psmt=con.prepareStatement("update post set basic_salary=? " +
						"where posttitle='"+str1+"'");
				psmt.setFloat(1, str2);
				psmt.executeUpdate();
				JOptionPane.showMessageDialog(this, "修改成功","提示",JOptionPane.INFORMATION_MESSAGE);
				dispose();
				psmt.close();
				con.close();
			} catch (Exception e) {
				// TODO: handle exception
				e.printStackTrace();
				//JOptionPane.showMessageDialog(this, "请输入基本工资","提示",JOptionPane.INFORMATION_MESSAGE);
			}
		}
	}
}