sele.java

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

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


public class sele
{
	  PreparedStatement prepStmt = null ;
	  ResultSet rsd = null ;
	public sele(String name,Integer i)
	{
		try
		{
		
		conn conn = new conn("wanglei","wanglei") ;
	    prepStmt = conn.conn.prepareStatement("select * from "+name+ " where userid = ? order by data asc",ResultSet.TYPE_SCROLL_INSENSITIVE  ,ResultSet.CONCUR_UPDATABLE) ; 
	    
	    prepStmt.setInt(1,i) ;
        	 
        rsd = prepStmt.executeQuery() ;
	    
	    
	    
	    }//try
	    catch(Exception e)
	    {
	    	 JOptionPane.showMessageDialog(new JFrame(), "Wrong select", "Dialog", 
                          JOptionPane.ERROR_MESSAGE); 
	    }//catch
		
	}//sele
	
	public sele(String name)
	{
		try
		{
			conn conn = new conn("wanglei","wanglei") ;
			prepStmt = conn.conn.prepareStatement("select * from "+name+" order by data asc",ResultSet.TYPE_SCROLL_INSENSITIVE  ,ResultSet.CONCUR_UPDATABLE) ;
		 	 
            rsd = prepStmt.executeQuery() ;
        }//try
		catch(Exception e)
		{
			 JOptionPane.showMessageDialog(new JFrame(), "Wrong select ", "Dialog", 
                          JOptionPane.ERROR_MESSAGE); 
		}//catch
	}//sele
}//sele