product.java

网上购物源代码

package com.chinaaccpDao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.chinaaccpbean.Productbeen;
public class Product {
	public ArrayList<Productbeen> getAllProcuct(){
		ArrayList<Productbeen> list=new ArrayList<Productbeen>();
		try {
			String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName(sDBDriver);
			String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
			String name = "sa";
			Connection connshop=DriverManager.getConnection(sConnStr,name,"");
			Statement stmt=connshop.createStatement();
			String sql="select ID,ProNum,name,categoryid,descInfo,price,quantity,status,picture from product";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next()){
				Productbeen pro = new Productbeen();
				pro.setID(rs.getString(1));
				pro.setProNum(rs.getString(2));
				pro.setName(rs.getString(3));
				pro.setCategoryid(rs.getString(4));
				pro.setDescInfo(rs.getString(5));
				pro.setPrice(rs.getDouble(6));
				pro.setQuantity(rs.getString(7));
				pro.setStatus(rs.getString(8));
				pro.setPicture(rs.getString(9));
				list.add(pro);
			}
			rs.close();
			stmt.close();
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
		
	}
	
public boolean setInsert(String proNum,String name,String cate,String descInfo,double price,String quantity,String status,String picture){
		
		try {
			String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName(sDBDriver);
			String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
			String loginname = "sa";
			Connection connshop=DriverManager.getConnection(sConnStr,loginname,"");
			Statement stmt=connshop.createStatement();
			
			String sql1 = "insert into OrderMess(price,quantity) values("+price+",'"+quantity+"')";
			String sql2 ="insert into Product(proNum,name,categoryid,descInfo,price,quantity,status,picture) values('"+proNum+
			"','"+name+"','"+cate+"','"+descInfo+"',"+price+",'"+quantity+"','"+status+"','"+picture+"')";
			 
			int rs1 = stmt.executeUpdate(sql1);
			int rs2 = stmt.executeUpdate(sql2);
		
			stmt.close();
			if(rs1>0 || rs2 >0)
				return true;
			else
				return false;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
}
public boolean setUpdate(int ID,String proNum,String name,String cate,String descInfo,String price,String quantity,String status,String picture){
		
		double price2 = Double.parseDouble(price);
	try {
		String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		Class.forName(sDBDriver);
		String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
		String loginname = "sa";
		Connection connshop=DriverManager.getConnection(sConnStr,loginname,"");
		Statement stmt=connshop.createStatement();
		
		String sql1 = "update OrderMess set price="+price2+",quantity='"+quantity+"'";
		String sql2 ="update Product set proNum='"+proNum+"',name='"+name+"',categoryid='"+cate+"',descInfo='"+
		descInfo+"',price="+price2+",quantity='"+quantity+"',status='"+status+"',picture='"+picture+"' where ID ='"+ID+"'";
		
		int rs1 =stmt.executeUpdate(sql1);
		int rs2 = stmt.executeUpdate(sql2);
		
		stmt.close();
		if(rs1 >0 || rs2 >0) 
			return true;
		else
			return false;
		
		
	} catch (Exception e) {
		e.printStackTrace();
		return false;
	}
}
		
public boolean setDelete(int ID){
		
		try {
			String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName(sDBDriver);
			String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
			String name = "sa";
			Connection connshop=DriverManager.getConnection(sConnStr,name,"");
			Statement stmt=connshop.createStatement();
			String sql1="delete from OrderMess where productID='"+ID+"'";
			String sql2="delete from Product where ID ='"+ID+"'";
	
			int rs1=stmt.executeUpdate(sql1);
			int rs2=stmt.executeUpdate(sql2);
			
		
			stmt.close();
			if(rs1==1&&rs2==1)
				return true;
			else
				return false;
			
			
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}
public Productbeen getall(int ID){
	Productbeen been = null;
	try {
		String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		Class.forName(sDBDriver);
		String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
		String name = "sa";
		Connection connshop=DriverManager.getConnection(sConnStr,name,"");
		Statement stmt=connshop.createStatement();
		String sql="select ID,ProNum,name,categoryid,descInfo,price,quantity,status,picture from product where ID = "+ID+"";
		ResultSet rs=stmt.executeQuery(sql);
		if(rs.next()){
			been = new Productbeen();
			been.setID(rs.getString(1));
			been.setProNum(rs.getString(2));
			been.setName(rs.getString(3));
			been.setCategoryid(rs.getString(4));
			been.setDescInfo(rs.getString(5));
			been.setPrice(rs.getDouble(6));
			been.setQuantity(rs.getString(7));
			been.setStatus(rs.getString(8));
			been.setPicture(rs.getString(9));
		}
		rs.close();
		stmt.close();
		
	} catch (Exception e) {
		e.printStackTrace();
	}
	return been;
  }
}