java权限的增删改查 示例代码

【实例简介】实现java权限的增删改查 

【实例截图】

【核心代码】

package com.fangjian.dao.role.impl;

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.fangjian.dao.role.IbookRoleDao;
import com.fangjian.po.role.IbookRole;
import com.fangjian.util.DbUtil;
/**
 * IbookRoleDao 接口的实现
 * @author fangjian
 *
 */
public class IbookRoleDaoImpl implements IbookRoleDao {
	//数据库连接工具
	private DbUtil dbutil = null;
	//性能最好
	private PreparedStatement ps=null;
	//连接
	private Connection conn=null;
	private final String findById="select * from IBOOK_ROLE where id = ?";
	private final String deleteByID="delete from IBOOK_ROLE where id = ?";
	private final String insert="insert into IBOOK_ROLE(ROLENAME,REMARK,ISADMIN,OWNLENGTH) values(?,?,?,?)";
	private final String edit="update IBOOK_ROLE set ROLENAME=?,REMARK = ?,ISADMIN=?,OWNLENGTH=? where id =?";
	private final String findAll="select * from IBOOK_ROLE";
	private final String deleteAll="delete from IBOOK_ROLE";
	
	@Override
	public IbookRole findById(int id) {
		conn = this.getMysqlJdbcConnection();
		IbookRole vo = null;
		try {
			ps = conn.prepareStatement(findById);
			ps.setInt(1, id);
			ResultSet rs = ps.executeQuery();
			while(rs.next()){
				vo= new IbookRole();
				vo.setId(rs.getInt("id"));
				vo.setRolename(rs.getString("rolename"));
				vo.setRemark(rs.getString("remark"));
				vo.setIsadmin(rs.getInt("isadmin"));
				vo.setOwnlenght(rs.getInt("OWNLENGTH"));
			}
		} catch (SQLException e) {
			dbutil.clearUp(conn);
			e.printStackTrace();
		}finally{
			dbutil.clearUp(conn);
		}
		return vo;
	}

	@Override
	public boolean deleteByID(int id) {
		boolean b = false;
		conn =this.getMysqlJdbcConnection();
		try{
			ps = conn.prepareStatement(deleteByID);
			ps.setInt(1, id);
			//返回影响的行数
			int i = ps.executeUpdate();
			if(i>0){
				b = true;
			}
		}catch (Exception e) {
			dbutil.clearUp(conn);
			e.printStackTrace();
		}finally{
			dbutil.clearUp(conn);
		}
		return b;
	}

	@Override
	public boolean insert(IbookRole t) {
		boolean b = false;
		conn = this.getMysqlJdbcConnection();
		try{
			ps = conn.prepareStatement(insert);
			ps.setString(1, t.getRolename());
			ps.setString(2, t.getRemark());
			ps.setInt(3, t.getIsadmin());
			ps.setInt(4, t.getOwnlenght());
			int i = ps.executeUpdate();
			if(i>0){
				b = true;
			}
		}catch (Exception e) {
			dbutil.clearUp(conn);
			e.printStackTrace();
		}finally{
			dbutil.clearUp(conn);
		}
		return b;
	}

	@Override
	public boolean edit(IbookRole t) {
		boolean b = false;
		conn = this.getMysqlJdbcConnection();
		try{
			ps = conn.prepareStatement(edit);
			ps.setString(1, t.getRolename());
			ps.setString(2, t.getRemark());
			ps.setInt(3, t.getIsadmin());
			ps.setInt(4, t.getOwnlenght());
			ps.setInt(5, t.getId());
			int i = ps.executeUpdate();
			if(i>0){
				b = true;
			}
		}catch (Exception e) {
			dbutil.clearUp(conn);
			e.printStackTrace();
		}finally{
			dbutil.clearUp(conn);
		}
		return b;
	}

	@Override
	public List<IbookRole> findAll() {
		List<IbookRole> listroles = new ArrayList<IbookRole>();
		conn = this.getMysqlJdbcConnection();
		IbookRole vo = null;
		try {
			ps = conn.prepareStatement(findAll);
			ResultSet rs = ps.executeQuery();
			while(rs.next()){
				vo= new IbookRole();
				vo.setId(rs.getInt("id"));
				vo.setRolename(rs.getString("rolename"));
				vo.setRemark(rs.getString("remark"));
				vo.setIsadmin(rs.getInt("isadmin"));
				vo.setOwnlenght(rs.getInt("OWNLENGTH"));
				listroles.add(vo);
			}
		} catch (SQLException e) {
			dbutil.clearUp(conn);
			e.printStackTrace();
		}finally{
			dbutil.clearUp(conn);
		}
		return listroles;
	}

	@Override
	public boolean deleteAll() {
		boolean b = false;
		conn =this.getMysqlJdbcConnection();
		try{
			ps = conn.prepareStatement(deleteAll);
			//返回影响的行数
			int i = ps.executeUpdate();
			if(i>0){
				b = true;
			}
		}catch (Exception e) {
			dbutil.clearUp(conn);
			e.printStackTrace();
		}finally{
			dbutil.clearUp(conn);
		}
		return b;
	}
	
	/**
	 * 获取conn链接
	 * @return
	 */
	public Connection getMysqlJdbcConnection(){
		dbutil = new DbUtil();
		conn = dbutil.getConn();
		return conn;
	}
}