java权限获取代码_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 findAll() {

List listroles = new ArrayList();

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;

}

}