dele.java

一个水气收费系统 具有 删除 查询等功能

import java.awt.*;
import java.awt.event.*;
import javax.swing.* ;
import java.sql.* ;
import java.lang.Object ;


public class dele
{
	
	PreparedStatement prepStmt = null ;
	
	public dele(String users ,Integer i)
	{   
	 try
	 {
	 
	     conn conn = new conn("wanglei","wanglei") ;
		 prepStmt = conn.conn.prepareStatement("delete from "+users+ " where userid = ?") ;
         prepStmt.setInt(1,i) ;
         prepStmt.executeQuery() ;
	}//try
	catch(Exception e)
	{
		 JOptionPane.showMessageDialog(new JFrame(), "Wrong delete", "Dialog", 
                          JOptionPane.ERROR_MESSAGE); 
	}
	
	}
}//dele