category.java

来自「网上购物源代码」· Java 代码 · 共 119 行

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.Categorybeen;

public class Category {
	public ArrayList<Categorybeen> getAllCategory(){
		ArrayList<Categorybeen> list=new ArrayList<Categorybeen>();
		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, name,descInfo from Category";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next()){
				Categorybeen ca = new Categorybeen();
				ca.setID(rs.getString(1));
				ca.setName(rs.getString(2));
				ca.setDescInfo(rs.getString(3));
				list.add(ca);
				
			}
			rs.close();
			stmt.close();
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
		
	}
	public boolean setInsert(String Cname, String DescInfo){
		
		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="insert into  Category values ('"+Cname+"','"+DescInfo+"') ";
			int rs=stmt.executeUpdate(sql);
		
			stmt.close();
			if(rs ==1)
				return true;
			else
				return false;
			
			
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
		
	}
	public boolean setEdit(int ID, String Cname, String DescInfo){
		
		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="update Category set name='"+Cname+"',descInfo='"+DescInfo+"' where ID ='"+ID+"'";
			int rs=stmt.executeUpdate(sql);
		
			stmt.close();
			if(rs ==1)
				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 product where categoryid = '"+ID+"'";
			String sql2 ="delete from Category 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;
		}
	}
}