delnum.java

A easy phone book. With the book,you can manage you personal masagge.

/***********************************
 *                                 *
 *       这里定义删除功能          *
 *                                 *
 ***********************************/
import java.awt.event.*;
import java.sql.*;

public class DelNum implements ActionListener{
	private static int delRows[];
	private static String delname[];
	public void actionPerformed(ActionEvent e){
		if(e.getActionCommand().equals("删除")||e.getActionCommand().equals("删除记录")){
			 del();
		}
	}
	
	public static void del(){
		delRows=SqlTable.getSelectedrows();
		delname=new String[delRows.length];
		for(int i=0;i<delRows.length;i++){
			  //System.out.println(SqlTable.getValue(delRows[i]));
		      delname[i]="delete from phonenum where name='"+SqlTable.getValue(delRows[i])+"'";
			}
		try{
		   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		   Connection con=DriverManager.getConnection(phonenum.getConnection());
		   Statement stmt=con.createStatement();
		   for(int i=0;i<delname.length;i++)
		          stmt.executeUpdate(delname[i]);
		   stmt.close();
		   con.close();
		   }
		catch(Exception e){
		   //e.printStackTrace();
		}
		
		Update.furbish();
		
    }
}