📄 jdbc.java
字号:
if(dt1.charAt(4)!='/'||dt1.charAt(7)!='/')
{
if(dt1.charAt(4)!='-'||dt1.charAt(7)!='-')
return -1;
}
if(dt1.substring(0,4).compareTo("1970")<0||dt1.substring(0,4).compareTo("2070")>0)
{
return -1;
}
if(dt1.substring(5,7).compareTo("01")<0||dt1.substring(5,7).compareTo("12")>0)
{
return -1;
}
int year1=Integer.parseInt(dt1.substring(0,4));
int mon1=Integer.parseInt(dt1.substring(5,7));
if(year1%4==0&&year1%100!=0||year1%400==0)
{
if(dt1.substring(8,10).compareTo("01")<0||dt1.substring(8,10).compareTo(ynmonday[mon1-1])>0)
return -1;
}
else
{
if(dt1.substring(8,10).compareTo("01")<0||dt1.substring(8,10).compareTo(monday[mon1-1])>0)
return -1;
}
return 1;
}
public boolean checkDigital(String checkStr)
{
if(checkStr==null)
return false;
if(checkStr.length()==0)
return false;
char checkArray[] = checkStr.toCharArray();
for(int i=0;i<checkStr.length();i++)
{
if(checkArray[i]<48||checkArray[i]>57)
return false;
}
return true;
}
public String getRepTime(String strll,double diffDay)
{
String datestr;
try
{
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date date= formatter.parse(strll);
long lTime=date.getTime();
lTime=lTime+(long)(diffDay*3600*1000);
java.util.Date nowDate=new java.util.Date(lTime);
java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss") ;
datestr = df.format(nowDate) ;
}
catch (Exception ex)
{
datestr = "1970/01/01 00:00:00";
}
return datestr;
}
public String format(String format,double number)
{
String rtnStr = "";
try
{
MessageFormat mf = new MessageFormat("{0,number,"+format+"}");
Object[] objs = {new Double(number)};
rtnStr = mf.format( objs );
}
catch(Exception e)
{
rtnStr = "format error!";
}
return rtnStr;
}
public String format(String format,String number)
{
String rtnStr =number;
int f_len=format.length();
int n_len=number.length();
for(int i=0;i< f_len - n_len;i++)
rtnStr="0"+rtnStr;
return rtnStr;
}
public String getDatebaseType()
{
//读取数据库类型
InputStream is = getClass().getResourceAsStream("dbset.txt");
Properties props = new Properties();
try
{
props.load(is);
}
catch (Exception e)
{
return "oracle";
}
String datebasetype = props.getProperty("datebasetype").trim();
if(datebasetype==null)
datebasetype="oracle";
if((!datebasetype.equals("oracle"))&&(!datebasetype.equals("sybase")))
datebasetype="oracle";
return datebasetype;
}
public int length(String str)
{
if(str==null)
return 0;
if(str.equals(""))
return 0;
int len=str.length();
int all_len=0;
String temp="";
for(int i=0;i<len;i++)
{
temp=str.substring(i,i+1);
if(((temp.compareTo("!") >=0)&&(temp.compareTo("~")<=0))||(temp.compareTo(" ")==0))
all_len=all_len+1;
else
all_len=all_len+2;
}
return all_len;
}
public String substring(String srcStr,int startpos,int length)
{
int len=0;
if(srcStr==null)
return "";
len=length(srcStr);
if(startpos>=len)
return "";
if(startpos<0)
return "";
if(length==0)
return "";
String temp=""; //临时存储字符
String reStr=""; //记载返回字符串的值
int len_true=0; //记载字符串的实际长度
int temp_len=0; //
int len_pos=0; //记载字符的位置
len_true=srcStr.length();//记载字符串的实际长度
len_pos =startpos+length;//记载截取字符的终止位置
for(int i=0;i<len_true;i++)
{
temp=srcStr.substring(i,i+1);
if((temp_len <len_pos))
{
if(((temp.compareTo("!") >=0)&&(temp.compareTo("~")<=0))||(temp.compareTo(" ")==0))
{
temp_len=temp_len+1;
if(temp_len > startpos)
reStr=reStr+temp;
}
else
{
temp_len=temp_len+2;
if(temp_len > startpos+1)
reStr=reStr+temp;
}
}
else
{
return reStr;
}
}
return reStr;
}
public String getObsTable(int startDay)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
Calendar now = Calendar.getInstance();
int_year = now.get(Calendar.YEAR);
int_mon = now.get(Calendar.MONTH);
int_day = now.get(Calendar.DAY_OF_MONTH);
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 11 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 0;
}
else
{
int_mon++;
}
}
Object[] objs = {new Integer(int_year),new Integer(int_mon+1)};
rtnStr = MessageFormat.format("OBS_{0,number,0000}{1,number,00}",objs);
return rtnStr;
}
public String getObsTable(int startDay,String byDate)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
int_year = Integer.parseInt(byDate.substring(0,4));
int_mon = Integer.parseInt(byDate.substring(5,7));
int_day = Integer.parseInt(byDate.substring(8,10));
if(int_year==0||int_mon==0||int_day==0)
return "dateFormat error!";
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 12 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 1;
}
else
{
int_mon++;
}
}
Object[] objs = {new Integer(int_year),new Integer(int_mon)};
rtnStr = MessageFormat.format("OBS_{0,number,0000}{1,number,00}",objs);
return rtnStr;
}
public String getDupTable(int startDay)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
Calendar now = Calendar.getInstance();
int_year = now.get(Calendar.YEAR);
int_mon = now.get(Calendar.MONTH);
int_day = now.get(Calendar.DAY_OF_MONTH);
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 11 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 0;
}
else
{
int_mon++;
}
}
Object[] objs = {new Integer(int_year),new Integer(int_mon+1)};
rtnStr = MessageFormat.format("DUP_{0,number,0000}{1,number,00}",objs);
return rtnStr;
}
public String getRefRepTable(String current_time,int startDay)
{
if(current_time==null)
current_time="";
if(current_time.equals(""))
return "";
int int_year=Integer.parseInt(current_time.substring(0,4));
int int_mon=Integer.parseInt(current_time.substring(5,7));
int int_day=Integer.parseInt(current_time.substring(8,10));
if( int_day >= startDay && startDay > 1 )
{
if( int_mon > 11 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 1;
}
else
{
int_mon++;
}
}
String dup_name="";
if(int_mon< 10)
dup_name="rep_"+int_year+"0"+int_mon;
else
dup_name="rep_"+int_year+int_mon;
return dup_name;
}
public String getDupTable(int startDay,String byDate)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
int_year = Integer.parseInt(byDate.substring(0,4));
int_mon = Integer.parseInt(byDate.substring(5,7));
int_day = Integer.parseInt(byDate.substring(8,10));
if(int_year==0||int_mon==0||int_day==0)
return "dateFormat error!";
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 12 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 1;
}
else
{
int_mon++;
}
}
Object[] objs = {new Integer(int_year),new Integer(int_mon)};
rtnStr = MessageFormat.format("DUP_{0,number,0000}{1,number,00}",objs);
return rtnStr;
}
public String getRepTable(int startDay)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
Calendar now = Calendar.getInstance();
int_year = now.get(Calendar.YEAR);
int_mon = now.get(Calendar.MONTH);
int_day = now.get(Calendar.DAY_OF_MONTH);
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 11 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 0;
}
else
{
int_mon++;
}
}
Object[] objs = {new Integer(int_year),new Integer(int_mon+1)};
rtnStr = MessageFormat.format("REP_{0,number,0000}{1,number,00}",objs);
return rtnStr;
}
public String getRepTable(int startDay,String byDate)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
int_year = Integer.parseInt(byDate.substring(0,4));
int_mon = Integer.parseInt(byDate.substring(5,7));
int_day = Integer.parseInt(byDate.substring(8,10));
if(int_year==0||int_mon==0||int_day==0)
return "dateFormat error!";
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 12 ) // months=12 DECEMBER
{
int_year = int_year + 1;
int_mon = 1;
}
else
{
int_mon++;
}
}
Object[] objs = {new Integer(int_year),new Integer(int_mon)};
rtnStr = MessageFormat.format("REP_{0,number,0000}{1,number,00}",objs);
return rtnStr;
}
public String getVpwTable(int startDay)
{
String rtnStr = "";
int int_year = 0;
int int_mon = 0;
int int_day = 0;
Calendar now = Calendar.getInstance();
int_year = now.get(Calendar.YEAR);
int_mon = now.get(Calendar.MONTH);
int_day = now.get(Calendar.DAY_OF_MONTH);
if( int_day >= startDay && startDay > 1 )
{
if( int_mon >= 11 ) // months=12 DECEMBER
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -