shoppinglistdao.java

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

package dao;

import java.sql.ResultSet;

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

public class ShoppingListDAO {

	private DBConnection connection=new DBConnection();
		public ShoppingListDAO ()
		{		
		}
	
		public ResultSet executeQuery(String userid){
			
		   String sql="select * from GWQDB";
		   
		   try
		   {
			ResultSet rs= connection.executeQuery(sql,null);
			return rs;
			}
		   catch(Exception e){
	     	e.printStackTrace();
	     	return null;
			}
		}
		
		
		
		
		
        //添加
		public int executeADD(String[]values){
			String sql="insert into GWQDB(useid,itemid,name,number,cost) values(?,?,?,?,?)";
			int a=-1;
			try{
			 a=connection.executeUpdate(sql,values);
			}catch(Exception e){}
			return a;
		}
		//删除
		public  int delete(String values){
			String sql="delete from GWQDB where itemid=?";
			  int i=0;
			try{
				i=connection.executeUpdates(sql, values);
				i=1;
			}catch(Exception e){
				System.err.println(e.getMessage());
				i=0;
			}
			return i;
		}
//		更新
		public int executeUpdate(String values ){
			
			 String sql="update GWQDB(userid) values(?)";
			
			try{
			 connection.executeUpdates(sql,values);
			 return 1;
			}catch(Exception e){
				e.printStackTrace();
				return -1;
			}
	
}
}