operatebuy.java

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

package goods.operate;

import goods.BuygoodsBean;
import goods.Connect;

import java.sql.SQLException;
import java.sql.Statement;

public class OperateBuy 
{
	public void save(BuygoodsBean bgoods)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("insert into buygoods values ('"+bgoods.getBname()+"','"+bgoods.getBnumber()+"','"+bgoods.getBcount()+"','"+bgoods.getBbuyprice()+"')") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
	
	public void update(String bnumber , int count)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("update buygoods set bcount=bcount+"+count+" where bnumber='"+bnumber+"'") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
}