change.java

自己编写的一个程序

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;


public class Change extends JFrame {

	private JTextField textField_4;
	private JTextField textField_3;
	private JTextField textField_2;
	private JTextField textField_1;
	private JTextField textField;
	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			Change frame = new Change();
			frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public Change() {
		super();
		getContentPane().setLayout(null);
		setBounds(100, 100, 362, 375);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JLabel label = new JLabel();
		label.setText("输入要修改的行：");
		label.setBounds(55, 29, 107, 15);
		getContentPane().add(label);

		textField = new JTextField();
		textField.setBounds(192, 27, 95, 20);
		getContentPane().add(textField);

		final JLabel label_1 = new JLabel();
		label_1.setText("输入修改后的信息");
		label_1.setBounds(96, 71, 118, 15);
		getContentPane().add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setText("姓名：");
		label_2.setBounds(55, 109, 71, 15);
		getContentPane().add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setText("性别：");
		label_3.setBounds(55, 147, 60, 15);
		getContentPane().add(label_3);

		final JLabel label_4 = new JLabel();
		label_4.setText("年龄：");
		label_4.setBounds(55, 187, 60, 15);
		getContentPane().add(label_4);

		final JLabel label_5 = new JLabel();
		label_5.setText("工资：");
		label_5.setBounds(55, 232, 60, 15);
		getContentPane().add(label_5);

		textField_1 = new JTextField();
		textField_1.setBounds(192, 107, 95, 20);
		getContentPane().add(textField_1);

		textField_2 = new JTextField();
		textField_2.setBounds(192, 145, 95, 20);
		getContentPane().add(textField_2);

		textField_3 = new JTextField();
		textField_3.setBounds(192, 185, 95, 20);
		getContentPane().add(textField_3);

		textField_4 = new JTextField();
		textField_4.setBounds(192, 230, 95, 20);
		getContentPane().add(textField_4);

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				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);
					Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
					String SQL="SELECT * FROM 职工工资信息";
					ResultSet rs=stmt.executeQuery(SQL);
					rs.absolute(Integer.parseInt(textField.getText()));
					rs.deleteRow();
					rs.moveToInsertRow();
					rs.updateString("姓名", textField_1.getText());
					rs.updateString("性别", textField_2.getText());
					rs.updateString("年龄", textField_3.getText());
					rs.updateString("工资", textField_4.getText());
					rs.insertRow();
					stmt.close();
					con.close();
					
					
					
			}
				catch(SQLException ex)
				{
					ex.printStackTrace();
			
				}
				setVisible(false);
			}
		});
		button.setText("确定");
		button.setBounds(113, 275, 99, 23);
		getContentPane().add(button);
		//
	}

}