commoditystocksdao.java

来自「关于shopmanager的源码」· Java 代码 · 共 41 行

package dao;
import java.sql.*;

import common.DBConnection;

public class CommodityStocksDAO {
	private DBConnection connection=new DBConnection();
	public CommodityStocksDAO ()
	{		
	}

	public ResultSet executeQuery(String s){
		
	   String sql="select * from SPKCB";
	   
	   try
	   {
		ResultSet rs= connection.executeQuery(sql,null);
		return rs;
		}
	   catch(Exception e){
     	e.printStackTrace();
     	return null;
		}
	}
	
	//更新
	public int executeUpdate(String s,String values ){
		 String sql="update SPKCB set price=? where itemid=?";
		
		try{
		 connection.executeUpdates(sql,values);
		 return 1;
		}catch(Exception e){
			e.printStackTrace();
			return -1;
		}
		
}
}