ruleservice.java

使用jsp+Servlet,采用MVC模式,实现了一典型小型电子商务网站的全过程.包括前台和后台的全部功能.适合于初学者学习使用.

package com.eshop.service;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.eshop.util.DBManager;
import com.eshop.vo.Account;
import com.eshop.vo.Product;
import com.eshop.vo.Rule;

public class RuleService extends HttpServlet {

	
	
	
	/**
	 * 获得所有产品信息列表
	 * @return list
	 */
	public List getAllRule(){
		List list=new ArrayList();
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
			PreparedStatement ps=conn.prepareStatement("select * from ruler");
			ResultSet rs=ps.executeQuery();
			while (rs.next()){
				Rule rule=new Rule();
				rule.setRuleid(rs.getString("ruleid"));
				rule.setRule(rs.getString("rule"));
				rule.setStart(rs.getString("start"));
				
				list.add(rule);
			}
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	
	public Rule getRuleById(String ruleid){
		Rule form=new Rule();		
		DBManager db=new DBManager();
		Connection conn=db.GetConnection();
		PreparedStatement ps;
		try {
			ps = conn.prepareStatement("select ruleid,[rule],start from ruler where ruleid=?");
			ps.setString(1, ruleid);
			
			ResultSet rs=ps.executeQuery();
			while(rs.next()){
				form.setRuleid(rs.getString("ruleid"));
				form.setRule(rs.getString("rule"));
				form.setStart(rs.getString("start"));
				
			}
			ps.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
				
		return form;
	}
	
	
	
	/**
	 * 修改类
	 * @param product
	 * @return
	 */
	public boolean changeRule(Rule rule){
		boolean success=false;
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
//			Statement stm=conn.createStatement();
			PreparedStatement ps=conn.prepareStatement
			("update ruler set ruleid=?,[rule]=?,start=? where ruleid='"+rule.getRuleid()+"'");
			ps.setString(1,rule.getRuleid());
			ps.setString(2, rule.getRule());
			ps.setString(3, rule.getStart());
			
			ps.executeUpdate();
			ps.close();
			conn.commit();
			success=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
			e.printStackTrace();
			try{
				conn.rollback();
			}catch(SQLException ex){
				ex.printStackTrace();				
			}
		}
		return success;		
	}
	
	
	/**
	 * 删除类
	 * @param product
	 * @return
	 */
	public boolean deleteRule(Rule rule){
		boolean success=false;
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
//			Statement stm=conn.createStatement();
			PreparedStatement ps=conn.prepareStatement
			("delete from ruler where ruleid='"+rule.getRuleid()+"'");
			ps.executeUpdate();
			ps.close();
			conn.commit();
			success=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
			e.printStackTrace();
			try{
				conn.rollback();
			}catch(SQLException ex){
				ex.printStackTrace();				
			}
		}
		return success;
		
	}

	
	public static boolean ruleSave(Rule rule){
		boolean success=false;
		DBManager dbManager=new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
//			Statement stm=conn.createStatement();
			PreparedStatement ps=conn.prepareStatement("INSERT INTO ruler(ruleid,[rule],start)values(?,?,?)");
			ps.setString(1, rule.getRuleid());
			ps.setString(2, rule.getRule());
			ps.setString(3, rule.getStart());
			
			ps.executeUpdate();
			ps.close();
			conn.commit();
			success=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
			e.printStackTrace();
			try{
				conn.rollback();
			}catch(SQLException ex){
				ex.printStackTrace();				
			}
		}
		return success;
	
	}
	
	/**
	 * 规则类别添加，进行商品ID验证
	 */
	public boolean confirmRule(String ruleid){
		boolean success=false;
		DBManager dbManager=new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
			PreparedStatement ps=conn.prepareStatement("select * from ruler where ruleid=?");
			ps.setString(1, ruleid);
			ResultSet rs=ps.executeQuery();
			if(rs.next()){
				success=true;
			}
			conn.close();
						
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return success;		
}
}