permisservice.java

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

package com.eshop.service;

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 com.eshop.form.PermisForm;
import com.eshop.util.DBManager;

public class PermisService {
	String selectAllPermis="select * from permission";
	String selectPermisById="select * from permission where id=?";
	private String selectPermisFormById;
	/**
	 * 保存权限
	 * @param form
	 * @return
	 */
	public static boolean savePermis(PermisForm form){
		boolean success=false;
		DBManager dbManager=new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
//			Statement stm=conn.createStatement();
			PreparedStatement ps=conn.prepareStatement("INSERT INTO permission(permis_name,permis_descn)values(?,?)");
			ps.setString(1, form.getName());
			ps.setString(2, form.getDescn());
			
			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;
	} 
	/**获得所有权限
	 * @return
	 */
	public List getAllPermis(){
		List list=new ArrayList();
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
			PreparedStatement ps=conn.prepareStatement("select id,permis_name,permis_descn from permission");
			ResultSet rs=ps.executeQuery();
			PermisForm permisForm=null;
			while (rs.next()){
				permisForm=new PermisForm();
				permisForm.setId(rs.getLong("id"));
				permisForm.setName(rs.getString("permis_name"));
				permisForm.setDescn(rs.getString("permis_descn"));
				list.add(permisForm);
			}
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	/**
	 * 根据ID获得权限信息
	 * @param id
	 * @return
	 */
	public PermisForm getPermisFormById(String id){
		PermisForm PermisForm=null;
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try
		{
			PreparedStatement pstmt=conn.prepareStatement("select * from permission where id=?");
			pstmt.setString(1,id);
			ResultSet rs=pstmt.executeQuery();
          
			while(rs.next())
			{
				PermisForm=new PermisForm();
				PermisForm.setId(rs.getLong("id"));
				PermisForm.setName(rs.getString("permis_name"));
				PermisForm.setDescn(rs.getString("permis_descn"));
			}
				conn.close();
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		return PermisForm;
		
	}
	/**
	 * 修改类
	 * @param category
	 * @return
	 */
	public boolean deletePermis(PermisForm permisform){
		boolean success=false;
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
//			Statement stm=conn.createStatement();
			PreparedStatement ps=conn.prepareStatement("delete permission where id="+permisform.getId());
			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 boolean changePermis(PermisForm permisform){
		boolean success=false;
		DBManager dbManager= new DBManager();
		Connection conn=dbManager.GetConnection();
		try {
//			Statement stm=conn.createStatement();
			PreparedStatement ps=conn.prepareStatement
			("update permission set permis_name=?,permis_descn=? where id="+permisform.getId());
			
			ps.setString(1, permisform.getName());
			ps.setString(2, permisform.getDescn());
			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;
		
	}

}