operateinfo.java

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

package goods.operate;

import goods.Connect;
import goods.GoodsinfoBean;

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

public class OperateInfo 
{
	public void save(GoodsinfoBean info)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("insert into goodsinfo values ('"+info.getGname()+"','"+info.getGnumber()+"','"+info.getGfactory()+"','"+info.getGstore()+"')") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
	
	public void buyUpdate(String gnumber , int count)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("update goodsinfo set gstore=gstore+"+count+" where gnumber='"+gnumber+"'") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
	public void saleUpdate(String gnumber , int count)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("update goodsinfo set gstore=gstore-"+count+" where gnumber='"+gnumber+"'") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
	public List findAll()
	{
		Connect con = new Connect();
		List list = new ArrayList();
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			ResultSet rs=stmt.executeQuery("select * from goodsinfo");
      		while(rs.next())
      		{
      			GoodsinfoBean goods = new GoodsinfoBean() ;
    			goods.setGname(rs.getString("gname")) ;
    			goods.setGnumber(rs.getString("gnumber")) ;
    			goods.setGfactory(rs.getString("gfactory")) ;
    			goods.setGstore(rs.getShort("gstore")) ;
    			list.add(goods) ;
    		}
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
		return list ;
	}
}