commoditydao.java

关于shopmanager的源码

package dao;
import java.sql.*;
import common.DBConnection;

public class CommodityDAO {


	private DBConnection connection=new DBConnection();
		public CommodityDAO ()
		{		
		}
	//查询
		public ResultSet execute(String s){
			
		   String sql="select * from SPB";
		   ResultSet rs;
		   try
		   {
			 rs= connection.executeQuerys(sql,null);
			
			}
		   catch(Exception e){
	     	e.printStackTrace();
	      rs=null;
			}
		   return rs;
		}
		/*
   //插入
		public int executeInsert(String[] values){
			String sql="insert into table1 values(?,?,?,?)";
			int a=-1;
			try{
			 a=connection.executeUpdate(sql,values);
			}catch(Exception e){}
			return a;
		}
		//更新
		public int executeUpdate(String[]values ){
			String sql="update table1 set cost=? where itemid=?";
			int i;
			try{
			 connection.executeUpdate(sql,values);
			 i=1;
			}catch(Exception e){
				e.printStackTrace();i=-1;
			}
			return i;
	}
	*/

}