工作总结

来源：互联网发布：淘宝会员登录编辑：程序博客网时间：2024/04/29 03:24

Tomcat经常遇到端口被占用的问题

1.cmd中输入netstat -ano找到端口被占用的进程的pid，例如：

2.输入 taskkill -pid 4888 /f，就可以将s该进程杀掉了

Html导出为excel文件：

页面文件中添加：

function foremp() {

var a=$('#cdate').val();

var b=$('#bondcd').val();

var c=$('#accouttp').val();

var d=$('#svaluedate').val();

var e=$('#evaluedate').val();

var f=$('#bondtp').val();

var g=$('#nominalrate').val();

var h=$('#sduedate').val();

var i=$('#eduedate').val();

var j=$('#bondshortnm').val();

var k=$('#remainperiod').val();

var l=$('#first').val();

var m=$('#second').val();

var n=$('#third').val();

Var url="${ctx}/account_day/800201-1-1?cdate="+a+"&bondcd="+b+"&accouttp="+c+"&svaluedate="+d+"&evaluedate=" +e+"&bondtp="+f+"&nominalrate="+g+"&sduedate="+h+"&eduedate="+i+"&bondshortnm=" +j+"&remainperiod="+k+"&first="+l+"&second="+m+"&third="+n+"&tagpath="+window.location.href;

window.location.href = (url);

}

查询条件添加id，添加按钮，指向foremp方法：

后台代码：

@ResponseBody

@RequestMapping(value = "/account_day/800201-1", method = RequestMethod.GET)

public void que(HttpServletRequest request,HttpServletResponse response,

@RequestParam(value = "cdate", required = true, defaultValue = "") String cdate,

@RequestParam(value = "bondcd", required = true, defaultValue = "") String bondcd,

@RequestParam(value = "accouttp", required = true, defaultValue = "") String accouttp,

@RequestParam(value = "svaluedate", required = true, defaultValue = "") String svaluedate,

@RequestParam(value = "evaluedate", required = true, defaultValue = "") String evaluedate,

@RequestParam(value = "bondtp", required = true, defaultValue = "") String bondtp,

@RequestParam(value = "nominalrate", required = true, defaultValue = "") String nominalrate,

@RequestParam(value = "sduedate", required = true, defaultValue = "") String sduedate,

@RequestParam(value = "eduedate", required = true, defaultValue = "") String eduedate,

@RequestParam(value = "bondshortnm", required = true, defaultValue = "") String bondshortnm,

@RequestParam(value = "remainperiod", required = true, defaultValue = "") String remainperiod,

@RequestParam(value = "first", required = true, defaultValue = "") String first,

@RequestParam(value = "second", required = true, defaultValue = "") String second,

@RequestParam(value = "third", required = true, defaultValue = "") String third,

@RequestParam(value = "tagpath", required = true, defaultValue = "") String tagpath) throws ParseException, IOException {

Map<String,String> param = new HashMap<String,String>();

param.put("cdate", cdate);

param.put("bondcd", bondcd);

param.put("accouttp", accouttp);

param.put("svaluedate", svaluedate);

param.put("evaluedate", evaluedate);

param.put("bondtp", bondtp);

param.put("nominalrate", nominalrate);

param.put("sduedate", sduedate);

param.put("eduedate", eduedate);

param.put("bondshortnm", bondshortnm);

param.put("remainperiod", remainperiod);

param.put("first", first);

param.put("second", second);

param.put("third", third);

GuidCreator Gc=new GuidCreator();

String filename=Gc.createNewGuid(GuidCreator.AfterMD5);

String filepath=request.getServletContext().getRealPath("/download")+"/"+filename;

String path = HtmlTab2Xls.Tab2Xls(tagpath, param, filepath);

response.sendRedirect(request.getContextPath()+"/download/"+filename+".xls");

}

@ResponseBody

@RequestMapping(value = "/account_day/800600-1", method = RequestMethod.GET)

public void query(HttpServletRequest request,HttpServletResponse response,

@RequestParam(value = "cdate", required = true, defaultValue = "") String cdate,

@RequestParam(value = "bondcd", required = true, defaultValue = "") String bondcd,

@RequestParam(value = "accouttp", required = true, defaultValue = "") String accouttp,

@RequestParam(value = "svaluedate", required = true, defaultValue = "") String svaluedate,

@RequestParam(value = "evaluedate", required = true, defaultValue = "") String evaluedate,

@RequestParam(value = "bondtp", required = true, defaultValue = "") String bondtp,

@RequestParam(value = "bonddepositplace", required = true, defaultValue = "") String bonddepositplace,

@RequestParam(value = "sduedate", required = true, defaultValue = "") String sduedate,

@RequestParam(value = "eduedate", required = true, defaultValue = "") String eduedate,

@RequestParam(value = "deadline", required = true, defaultValue = "") String deadline,

@RequestParam(value = "remainperiod", required = true, defaultValue = "") String remainperiod,

@RequestParam(value = "interestpaymenttp", required = true, defaultValue = "") String interestpaymenttp,

@RequestParam(value = "bstrtype", required = true, defaultValue = "") String bstrtype,

@RequestParam(value = "iscontainoption", required = true, defaultValue = "") String iscontainoption,

@RequestParam(value = "bondcreditrat", required = true, defaultValue = "") String bondcreditrat,

@RequestParam(value = "pyatyiclassify", required = true, defaultValue = "") String pyatyiclassify,

@RequestParam(value = "first", required = true, defaultValue = "") String first,

@RequestParam(value = "second", required = true, defaultValue = "") String second,

@RequestParam(value = "third", required = true, defaultValue = "") String third,

@RequestParam(value = "tagpath", required = true, defaultValue = "") String tagpath) throws ParseException, IOException {

Map<String,String> param = new HashMap<String,String>();

param.put("cdate", cdate);

param.put("bondcd", bondcd);

param.put("accouttp", accouttp);

param.put("svaluedate", svaluedate);

param.put("evaluedate", evaluedate);

param.put("bondtp", bondtp);

param.put("bonddepositplace", bonddepositplace);

param.put("sduedate", sduedate);

param.put("eduedate", eduedate);

param.put("deadline", deadline);

param.put("remainperiod", remainperiod);

param.put("interestpaymenttp", interestpaymenttp);

param.put("bstrtype", bstrtype);

param.put("iscontainoption", iscontainoption);

param.put("bondcreditrat", bondcreditrat);

param.put("pyatyiclassify", pyatyiclassify);

param.put("first", first);

param.put("second", second);

param.put("third", third);

GuidCreator Gc=new GuidCreator();

String filename=Gc.createNewGuid(GuidCreator.AfterMD5);

String filepath=request.getServletContext().getRealPath("/download")+"/"+filename;

String path = HtmlTab2Xls.Tab2Xls(tagpath, param, filepath);

response.sendRedirect(request.getContextPath()+"/download/"+filename+".xls");

}

Excel文件导入:

前台页面写：

<form action="<%=cpath%>/bond/bondvaluationinfo/importExcel?r=${returnview}" method="post" enctype="multipart/form-data" id="excelForm">

<span>选择信息文件：</span>

</form>

</div>

后台：

/**

* excel导入

* @param request

* @param response

* @param uploadFile

* @param returnview

* @return

@RequestMapping(value = "/bond/bondvaluationinfo/importExcel", method = RequestMethod.POST)

public ModelAndView exportExcel(HttpServletRequest request,HttpServletResponse response,

@RequestParam(value = "uploadFile", required = false) MultipartFile uploadFile,

@RequestParam(value = "r", required = true, defaultValue = "") String returnview) {

List<BondValuationinfoxls> infos = new ArrayList<BondValuationinfoxls>();

try {

InputStream fis = uploadFile.getInputStream();

infos = ExcelView.importBondValuationinfoControllerByPoi(fis);

} catch (IOException ex) {

Logger.getLogger(BondValuationinfoController.class.getName()).log(Level.SEVERE, null, ex);

}

OValuationinformationMapper odbtmapper = this.bondService.getMapper(OValuationinformationMapper.class);

OValuationinformation odbt ;

String listgmktcd = null;

List<OValuationinformation> list = new ArrayList<OValuationinformation> ();

JedaUser u = (JedaUser) request.getSession().getAttribute(Constants.USERSESSIONID);

for(BondValuationinfoxls xls:infos){

odbt = new OValuationinformation();

if( null != u){

odbt.setWriter(u.getUserId());

}

odbt.setCheckstate("0");//设置默认复核状态

odbt.setDatasource("1");

odbt.setBdid(xls.getBdId());

odbt.setBdshrtnm(xls.getBdShrtNm());

odbt.setValtndt(xls.getValtnDt());

odbt.setListgmkt(xls.getListgMkt());

listgmktcd = this.bondService.getOValuationinformationListgmktcd(xls.getListgMkt());

if(listgmktcd == null)

{

toerrorFlag = 1;

break;

}

else{

odbt.setListgmktcd(listgmktcd);

}

odbt.setYrstomtrty(new BigDecimal(xls.getYrsToMtrty()));

odbt.setValtddrtypricintrday(new BigDecimal(xls.getValtdDrtyPricIntrDay()));

odbt.setAcrdintrstintrday(new BigDecimal(xls.getAcrdIntrstIntrDay()));

odbt.setValtdclnpric(new BigDecimal(xls.getValtdClnPric()));

odbt.setValtdyld(new BigDecimal(xls.getValtdYld()));

odbt.setValtdmodfddrtn(new BigDecimal(xls.getValtdModfdDrtn()));

odbt.setValtdconexty(new BigDecimal(xls.getValtdConexty()));

odbt.setValtdpvbp(new BigDecimal(xls.getValtdPVBP()));

odbt.setValtdsprddrtn(new BigDecimal(xls.getValtdSprdDrtn()));

odbt.setValtdsprdconexty(new BigDecimal(xls.getValtdSprdConexty()));

odbt.setMktdrtypric(new BigDecimal(xls.getMktDrtyPric()));

odbt.setMktclnpric(new BigDecimal(xls.getMktClnPric()));

odbt.setMktyld(new BigDecimal(xls.getMktYld()));

odbt.setMktmodfddrtn(new BigDecimal(xls.getMktModfdDrtn()));

odbt.setMktconexty(new BigDecimal(xls.getMktConexty()));

odbt.setMktpvbp(new BigDecimal(xls.getMktPVBP()));

odbt.setMktsprddrtn(new BigDecimal(xls.getMKTSprdDrtn()));

odbt.setMktsprdconexty(new BigDecimal(xls.getMKTSprdConexty()));

odbt.setRelibity(xls.getRelibity());

odbt.setValtdratedrtn(new BigDecimal(xls.getValtdRateDrtn()));

odbt.setValtdrateconexty(new BigDecimal(xls.getValtdRateConexty()));

odbt.setMktratedrtn(new BigDecimal(xls.getMktRateDrtn()));

odbt.setMktrateconexty(new BigDecimal(xls.getMktRateConexty()));

odbt.setEnddayvaltddrtypric(new BigDecimal(xls.getEndDayValtdDrtyPric()));

odbt.setEnddayacrdintrst(new BigDecimal(xls.getEndDayAcrdIntrst()));

odbt.setRmngprncpl(new BigDecimal(xls.getRmngPrncpl()));

odbt.setDcsyl(new BigDecimal(xls.getDCSYL()));

odbt.setWritetime(new Date());

odbtmapper.insert(odbt);

list.add(odbt);

}

this.addSLog(request, u, "导入", "信息", "成功");

ModelAndView mv = new ModelAndView();

mv.addObject("result",list);

mv.setViewName("bond/bondvaluationinfo/OValuationinformation_Select");

return mv;

}

0 0