xtrz.java

这个是我们做土地局的一个项目。感觉不错。欢迎下载

package huayi.gg.xtrz;
import java.sql.*;
import java.io.*;
import java.util.*;
public class xtrz {

public void DBXTRZ(String YGBH,String MKBH,String WJBH,String FWLX){
   huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
   GregorianCalendar gcalendar=new GregorianCalendar();
   String Date1;
   if ((gcalendar.get(gcalendar.MONTH)>=0)&&(gcalendar.get(gcalendar.MONTH))<9){
      Date1=gcalendar.get(gcalendar.YEAR)+"-0"+(gcalendar.get(gcalendar.MONTH)+1);
     }else{
      Date1=gcalendar.get(gcalendar.YEAR)+"-"+(gcalendar.get(gcalendar.MONTH)+1);
       }
   if ((gcalendar.get(gcalendar.DATE)>0)&&(gcalendar.get(gcalendar.DATE)<10)){
     Date1=Date1+"-0"+gcalendar.get(gcalendar.DATE);
     }else{
     Date1=Date1+"-"+gcalendar.get(gcalendar.DATE);
     }
   String Time1;
   if (gcalendar.get(gcalendar.AM_PM)==1) {
      Time1=""+(gcalendar.get(gcalendar.HOUR)+12);
     }else{
       if (gcalendar.get(gcalendar.HOUR)>9){
          Time1=""+gcalendar.get(gcalendar.HOUR);
        }else{
          Time1="0"+gcalendar.get(gcalendar.HOUR);
         }
       }
    if ((gcalendar.get(gcalendar.MINUTE)>=0)&&(gcalendar.get(gcalendar.MINUTE)<10)){
        Time1=Time1+":0"+gcalendar.get(gcalendar.MINUTE);
     }else{
        Time1=Time1+":"+gcalendar.get(gcalendar.MINUTE);
      }
    if ((gcalendar.get(gcalendar.SECOND)>=0)&&(gcalendar.get(gcalendar.SECOND)<10)){
        Time1=Time1+":0"+gcalendar.get(gcalendar.SECOND);
     }else{
        Time1=Time1+":"+gcalendar.get(gcalendar.SECOND);
}
 String td=Date1+" "+Time1; 
 String sql="insert into T_XTRZ(YGBH,RQSJ,MKBH,WJBH,FWLX) values('"+YGBH+"','"+td+"','"+MKBH+"','"+WJBH+"','"+FWLX+"')";
int aa1=myConn.executeUpdate(sql);
myConn.close();
}
}