function queryTrainId(){
$.getJSON("QueryTrainId.jsp", {value:$("#trainDate").val()}, function(json){
if(json != null){
var html='<ul>';
for(var i =0;i<json.jsonArray.length;i++){
html +='<li><a href="javascript:;" style="margin-left:20px;">'+json.jsonArray[i]+'</a></li>';
}
html += '</ul>';
$('#info').append(html);
$('#info ul li a').click(function(){
var $obj=$(this);
if($('#trainId').val() == ""){
$('#trainId').val($obj.text());
}else{
$('#trainId').val($('#trainId').val()+','+$obj.text());
}
})
}else{
alert("您在输入的日期当天未安排培训!");
}
});
}
package hr.hrss_dxb.views.trainManage;
import com.byd.tag.util.StringUtil;
import hr.hrss_dxb.dao.DxbTrainCourseDAO;
import hr.hrss_dxb.dao.DxbTrainCourseDAOImpl;
import hr.hrss_dxb.db.Ibatis64;
import hr.hrss_dxb.domain.DxbTrainCourse;
import hr.hrss_dxb.domain.DxbTrainCourseExample;
import hr.hrss_dxb.util.BeanUtil;
import hr.hrss_dxb.util.DateUtil;
import hr.hrss_dxb.util.FormUtil;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
public class QueryTrainId {
DxbTrainCourseDAO tcDao = new DxbTrainCourseDAOImpl(Ibatis64.getClient());
public void onLoad(Map request, Map session) {
String info =FormUtil.getParam("value", request);
DxbTrainCourseExample tce = new DxbTrainCourseExample();
DxbTrainCourseExample.Criteria tcec = tce.createCriteria();
if (!StringUtil.isEmpty(info)) {
tcec.andStartTimeGreaterThan(DateUtil.getDateFromString(info+" 00:00"));
tcec.andStartTimeLessThan(DateUtil.getDateFromString(info+" 23:59"));
}
tcec.andOptNumEqualTo(BeanUtil.getCurrentUser());
JSONObject json = new JSONObject();
List<DxbTrainCourse> dtc = null;
try {
dtc = tcDao.selectByExample(tce);
} catch (SQLException ex) {
request.put("error", ex.getMessage());
}
if (!dtc.isEmpty()) {
JSONArray jsonArray = new JSONArray();
for (int i = 0; i < dtc.size(); i++) {
jsonArray.add(i, dtc.get(i).getTrainId());
}
json.element("jsonArray", jsonArray);
BeanUtil.responseAjax(json.toString());
}
}
}
$.getJSON("QueryTrainId.jsp", {value:$("#trainDate").val()}, function(json){
if(json != null){
var html='<ul>';
for(var i =0;i<json.jsonArray.length;i++){
html +='<li><a href="javascript:;" style="margin-left:20px;">'+json.jsonArray[i]+'</a></li>';
}
html += '</ul>';
$('#info').append(html);
$('#info ul li a').click(function(){
var $obj=$(this);
if($('#trainId').val() == ""){
$('#trainId').val($obj.text());
}else{
$('#trainId').val($('#trainId').val()+','+$obj.text());
}
})
}else{
alert("您在输入的日期当天未安排培训!");
}
});
}
package hr.hrss_dxb.views.trainManage;
import com.byd.tag.util.StringUtil;
import hr.hrss_dxb.dao.DxbTrainCourseDAO;
import hr.hrss_dxb.dao.DxbTrainCourseDAOImpl;
import hr.hrss_dxb.db.Ibatis64;
import hr.hrss_dxb.domain.DxbTrainCourse;
import hr.hrss_dxb.domain.DxbTrainCourseExample;
import hr.hrss_dxb.util.BeanUtil;
import hr.hrss_dxb.util.DateUtil;
import hr.hrss_dxb.util.FormUtil;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
public class QueryTrainId {
DxbTrainCourseDAO tcDao = new DxbTrainCourseDAOImpl(Ibatis64.getClient());
public void onLoad(Map request, Map session) {
String info =FormUtil.getParam("value", request);
DxbTrainCourseExample tce = new DxbTrainCourseExample();
DxbTrainCourseExample.Criteria tcec = tce.createCriteria();
if (!StringUtil.isEmpty(info)) {
tcec.andStartTimeGreaterThan(DateUtil.getDateFromString(info+" 00:00"));
tcec.andStartTimeLessThan(DateUtil.getDateFromString(info+" 23:59"));
}
tcec.andOptNumEqualTo(BeanUtil.getCurrentUser());
JSONObject json = new JSONObject();
List<DxbTrainCourse> dtc = null;
try {
dtc = tcDao.selectByExample(tce);
} catch (SQLException ex) {
request.put("error", ex.getMessage());
}
if (!dtc.isEmpty()) {
JSONArray jsonArray = new JSONArray();
for (int i = 0; i < dtc.size(); i++) {
jsonArray.add(i, dtc.get(i).getTrainId());
}
json.element("jsonArray", jsonArray);
BeanUtil.responseAjax(json.toString());
}
}
}