public static void main(String[] args) { TestDBAdapter testdbadapter = new TestDBAdapter(); try { //根据日期获取不同数据库的日期转换函数,其中com.frameworkset.orm.adapter.DBFactory.DBOracle表示数据库类型常量 Date date = new Date(); System.out.println(com.frameworkset.orm.adapter.DBFactory.create(com.frameworkset.orm.adapter.DBFactory.DBOracle).getDateString(date)); //根据日期字符串获取不同数据库的日期转换函数,其中com.frameworkset.orm.adapter.DBFactory.DBOracle表示数据库类型常量 String date_str = "11-04-2006 09:27:31"; System.out.println(com.frameworkset.orm.adapter.DBFactory.create(com.frameworkset.orm.adapter.DBFactory.DBOracle).getDateString(date_str)); } catch (InstantiationException ex) { } }
/** * This method is used to format any date string. * Database can use different default date formats. * * @param date the Date to format * @return The proper date formatted String. */ public static final String getDateString(Date date,String dbName) { return SQLManager.getInstance().getDBAdapter(dbName).getDateString(date); }
/** * This method is used to format any date string. * Database can use different default date formats. * * @param date the Date to format * @return The proper date formatted String. */ public static final String getDateString(Date date) { return SQLManager.getInstance().getDBAdapter().getDateString(date); }
public static String getDBDateWithFormat(Date date,String format, String dbName) { return SQLManager.getInstance().getDBAdapter(dbName) .getDateString(date,format); }
public static String getDBDate(String date, String dbName) { return SQLManager.getInstance().getDBAdapter(dbName) .getDateString(date); }
/** * This method is used to format any date string. * Database can use different default date formats. * * @param date the Date to format * @return The proper date formatted String. */ public static final String getDateString(Date date,String dbName) { return SQLManager.getInstance().getDBAdapter(dbName).getDateString(date); }
/** * This method is used to format any date string. * Database can use different default date formats. * * @param date the Date to format * @return The proper date formatted String. */ public static final String getDateString(Date date) { return SQLManager.getInstance().getDBAdapter().getDateString(date); }
public static String getDBDateWithFormat(String date,String format) { return SQLManager.getInstance().getDBAdapter().getDateString(date,format); }
public static String getDBDate(Date date, String dbName) { return SQLManager.getInstance().getDBAdapter(dbName) .getDateString(date); }
public static final String getDateString(String date) { return SQLManager.getInstance().getDBAdapter().getDateString(date); }
public static String getDBDateWithFormat(String date,String format, String dbName) { return SQLManager.getInstance().getDBAdapter(dbName) .getDateString(date,format); }
public static String getDBDate(Date date) { return SQLManager.getInstance().getDBAdapter().getDateString(date); }
public static String getDBDate(String date) { return SQLManager.getInstance().getDBAdapter().getDateString(date); }
public static String getDBDateWithFormat(Date date,String format) { return SQLManager.getInstance().getDBAdapter().getDateString(date,format); }
protected ListInfo getDataList(String sortKey, boolean desc, long offset, int maxPagesize) { Date dt = new Date(); ListInfo listInfo = new ListInfo(); String executorID = super.accessControl.getUserID(); int j = Integer.parseInt(executorID); SchedularManagerImpl sch = new SchedularManagerImpl(); try { String sql = "select * from TD_SD_SCHEDULAR where begintime >= " + SQLManager.getInstance().getDBAdapter().getDateString(dt) + " and executor_id = " + j + " order by schedular_id desc"; listInfo = sch.getSchedularList(sql, (int) offset, maxPagesize); } catch (Exception e) { e.printStackTrace(); } return listInfo; }
protected ListInfo getDataList(String sortKey, boolean desc, long offset, int maxPagesize) { Date dt = new Date(); ListInfo listInfo = new ListInfo(); String executorID = super.accessControl.getUserID(); int j = Integer.parseInt(executorID); SchedularManagerImpl sch = new SchedularManagerImpl(); try { String sql = "select * from TD_SD_SCHEDULAR where status = 0 and endtime >= " + SQLManager.getInstance().getDBAdapter().getDateString(dt) + " and executor_id = " + j + " order by schedular_id desc"; listInfo = sch.getSchedularList(sql, (int) offset, maxPagesize); } catch (Exception e) { e.printStackTrace(); } return listInfo; }
protected ListInfo getDataList(String sortKey, boolean desc, long offset, int maxPagesize) { Date dt = new Date(); ListInfo listInfo = new ListInfo(); String executorID = super.accessControl.getUserID(); int j = Integer.parseInt(executorID); SchedularManagerImpl sch = new SchedularManagerImpl(); try { String sql = "select * from TD_SD_SCHEDULAR where status = 0 and executor_id = " + j + " " + "and endtime < " + SQLManager.getInstance().getDBAdapter().getDateString(dt) + "" + " order by begintime"; listInfo = sch.getSchedularList(sql, (int) offset, maxPagesize); } catch (Exception e) { e.printStackTrace(); } return listInfo; }
protected ListInfo getDataList(String sortKey, boolean desc, long offset, int maxPagesize) { ListInfo listInfo = new ListInfo(); String executorID = super.accessControl.getUserID(); int j= Integer.parseInt(executorID); SchedularManagerImpl sch = new SchedularManagerImpl(); String sdBeginTime = request.getParameter("beginTime"); String sdEndTime = request.getParameter("endTime"); try{ String sql = "select * from TD_SD_SCHEDULAR where status = 0 and executor_id = "+j+" " + " and begintime < "+SQLManager.getInstance().getDBAdapter().getDateString(StringUtil.stringToDate(sdEndTime))+" " + " and endtime > "+SQLManager.getInstance().getDBAdapter().getDateString(StringUtil.stringToDate(sdBeginTime))+"" + " order by begintime"; listInfo = sch.getSchedularList(sql,(int)offset,maxPagesize); }catch(Exception e){ e.printStackTrace(); } return listInfo; } protected ListInfo getDataList(String arg0, boolean arg1) {
/** * 增加便笺 */ public int addNotepaper(Notepaper notepaper) throws ManagerException { int r = -1; DBUtil db = new DBUtil(); String sql = "insert into td_sd_notepaper (content,user_id,time) values('" + notepaper.getContent() + "'," + notepaper.getUserID() + "," + SQLManager.getInstance().getDBAdapter().getDateString( notepaper.getTime()) + ")"; try { r = Integer.parseInt(db.executeInsert(sql).toString()); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } // TODO Auto-generated method stub return r; }
/** * 修改便笺的内容和时间属性 */ public boolean modifyNotepaper(Notepaper notepaper) throws ManagerException { boolean r = false; DBUtil db = new DBUtil(); String sql = "update TD_SD_Notepaper set CONTENT = '" + notepaper.getContent() + "', time = " + SQLManager.getInstance().getDBAdapter().getDateString( notepaper.getTime()) + " where NOTEPAPER_ID = " + notepaper.getNotepaparID() + ""; try { db.executeUpdate(sql); r = true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return r; }