📄 commonutil.java
字号:
/*
* Copyright (C) 2000, TOA-System Co. All rights reserved.
*/
package util;
import java.util.*;
import java.text.*;
import java.sql.*;
import def.*;
import exce.*;
import entity.*;
import dbcommon.*;
/**
* 偙偺僋儔僗偼丄擖椡偝傟偨傕偺偵懳偟偰偺僠僃僢僋僋儔僗偱偡丅<br>
* @author TOA
*
* 峏怴棜楌
* <ul>
* <li>僐儊儞僩傪捛壛
* </ul>
*/
public class CommonUtil {
ChangeField cf = new ChangeField();
Status st = new Status();
/**
* 尰嵼擔晅偺庢摼
* @return String僆僽僕僃僋僩
*/
public String getToday() {
try {
// 擔帪僼僅乕儅僢僩傪嶌惉
SimpleDateFormat sdf = new SimpleDateFormat(SISnet.DATE_FMT);
// Calendar 僆僽僕僃僋僩傪庢摼
Calendar cal = Calendar.getInstance();
// 暥帤宆偵曄峏偟丄栠偡
return (sdf.format(cal.getTime()));
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
*丂悢抣傪埬暘偟偨梋傝傪曉偡
* @param num1 尦僨乕僞
* @param num2 埬暘抣
* @return double 梋傝
*/
public double numAmari(double num1, double num2){
try {
double amari = num1%num2;
return amari;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
* 擔晅宆傪擭寧擔偵傢偗傞(堷悢丗Date乯
* @param moji 擔晅
* @return String[3] String偵曄姺偟偨抣
* String[0] YYYY偺抣
* String[1] MM偺抣
* String[2] DD偺抣
*/
public String[] dateToMdy(java.util.Date moji) {
String[] strdate = new String[3];
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
Calendar cal = Calendar.getInstance();
try {
// 擔帪偺尩枾側夝愅傪巜掕
cal.setLenient(false);
cal.setTime(moji);
// 擭寧擔偺庢摼
strdate[0] = Integer.toString(cal.get(Calendar.YEAR));
strdate[1] = Integer.toString(cal.get(Calendar.MONTH)+1);
strdate[2] = Integer.toString(cal.get(Calendar.DATE));
return strdate;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
* 擔晅宆傪擭寧擔偵傢偗傞(堷悢丗String乯
* @param moji 擔晅
* @return String[3] String偵曄姺偟偨抣
* String[0] YYYY偺抣
* String[1] MM偺抣
* String[2] DD偺抣
*/
public String[] dateToMdy(String moji) {
String[] strdate = new String[3];
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
Calendar cal = Calendar.getInstance();
try {
// 擔晅暥帤楍傪夝愅
java.util.Date dt = cf.strToDate(moji,"");
// 擔帪偺尩枾側夝愅傪巜掕
cal.setLenient(false);
cal.setTime(dt);
// 擭寧擔偺庢摼
strdate[0] = Integer.toString(cal.get(Calendar.YEAR));
strdate[1] = Integer.toString(cal.get(Calendar.MONTH)+1);
strdate[2] = Integer.toString(cal.get(Calendar.DATE));
return strdate;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
* 僶僀僩暥帤楍僇僢僩
* @param con Connection
* @param moji 愗傝庢傝尦暥帤
* @param ichi 抂悢埵抲
* @return Status 僆僽僕僃僋僩
*/
public String cutString(Connection con, String moji, String ichi){
PreparedStatement stmt = null;
ResultSet rs = null;
try {
DataAccess da = new DataAccess();
String sql = "SELECT SUBSTRB('" + moji + "',0," + ichi + ") FROM DUAL";
stmt = da.sqlSet(con,sql);
rs = da.exeQuery(stmt);
rs.next();
String st = rs.getString(1);
return st;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
} catch (Exception ex) { }
}
}
/**
* 娵傔張棟
* @param con Connection
* @param hasu 抂悢張棟(0:巐幪屲擖 1:愗傝忋偘 2:愗傝幪偰)
* @param ichi 抂悢埵抲(0:惍悢 1:彫悢戞堦埵 2:彫悢戞俀埵)
* @param num 悢抣
* @return Status 僆僽僕僃僋僩
*/
public String[] marume(Connection con, String hasu, String ichi, double num){
String sql=null;
String[] st = new String[2];
PreparedStatement stmt = null;
ResultSet rs = null;
try {
if ( hasu.equals("0") == true ) { // 巐幪屲擖
sql = "SELECT ROUND(" + num + "," + ichi + ") FROM DUAL";
} else if ( hasu.equals("1") == true ) { // 愗傝忋偘
if (num > 0.0) {
sql = "SELECT (TRUNC((POWER(10," + ichi + "))*"+ num + "+ 0.9)/(POWER(10," + ichi + "))) FROM DUAL";
} else {
sql = "SELECT (TRUNC((POWER(10," + ichi + "))*"+ num + "- 0.9)/(POWER(10," + ichi + "))) FROM DUAL";
}
} else { // 愗傝幪偰
sql = "SELECT TRUNC(" + num + "," + ichi + ") FROM DUAL";
}
DataAccess da = new DataAccess();
stmt = da.sqlSet(con,sql);
rs = da.exeQuery(stmt);
rs.next();
double dnum = rs.getDouble(1);
long lnum = rs.getLong(1);
st[0] = cf.doubleToStr(dnum,"");
st[1] = cf.longToStr(lnum,"");
System.out.println("傑傞傔慜偺抣丗" + num);
System.out.println("傑傞傔屻偺抣丗" + st[0]);
return st;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
} catch (Exception ex) { }
}
}
/**
* 擔晅宆傪擭寧擔帪偵傢偗傞(堷悢丗Date乯
* @param moji 擔晅
* @return String[4] String偵曄姺偟偨抣
* String[0] YYYY偺抣
* String[1] MM偺抣
* String[2] DD偺抣
* String[3] HH偺抣
*/
public String[] dateToYMDH(java.util.Date moji) {
String[] strdate = new String[4];
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
DecimalFormat dfmt = new DecimalFormat("00");
Calendar cal = Calendar.getInstance();
try {
// 擔帪偺尩枾側夝愅傪巜掕
cal.setLenient(false);
cal.setTime(moji);
// 擭寧擔帪偺庢摼
strdate[0] = Integer.toString(cal.get(Calendar.YEAR));
strdate[1] = Integer.toString(cal.get(Calendar.MONTH)+1);
strdate[2] = Integer.toString(cal.get(Calendar.DATE));
strdate[3] = Integer.toString(cal.get(Calendar.HOUR_OF_DAY)) + ":" +
dfmt.format(cal.get(Calendar.MINUTE));
return strdate;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
* 擔晅宆傪帪揰偵傢偗傞(堷悢丗Date乯
* @param moji 擔晅
* @return int HHMM偺抣
*/
public int gethhmm() {
int hhmm = 0;
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
DecimalFormat dfmt = new DecimalFormat("00");
Calendar cal = Calendar.getInstance();
try {
// 擔帪偺尩枾側夝愅傪巜掕
cal.setLenient(false);
// 帪揰偺庢摼
hhmm = cf.strToInt(Integer.toString(cal.get(Calendar.HOUR_OF_DAY)) + dfmt.format(cal.get(Calendar.MINUTE)));
return hhmm;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
* 擔晅偵俶儢寧壛偊偨擔晅傪栠偡(堷悢丗Date)-------Oracle偺ADD_MONTHS傪巊梡
* @param con Connection
* @param datdate 尦擔晅
* @param n 壛嶼寧悢
* @return st 嶼弌寢壥擔晅
*/
public String addMonth(Connection con, java.util.Date datdate, int n) {
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
DataAccess da = new DataAccess();
PreparedStatement stmt = null;
ResultSet rs = null;
String sql=null;
try {
//2003/8/19
//儅僱乕僕丒釼摗丂堷悢偑java.util.Date偵側偭偨偨傔偵壓婰偺SQL暥偱偺擔晅偺捛壛偑偱偒側偔側偭偨偺偱丄曄姺偟偨抣傪巊梡偡傞
//sql = "SELECT TO_CHAR(ADD_MONTHS('" + datdate + "'," + n + "),'" + SISnet.DATE_FMT + "') FROM DUAL";
java.sql.Date sqldate = new java.sql.Date(datdate.getTime());
sql = "SELECT TO_CHAR(ADD_MONTHS('" + sqldate + "'," + n + "),'" + SISnet.DATE_FMT + "') FROM DUAL";
stmt = da.sqlSet(con,sql);
rs = da.exeQuery(stmt);
String st = "";
while (rs.next()) {
st = rs.getString(1);
}
return st;
} catch (OracleException orae) {
st = orae.getStatus();
throw new OracleException(st);
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
} catch (Exception ex) { }
}
}
/**
* 擔晅偵俶儢寧壛偊偨擔晅傪栠偡(堷悢丗String)-------Oracle偺ADD_MONTHS傪巊梡
* @param con Connection
* @param datdate 尦擔晅
* @param n 壛嶼寧悢
* @return st 嶼弌寢壥擔晅
*/
public String addMonth(Connection con, String datdate, int n) {
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
DataAccess da = new DataAccess();
PreparedStatement stmt = null;
ResultSet rs = null;
String sql=null;
try {
sql = "SELECT TO_CHAR(ADD_MONTHS('" + datdate + "'," + n + "),'" + SISnet.DATE_FMT + "') FROM DUAL";
stmt = da.sqlSet(con,sql);
rs = da.exeQuery(stmt);
String st = "";
while (rs.next()) {
st = rs.getString(1);
}
return st;
} catch (OracleException orae) {
st = orae.getStatus();
throw new OracleException(st);
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
} catch (Exception ex) { }
}
}
/**
* 杮擔擔晅帪娫偺庢摼
* @return String :
*/
public String getTodayTime(){
try {
// 擔帪僼僅乕儅僢僩傪嶌惉
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
// Calendar 僆僽僕僃僋僩傪庢摼
Calendar cal = Calendar.getInstance();
// 暥帤宆偵曄峏偟丄栠偡
return (sdf.format(cal.getTime()));
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
/**
* where暥嶌惉儊僜僢僪
* @param obj1 where暥from抣
* @param obj2 where暥to抣
* @param tbname 拪弌懳徾僥乕僽儖柤
* @param whereflag true:WHERE晅壛嵪 false:WHERE晅壛枹嵪
* @param ataiflag true:悢抣 false:暥帤楍
* @param jyokenflag 0:LIKE / 1:僀僐乕儖(=) / 2:偦偺懠
*/
public String createWhere(Object obj1,Object obj2,String tbname,boolean whereflag,boolean ataiflag,int jyokenflag)
throws Exception{
String str_obj1 = ""; //obj1偺暥帤楍宆
String str_obj2 = ""; //obj2偺暥帤楍宆
String sco1 = ""; //僔儞僌儖僋僆乕僥乕僔儑儞奿擺
String sco2 = ""; //僔儞僌儖僋僆乕僥乕僔儑儞奿擺
StringBuffer where = new StringBuffer(""); //栠傝抣偺奿擺
//僆僽僕僃僋僩傪String宆偵曄峏
str_obj1 = (String)obj1;
str_obj2 = (String)obj2;
//ataiflag偺抣偵傛偭偰僔儞僌儖僋僅乕僥乕僔儑儞傪晅壛偡傞偐偟側偄偐傪寛掕
if( ataiflag ){
sco1 = "";
sco2 = "";
}else if( jyokenflag == 0 ){
sco1 = "'";
sco2 = "%'";
}else{
sco1 = "'";
sco2 = "'";
}
//椉曽偺抣偑null偺帪偼張棟傪偟側偄
if((obj1==null || str_obj1.length()==0) && (obj2==null || str_obj2.length()==0)){
}else{
if(whereflag){
where.append(" WHERE ");
} else {
where.append(" AND ");
}
if(jyokenflag == 0){
where.append(tbname).append(" LIKE ").append(sco1).append(str_obj1).append(sco2);
}else if(jyokenflag == 1){
where.append(tbname).append(" = ").append(sco1).append(str_obj1).append(sco2);
} else {
//戞堦堷悢偑null偺帪偱戞擇堷悢偑null偱側偄偲偒偼戞擇堷悢埲壓偺儗僐乕僪慖戰偡傞
if((obj1==null || str_obj1.length()==0) && obj2!=null){
where.append(tbname).append(" <= ").append(sco1).append(str_obj2).append(sco2);
//戞堦堷悢偑null偱側偔丄戞擇堷悢偑null偺帪偼戞堦堷悢埲忋偺儗僐乕僪傪慖戰偡傞
}else if(obj1!=null && (obj2==null || str_obj2.length()==0)){
where.append(tbname).append(" >=").append(sco1).append(str_obj1).append(sco2);
//椉曽偺抣偑null偱側偄
}else if(obj1!=null && obj2!=null){
where.append(tbname).append(" BETWEEN ").append(sco1).append(str_obj1).append(sco2).append(" AND ").append(sco1).append(str_obj2).append(sco2);
}
}
}
return where.toString();
}
/**
* 擔晅偵俶擔壛偊偨擔晅傪栠偡
* @param moji 擔晅(String宆)
* @param n 壛偊偨偄擔悢
* @return String 擔晅偵俶擔壛偊偨寢壥
*/
public java.util.Date addDay(java.util.Date datdate, int n) {
// 僨僼僅儖僩偺擔晅僼僅乕儅僢僩庢摼
Calendar cal = Calendar.getInstance();
java.util.Date retdate = null;
try {
// 擔帪偺尩枾側夝愅傪巜掕
cal.setLenient(false);
// 搉偝傟偨擔晅傪僙僢僩偡傞
cal.setTime(datdate);
// n擔壛偊傞
cal.add(Calendar.DATE, n);
// 栠傝抣梡曄悢傊奿擺
retdate = cal.getTime();
return retdate;
} catch (Exception e) {
throw new OriginalException(e);
} finally {
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -