delete.java

自己编写的一个程序

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 java.sql.Statement;

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


public class Delete extends JFrame {

	private JTextField textField;

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


	public Delete() {
		super();
		getContentPane().setLayout(null);
		setBounds(100, 100, 695, 200);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JLabel label = new JLabel();
		label.setText("请输入要删除的行数：");
		label.setBounds(10,30,160,30);
		getContentPane().add(label);

		textField = new JTextField();
		textField.setBounds(170, 30, 140, 30);
		getContentPane().add(textField);
		
		

		final JButton button = new JButton();
		
		button.setText("确定");
		button.setBounds(350, 30, 100, 30);
		getContentPane().add(button);
		
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try{
					
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException ex){
					
					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();
					stmt.close();
					con.close();
					
					
					
			}
				catch(SQLException ex)
				{
					ex.printStackTrace();
			
				}
				setVisible(false);
			}
		});
		
	}

}