package com.test;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor;
import oracle.jdbc.driver.OracleConnection;
import oracle.jdbc.driver.OracleTypes;
import oracle.sql.ARRAY;
import oracle.sql.ArrayDescriptor;
public class RoleDAO {
/*
* (non-Javadoc)
*
* @see com.whu.idao.baseinfo.impl.IRoleDAO#executeQuery(java.lang.String,
* java.lang.Object[])
*/
private ResultSet rs;
private PreparedStatement statement;
private CallableStatement cstmt;
private Connection connection;
private static final String ARRAY_VARCHAR = "ARRAY_VARCHAR";
public Connection getConnection() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = java.sql.DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.1.199:1521:orcl", "whufe",
"whufe");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public void closeConnection(Connection conn) {
}
public ArrayList<RoleModel> executeQuery(String sql) {
ArrayList<RoleModel> list = new ArrayList<RoleModel>();
try {
connection = this.getConnection();
statement = connection.prepareStatement(sql);
rs = statement.executeQuery();
while (rs.next()) {
RoleModel role = new RoleModel();
role.setRoleid(rs.getString("roleid"));
role.setRolename(rs.getString("rolename"));
role.setPerms(rs.getString("perms"));
role.setRemark(rs.getString("remark"));
list.add(role);
}
rs.close();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public ArrayList<PermModel> executeQueryPerm(String sql) {
ArrayList<PermModel> list = new ArrayList<PermModel>();
try {
connection = this.getConnection();
statement = connection.prepareStatement(sql);
rs = statement.executeQuery();
while (rs.next()) {
PermModel perm = new PermModel();
perm.setPermid(rs.getString("permid"));
perm.setPermname(rs.getString("permname"));
perm.setUrl(rs.getString("url"));
perm.setParentid(rs.getString("parentid"));
perm.setDescription(rs.getString("description"));
perm.setIsdisabled(rs.getString("isdisabled"));
list.add(perm);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public PermModel executeQueryPermModel(String sql) {
PermModel perm = new PermModel();
try {
connection = this.getConnection();
statement = connection.prepareStatement(sql);
rs = statement.executeQuery();
if (rs.next()) {
perm.setPermid(rs.getString("permid"));
perm.setPermname(rs.getString("permname"));
perm.setUrl(rs.getString("url"));
perm.setParentid(rs.getString("parentid"));
perm.setDescription(rs.getString("description"));
perm.setIsdisabled(rs.getString("isdisabled"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return perm;
}
/**
* 获取权限树 JSON串
*
* @param procedureName
* 存储过程名称
* @param permIds
* 传入存储过程的数组参数
* @return
*/
public String[] executeProcedureInitPermTree(String procName,
String[] permIds) {
String[] perms = null;
connection = this.getConnection();
// 将C3P0连接转成Oracle连接
C3P0NativeJdbcExtractor cp30NativeJdbcExtractor = new C3P0NativeJdbcExtractor();
OracleConnection conn;
try {
conn = (OracleConnection) cp30NativeJdbcExtractor
.getNativeConnection(connection);
cstmt = conn.prepareCall(procName);
ArrayDescriptor varchar2Desc = oracle.sql.ArrayDescriptor
.createDescriptor(ARRAY_VARCHAR, conn);
// 将字符串数组转换为oralce能识别的数组
ARRAY vArray = new ARRAY(varchar2Desc, conn, permIds);
cstmt = conn.prepareCall(procName);
// 返回值在java中是第一个，所以先注册输出参数
cstmt.registerOutParameter(1, OracleTypes.ARRAY, ARRAY_VARCHAR);
cstmt.setArray(2, vArray);
cstmt.execute();
ARRAY array = (ARRAY) cstmt.getArray(1);
perms = (String[]) array.getArray();
cstmt.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
return perms;
}
}
资源文件列表
ztreeTest/.classpath , 1246
ztreeTest/.mymetadata , 300
ztreeTest/.project , 1199
ztreeTest/.settings/.jsdtscope , 500
ztreeTest/.settings/org.eclipse.jdt.core.prefs , 330
ztreeTest/.settings/org.eclipse.wst.jsdt.ui.superType.container , 49
ztreeTest/.settings/org.eclipse.wst.jsdt.ui.superType.name , 6
ztreeTest/src/com/test/CompareString.java , 514
ztreeTest/src/com/test/PermModel.java , 1445
ztreeTest/src/com/test/PermService.java , 690
ztreeTest/src/com/test/RoleAction.java , 1743
ztreeTest/src/com/test/RoleDAO.java , 4587
ztreeTest/src/com/test/RoleModel.java , 708
ztreeTest/src/com/test/RoleService.java , 940
ztreeTest/src/struts.xml , 590
ztreeTest/WebRoot/index.jsp , 4868
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/api.js , 29542
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/common.css , 13907
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/common_ie6.css , 1270
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/CVS/Entries , 308
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/CVS/Repository , 51
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/CVS/Root , 43
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/apiMenu.gif , 1736
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/apiMenu.png , 3954
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/background.jpg , 36520
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/chinese.png , 1556
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/close.png , 1908
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/contact-bg.png , 177
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/CVS/Entries , 765
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/CVS/Repository , 55
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/CVS/Root , 43
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/english.png , 1356
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/header-bg.png , 148
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/lightbulb.png , 27355
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/overlay_arrow.gif , 625
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/overlay_arrow.png , 830
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/overlay_bg.png , 109
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/overlay_close_IE6.gif , 441
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/zTreeStandard.gif , 6851
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/img/zTreeStandard.png , 12573
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/jquery-1.6.2.min.js , 91572
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/jquery.ztree.core-3.3.js , 28426
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/apiCss/zTreeStyleForApi.css , 2841
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/API_cn.html , 5045
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/API_en.html , 5029
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/CVS/Entries , 9675
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/CVS/Repository , 47
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/CVS/Root , 43
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/fn.zTree.getZTreeObj.html , 1249
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/fn.zTree.init.html , 3901
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/fn.zTree._z.html , 597
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.autoParam.html , 1423
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.contentType.html , 1101
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.dataFilter.html , 1766
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.dataType.html , 954
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.enable.html , 1026
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.otherParam.html , 1360
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.type.html , 981
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.async.url.html , 1877
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeAsync.html , 1440
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeCheck.html , 1362
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeClick.html , 2478
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeCollapse.html , 1311
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeDblClick.html , 1563
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeDrag.html , 1628
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeDragOpen.html , 1429
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeDrop.html , 2381
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeEditName.html , 1500
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeExpand.html , 1301
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeMouseDown.html , 1422
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeMouseUp.html , 1408
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeRemove.html , 1312
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeRename.html , 2039
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.beforeRightClick.html , 1429
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onAsyncError.html , 1963
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onAsyncSuccess.html , 1699
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onCheck.html , 1428
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onClick.html , 2497
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onCollapse.html , 1334
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onDblClick.html , 1460
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onDrag.html , 1344
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onDrop.html , 2457
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onExpand.html , 1322
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onMouseDown.html , 1481
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onMouseUp.html , 1469
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onNodeCreated.html , 1531
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onRemove.html , 1331
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onRename.html , 1622
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.callback.onRightClick.html , 1653
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.check.autoCheckTrigger.html , 1274
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.check.chkboxType.html , 1176
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.check.chkStyle.html , 3545
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.check.enable.html , 715
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.check.nocheckInherit.html , 1152
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.check.radioType.html , 1010
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.keep.leaf.html , 876
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.keep.parent.html , 926
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.key.checked.html , 777
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.key.children.html , 666
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.key.name.html , 648
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.key.title.html , 864
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.key.url.html , 868
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.simpleData.enable.html , 1421
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.simpleData.idKey.html , 941
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.simpleData.pIdKey.html , 954
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.data.simpleData.rootPId.html , 971
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.autoExpandTrigger.html , 924
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.autoOpenTime.html , 800
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.borderMax.html , 831
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.borderMin.html , 832
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.inner.html , 2246
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.isCopy.html , 1092
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.isMove.html , 1092
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.maxShowNodeNum.html , 840
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.minMoveSize.html , 852
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.next.html , 2127
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.drag.prev.html , 2127
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.editNameSelectAll.html , 929
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.enable.html , 1473
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.removeTitle.html , 1778
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.renameTitle.html , 1844
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.showRemoveBtn.html , 1896
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.edit.showRenameBtn.html , 2293
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.treeId.html , 513
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.treeObj.html , 483
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.addDiyDom.html , 1800
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.addHoverDom.html , 1954
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.autoCancelSelected.html , 888
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.dblClickExpand.html , 1489
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.expandSpeed.html , 1080
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.fontCss.html , 1624
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.nameIsHTML.html , 914
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.removeHoverDom.html , 1919
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.selectedMulti.html , 1026
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.showIcon.html , 1413
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.showLine.html , 717
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/setting.view.showTitle.html , 1785
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.checked.html , 1674
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.checkedOld.html , 1246
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.check_Child_State.html , 1840
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.check_Focus.html , 763
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.children.html , 1249
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.chkDisabled.html , 989
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.click.html , 1182
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.diy.html , 616
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.editNameFlag.html , 752
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.getCheckStatus.html , 2844
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.getNextNode.html , 1030
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.getParentNode.html , 1007
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.getPreNode.html , 1025
ztreeTest/WebRoot/js/JQuery zTree v3.3/api/cn/treeNode.halfCheck.html , 1521
最多只能显示150条信息!
