?? rolesbean.java
字號:
package bean.roles;import java.io.UnsupportedEncodingException;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.Hashtable;import database.DBPoolManager;public class RolesBean { private ArrayList<Hashtable<String, String>> roles; private ArrayList<Hashtable<String, String>> validate; public RolesBean() { roles = new ArrayList(); validate = new ArrayList(); } public String ISOtoGB(String in){ String out = ""; if (in == null){ return ""; } else{ try {
out = new String(in.getBytes("iso-8859-1"),"gb2312"); return out; } catch (UnsupportedEncodingException e) {
e.printStackTrace(); } } return out; } public String GBtoISO(String in){ String out = ""; if (in == null){ return ""; } else{ try {
out = new String(in.getBytes("gb2312"),"iso-8859-1"); return out; } catch (UnsupportedEncodingException e) {
e.printStackTrace(); } } return out; }
public ArrayList getRoles() { roles.clear(); DBPoolManager dbpool = new DBPoolManager(); dbpool.getConnection(); try { String s = null; String sql = "select RoleID,RoleName from ManRole order by RoleID"; Statement stmt = dbpool.conn.createStatement(); ResultSet rest = stmt.executeQuery(sql); while (rest.next()) { Hashtable ht = new Hashtable(); if (rest.getString("RoleID") == null){ ht.put("RoleID", ""); } else{ s = rest.getString("RoleID"); s = s.trim(); ht.put("RoleID", s); } if (rest.getString("RoleName") == null){ ht.put("RoleName", ""); } else{ s = rest.getString("RoleName"); s = s.trim(); ht.put("RoleName", s); } roles.add(ht); } rest.close(); stmt.close(); } catch (SQLException ex) { System.err.println("Get RolesBean SQLException: " + ex.toString()); } finally { dbpool.freeConnection(); } return this.roles; } public ArrayList getRoles(int RoleID) { roles.clear(); DBPoolManager dbpool = new DBPoolManager(); dbpool.getConnection(); try { String s = null; String sql = "select RoleID,RoleName,Purview from ManRole where RoleID="+RoleID+" order by RoleID"; Statement stmt = dbpool.conn.createStatement(); ResultSet rest = stmt.executeQuery(sql); while (rest.next()) { Hashtable ht = new Hashtable(); if (rest.getString("RoleID") == null){ ht.put("RoleID", ""); } else{ s = rest.getString("RoleID"); s = s.trim(); ht.put("RoleID", s); } if (rest.getString("RoleName") == null){ ht.put("RoleName", ""); } else{ s = rest.getString("RoleName"); s = s.trim(); ht.put("RoleName", s); } if (rest.getString("Purview") == null){ ht.put("Purview", ""); } else{ s = rest.getString("Purview"); s = s.trim(); ht.put("Purview", s); } roles.add(ht); } rest.close(); stmt.close(); } catch (SQLException ex) { System.err.println("Get RolesBean SQLException: " + ex.toString()); } finally { dbpool.freeConnection(); } return this.roles; } public ArrayList getRoles(String UserCode) { roles.clear(); DBPoolManager dbpool = new DBPoolManager(); dbpool.getConnection(); try { String s = null; String sql = "select distinct a.RoleID,a.RoleName,a.Purview from ManRole a, Staff_Role b, Staff c where a.ROLEID=b.ROLEID and b.USERID=c.USERID and c.USERFLAG='1' and c.USERCODE='"+UserCode+"' order by a.RoleID"; Statement stmt = dbpool.conn.createStatement(); ResultSet rest = stmt.executeQuery(sql); while (rest.next()) { Hashtable ht = new Hashtable(); if (rest.getString("RoleID") == null){ ht.put("RoleID", ""); } else{ s = rest.getString("RoleID"); s = s.trim(); ht.put("RoleID", s); } if (rest.getString("RoleName") == null){ ht.put("RoleName", ""); } else{ s = rest.getString("RoleName"); s = s.trim(); ht.put("RoleName", s); } if (rest.getString("Purview") == null){ ht.put("Purview", ""); } else{ s = rest.getString("Purview"); s = s.trim(); ht.put("Purview", s); } roles.add(ht); } rest.close(); stmt.close(); } catch (SQLException ex) { System.err.println("Get RolesBean SQLException: " + ex.toString()); } finally { dbpool.freeConnection(); } return this.roles; } public ArrayList getRoles(int Page,int Lines) { roles.clear(); String s = null; int i = 0; int tp = 0; DBPoolManager dbpool = new DBPoolManager(); dbpool.getConnection(); try { String sql = "select RoleID, RoleName, Purview, ModifyDate, Remark from ManRole order by RoleID"; Statement stmt = dbpool.conn.createStatement(); ResultSet rest = stmt.executeQuery(sql); while (rest.next()) { Hashtable ht = new Hashtable(); tp= tp + 1; if ((tp>Page*Lines)&&(i<Lines)){ i = i + 1; if (rest.getString("RoleID") == null){ ht.put("RoleID", ""); } else{ s = rest.getString("RoleID"); s = s.trim(); ht.put("RoleID", s); } if (rest.getString("RoleName") == null){ ht.put("RoleName", ""); } else{ s = rest.getString("RoleName"); s = s.trim(); ht.put("RoleName", s); } if (rest.getString("Purview") == null){ ht.put("Purview", ""); } else{ s = rest.getString("Purview"); s = s.trim(); ht.put("Purview", s); } if (rest.getString("ModifyDate") == null){ ht.put("ModifyDate", ""); } else{ s = rest.getString("ModifyDate"); s = s.trim(); ht.put("ModifyDate", s); } if (rest.getString("Remark") == null){ ht.put("Remark", ""); } else{ s = rest.getString("Remark"); s = s.trim(); ht.put("Remark", s); } roles.add(ht); } } rest.close(); stmt.close(); } catch (SQLException ex) { System.err.println("Get RolesBean SQLException: " + ex.toString()); } finally { dbpool.freeConnection(); } return this.roles; } /* public void Method(HttpServletRequest req) { loginuser = req.getParameter("loginuser"); password = req.getParameter("password"); roleID = req.getParameter("sRoleID"); return ; }*/ public boolean isAdmin(String loginuser) { boolean res = false; DBPoolManager db = new DBPoolManager(); db.getConnection(); try { String sql = "select userid from staff where USERFLAG='1' and usercode ='" + loginuser + "'"; String userId = ""; Statement st = db.conn.createStatement(); ResultSet rs = st.executeQuery(sql); if (rs.next()) { userId = rs.getString("userid"); } rs.close(); st.close(); if (userId.length() > 0) { sql = "select roleid from staff_role where userid = " + userId; st = db.conn.createStatement(); rs = st.executeQuery(sql); while (rs.next()) { int roleId = rs.getInt("roleid"); if (roleId == 100) { res = true; break; } } rs.close(); st.close(); } } catch (SQLException ex) { res = false; System.err.println("Check Is Administrator SQLException: " + ex.toString()); } finally { db.freeConnection(); } return res; } public ArrayList getValidate(String loginuser,String password) { validate.clear(); DBPoolManager dbpool = new DBPoolManager(); dbpool.getConnection(); try { String s = null; String sql="select a.UserID,a.UserName,a.UserPwd, a.UserCode, b.OrganID, b.OrganName,b.ModifyDate as logindate from staff a, organ b where a.USERFLAG='1' and a.UserCode='" +loginuser+"' and a.UserPwd='" +password+"' and a.OrganID=b.OrganID "; Statement stmt = dbpool.conn.createStatement(); ResultSet rest = stmt.executeQuery(sql); while (rest.next()) { Hashtable ht = new Hashtable(); if (rest.getString("UserID") == null){ ht.put("UserID", ""); } else{ s = rest.getString("UserID"); s = s.trim(); ht.put("UserID", s); } if (rest.getString("UserCode") == null){ ht.put("UserCode", ""); } else{ s = rest.getString("UserCode"); s = s.trim(); ht.put("UserCode", s); } if (rest.getString("UserName") == null){ ht.put("UserName", ""); } else{ s = rest.getString("UserName"); s = s.trim(); ht.put("UserName", s); } if (rest.getString("UserPwd") == null){ ht.put("UserPwd", ""); } else{ s = rest.getString("UserPwd"); s = s.trim(); ht.put("UserPwd", s); } if (rest.getString("OrganID") == null){ ht.put("OrganID", ""); } else{ s = rest.getString("OrganID"); s = s.trim(); ht.put("OrganID", s); } if (rest.getString("OrganName") == null){ ht.put("OrganName", ""); } else{ s = rest.getString("OrganName"); s = s.trim(); ht.put("OrganName", s); } if (rest.getString("logindate") == null){ ht.put("logindate", ""); } else{ s = rest.getString("logindate"); s = s.trim(); ht.put("logindate", s); } validate.add(ht); } rest.close(); stmt.close(); } catch (SQLException ex) { System.err.println("Get RolesBean SQLException: " + ex.toString()); } finally { dbpool.freeConnection(); } return this.validate; } public ArrayList getValidate(String loginuser,String password,String roleID) { validate.clear(); DBPoolManager dbpool = new DBPoolManager(); dbpool.getConnection(); try { String s = null; String sql="select a.UserID,a.UserName,a.UserPwd, a.UserCode, b.RoleName, b.Purview, d.OrganName,b.ModifyDate as logindate from staff a, ManRole b, staff_role c, organ d where a.USERFLAG='1' and a.UserCode='" +loginuser+"' and a.UserPwd='" +password+"' and b.RoleID='"+roleID +"' and a.UserId=c.UserId " +" and b.RoleID=c.RoleID " +" and a.OrganID=d.OrganID "; Statement stmt = dbpool.conn.createStatement(); ResultSet rest = stmt.executeQuery(sql); while (rest.next()) { Hashtable ht = new Hashtable(); if (rest.getString("UserID") == null){ ht.put("UserID", ""); } else{ s = rest.getString("UserID"); s = s.trim(); ht.put("UserID", s); } if (rest.getString("UserCode") == null){ ht.put("UserCode", ""); } else{ s = rest.getString("UserCode"); s = s.trim(); ht.put("UserCode", s); } if (rest.getString("UserName") == null){ ht.put("UserName", ""); } else{ s = rest.getString("UserName"); s = s.trim(); ht.put("UserName", s); } if (rest.getString("UserPwd") == null){ ht.put("UserPwd", ""); } else{ s = rest.getString("UserPwd"); s = s.trim(); ht.put("UserPwd", s); } if (rest.getString("RoleName") == null){ ht.put("RoleName", ""); } else{ s = rest.getString("RoleName"); s = s.trim(); ht.put("RoleName", s); } if (rest.getString("Purview") == null){ ht.put("Purview", ""); } else{ s = rest.getString("Purview"); s = s.trim(); ht.put("Purview", s); } if (rest.getString("OrganName") == null){ ht.put("OrganName", ""); } else{ s = rest.getString("OrganName"); s = s.trim(); ht.put("OrganName", s); } if (rest.getString("logindate") == null){ ht.put("logindate", ""); } else{ s = rest.getString("logindate"); s = s.trim(); ht.put("logindate", s); } validate.add(ht); } rest.close(); stmt.close(); } catch (SQLException ex) { System.err.println("Get RolesBean SQLException: " + ex.toString()); } finally { dbpool.freeConnection(); } return this.validate; } }?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -