test.java

eclipse加sql实现进销存eclipse加sql实现进销存eclipse加sql实现进销存eclipse加sql实现进销存eclipse加sql实现进销存eclipse加sql实现进销存

package goods;

import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class Test 
{
	public static void main(String[] args) 
	{
		List list = new ArrayList() ;
	      try
	      {
			Connect con = new Connect() ;
	        Statement stmt = con.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY) ;
			ResultSet rs = stmt.executeQuery("select * from goodsinfo") ;
			GoodsinfoBean tl = null ;
			while(rs.next())
		    {  tl = new GoodsinfoBean() ;
				System.out.println("===========================================================") ;
				Iterator it = list.iterator() ;
				while(it.hasNext())
			    {
					GoodsinfoBean t = (GoodsinfoBean)it.next() ;
				   System.out.print(t.getGname()) ;
				   System.out.println(t.getGnumber()) ;
				   System.out.println(t.getGstore());
			    }
				System.out.println("-------------------------------------") ;
				System.out.print(rs.getString(1).trim()) ;
				System.out.println(rs.getString(2).trim()) ;
				tl.setGname(rs.getString(1)) ;
				tl.setGname(rs.getString(2)) ;
				list.add(tl) ;		    			    
			}			
		  }
		  catch(Exception e)
		  {
			  System.out.println(e) ;
		  }
		  finally
		  {
			//con.close() ;
		  }
	}
}