📄 func.jsp
字号:
<%@ page import="java.io.*" %>
<%@ page import="com.stsc.util.STPoolDataSet" %>
<%@ page import="com.stsc.archive.file.*" %>
<%@ page import="com.stsc.util.STResultSet" %>
<%@ page import="java.util.Properties" %>
<%!
/***
* 形成下拉选择输入框的语句
*/
//String getBcOptions(String table,String nameField,String valueField,String flag,String order,String where,Properties dbBase)
String getBcOptions(String flag,String tablename){
String tmp="";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
//String sql1="SELECT count(*) as total FROM "+tablename;
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
//STResultSet ms = data.getSTResult(sql1,dbBase);
//ms.next();
int n=rs.getRecCount();
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString("ARCHIVETYPE");
tmp += "<option value='"+value+"'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
//包含空格，供查询的时候用
String getBcOptionsTemp(String flag,String tablename){
String tmp="";
tmp+="<option value=''>";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
String sql1="SELECT count(*) as total FROM "+tablename;
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
//STResultSet ms = data.getSTResult(sql1,dbBase);
//ms.next();
int n=rs.getRecCount();
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString("ARCHIVETYPE");
tmp += "<option value='"+value+"'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
/***
* 形成下拉选择输入框的语句
* flag:标记
* filedname:字段名称
* talbename:表名称
*/
//String getBcOptions(String table,String nameField,String valueField,String flag,String order,String where,Properties dbBase)
String getBcOptions(String flag,String filedname,String tablename){
String tmp="";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
//String sql1="SELECT count(*) as total FROM "+tablename;
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
//STResultSet ms = data.getSTResult(sql1,dbBase);
//ms.next();
int n=rs.getRecCount();
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString(filedname);
tmp += "<option value='"+value+"'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
/***
* 形成下拉选择输入框的语句
* flag:标记
* filedname:字段名称
* talbename:表名称
* where :条件说明
*/
//String getBcOptions(String table,String nameField,String valueField,String flag,String order,String where,Properties dbBase)
String getBcOptions(String flag,String filedname,String where,String tablename){
String tmp="";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
if(where!=null && !where.equals("") && !where.equals("null")){
sql=sql+" where "+where+"";
}
//System.out.println("sql============================"+sql);
//String sql1="SELECT count(*) as total FROM "+tablename;
//if(where!=null && !where.equals("") && !where.equals("null")){
// sql1=sql1+" where "+where+"";
//}
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
//STResultSet ms = data.getSTResult(sql1,dbBase);
//ms.next();
int n=rs.getRecCount();
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString(filedname);
tmp += "<option value='"+value+"'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
/***
* 形成下拉选择输入框的语句
* flag:标记
* filedname:字段名称
* talbename:表名称
* where :条件说明
* filedname1:第二个关键字段
*/
//String getBcOptions(String table,String nameField,String valueField,String flag,String order,String where,Properties dbBase)
String getBcOptions(String flag,String filedname,String where,String tablename,String filedname1){
String tmp="";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
if(where!=null && !where.equals("") && !where.equals("null")){
sql=sql+" where "+where+"";
}
//System.out.println("sql============================"+sql);
//String sql1="SELECT count(*) as total FROM "+tablename;
//if(where!=null && !where.equals("") && !where.equals("null")){
// sql1=sql1+" where "+where+"";
//}
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
//STResultSet ms = data.getSTResult(sql1,dbBase);
//ms.next();
int n=rs.getRecCount();
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString(filedname);
String value1=rs.getString(filedname1);
tmp += "<option value='"+value+"("+value1+")'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
//包含空格，供查询的时候用
String getBcOptionsTemp(String flag,String filedname,String tablename){
String tmp="";
tmp+="<option value=''>";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
//String sql1="SELECT count(*) as total FROM "+tablename;
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
//STResultSet ms = data.getSTResult(sql1,dbBase);
//ms.next();
int n=rs.getRecCount();
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString(filedname);
tmp += "<option value='"+value+"'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
//2003-5-26 tjy add
String getUserOptionsTemp(String flag,String filedname,String tablename,int roleid){
String tmp="";
tmp+="<option selected>all</option>";
Properties dbBase = new Properties();
String sql="select fUserName.* from fUserName ,fUserRole where fUserRole.EnterName = fUserName.EnterName and fUserRole.RoleID="+roleid+"" ;
// String sql="SELECT * FROM "+tablename+" where RoleID="+roleid+"" ;
System.out.println("$$$$$$$$$$$$$$$$$ sql===="+sql);
// String sql1="SELECT count(*) as total FROM "+tablename+" where RoleID="+roleid+"" ;
String sql1="select count(*) as total from fUserName ,fUserRole where fUserRole.EnterName = fUserName.EnterName and fUserRole.RoleID="+roleid+"" ;
//System.out.println("sql===================================="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet rs = data.getSTResult(sql,dbBase);
STResultSet ms = data.getSTResult(sql1,dbBase);
ms.next();
int n=ms.getInt("total");
if(rs!=null ){
for (int i=0;i<n;i++) {
rs.next();
String value=rs.getString(filedname);
tmp += "<option value='"+value+"'";
if (flag.equals(value)){
tmp += " selected";
}
tmp +=">" + value;
//tmp+="<option value=' '> ";
}
}
return tmp;
}
//2003-05-13 add by liqf,
//创建目录的方法
String Mkdir(String path) {
String msg=null;
java.io.File dir;
// 新建文件对象
dir =new java.io.File(path);
if (dir == null) {
msg = "错误原因:<BR>对不起，不能创建空目录！";
return msg;
}
if (dir.isFile()) {
msg = "错误原因:<BR>已有同名文件<B>" + dir.getAbsolutePath() + "</B>存在。";
return msg;
}
if (!dir.exists()) {
boolean result = dir.mkdirs();
if (result == false) {
msg = "错误原因:<BR>目录<b>" + dir.getAbsolutePath() + "</B>创建失败，原因不明！";
return msg;
}
// 如果成功创建目录，则无输出。
// msg ="成功创建目录: <B>" + dir.getAbsolutePath() + "</B>";
return msg;
}
else {
msg = "错误原因:<BR>目录<b>" + dir.getAbsolutePath() + "</b>已存在。";
}
return msg;
}
//2003-05-29 add by liqf,
//判断是否存在负项--即是否存在案卷
boolean getVoun(String volumnno){
Properties dbBase = new Properties();
String sql="SELECT count(*) as total FROM fVolumn where volumnno='"+volumnno+"'" ;
//System.out.println("sql00000000000000==="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet ms = data.getSTResult(sql,dbBase);
ms.next();
int n=ms.getInt("total");
//System.out.println("n========"+n);
if(n!=0){
return false;
}else{
return true;
}
}
//2003-06-02 add by liqf,
//取出字段的第一个值
String getFirst(String tablename){
String temp="";
Properties dbBase = new Properties();
String sql="SELECT * FROM "+tablename;
//System.out.println("sql00000000000000==="+sql);
STPoolDataSet data = new STPoolDataSet();
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STResultSet ms = data.getSTResult(sql,dbBase);
if(ms!=null && ms.next()){
temp=ms.getString("archivetype");
}
return temp;
}
//2003-06-06 add by liqf,
//将字符串转化为""的方法
String getFormatstring(String s){
String temp="";
if(s==null || s.equals("") || s.equals("null")){
s="";
}
temp=s;
return temp;
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -