operatesale.java

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

package goods.operate;

import goods.Connect;
import goods.SalegoodsBean;

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

public class OperateSale 
{
	public void save(SalegoodsBean sgoods)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("insert into salegoods values ('"+sgoods.getSname()+"','"+sgoods.getSnumber()+"','"+sgoods.getScount()+"','"+sgoods.getSsaleprice()+"')") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
	
	public void update(String snumber , int count)
	{
		Connect con = new Connect() ;
		try 
		{
			Statement stmt = con.getConnection().createStatement() ;
			stmt.executeUpdate("update salegoods set scount=scount+"+count+" where snumber='"+snumber+"'") ;
			stmt.close() ;
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		finally
		{
			con.close() ;
		}
	}
}