jdbc插入和更新、查询数据

jdbc插入数据

/****
 * 添加单任务执行记录
 */
@Override
public void insertSingleJobLog(ScheduleJobBatchLogDTO singlejobbatchlog) {

	String singlejob_batchid=singlejobbatchlog.getSinglejob_batch_id();
	String job_id = singlejobbatchlog.getJob_id();
	String executor = singlejobbatchlog.getExecutor();
	String execute_log = singlejobbatchlog.getExecute_log();
	String status = singlejobbatchlog.getStatus();
	//日期格式
	java.util.Date utildate=new java.util.Date();
	SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd H:m:s");
	String starttime=sdf.format(utildate);

	String insertsql = " INSERT INTO SCHEDULE_JOB_BATCH_LOG " +
						" (SINGLEJOB_BATCH_ID, "+
						" JOB_ID , "+
						" START_TIME, "+
						" EXECUTOR, "+
						" EXECUTE_LOG, "+
						" STATUS ) " +
						" VALUES " +
						"( ?,?,to_date('"+starttime+"','YYYY-MM-DD HH24:MI:SS'),?,?,?)";
	//向数据库插入日期--- 年月日时分秒
	Connection conn = JdbcTool.getConnByJdbc();	
	PreparedStatement ps;
	try {
		ps = conn.prepareStatement(insertsql);
		ps.setString(1,singlejob_batchid );
		ps.setString(2,job_id );
//			//ps.setDate(3,new Date(new java.util.Date().getSeconds()));
		ps.setString(3,executor );
		ps.setString(4,execute_log );
		ps.setString(5,status );
		ps.execute();	
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

jdbc更新数据

@Override
public int updateStatuSingleJobLog(ScheduleJobBatchLogDTO singlejobbatchlog){
	
	String singlejob_batch_id = singlejobbatchlog.getSinglejob_batch_id();
	java.util.Date utildate=new java.util.Date();
	SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd H:m:s");
	String endtime=sdf.format(utildate);
	String updatesql = " UPDATE SCHEDULE_JOB_BATCH_LOG " +
						" SET STATUS = '1'," +
						" END_TIME = to_date('"+endtime+"','YYYY-MM-DD HH24:MI:SS')"+ 
						" WHERE SINGLEJOB_BATCH_ID ="+singlejob_batch_id;
	
	Connection conn = JdbcTool.getConnByJdbc();	
	PreparedStatement ps;
	int count=0;
	try {
		System.out.println(updatesql);
		ps = conn.prepareStatement(updatesql);
		count =ps.executeUpdate();
		System.err.println("count======"+count);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return count;
}

jdbc查询

/****
	 * 根据单任务的批次号查询任务记录
	 */
	public ScheduleJobBatchLogDTO querySingleJobLogByBatchId(String singlejobBatchId){
		String querysql = " SELECT * FROM SCHEDULE_JOB_BATCH_LOG " +
							"WHERE SINGLEJOB_BATCH_ID = '"+singlejobBatchId+"'";
		ScheduleJobBatchLogDTO singleJobLog=null;
		try {
			Connection conn = JdbcTool.getConnByJdbc();
			Statement st = conn.createStatement();
			ResultSet rs =st.executeQuery(querysql);
			while(rs.next()){				
				singleJobLog=new ScheduleJobBatchLogDTO();
				singleJobLog.setSinglejob_batch_id(singlejobBatchId);
				singleJobLog.setExecute_log(rs.getString("execute_log"));
				singleJobLog.setExecutor(rs.getString("executor"));
				singleJobLog.setJob_id(rs.getString("job_id"));
				singleJobLog.setStatus(rs.getString("status"));
				singleJobLog.setStart_time(rs.getTimestamp("start_time"));
				singleJobLog.setEnd_time(rs.getTimestamp("end_time"));
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return singleJobLog;
	}