预报在线：发送短信中，对用户登录的判断和区分一般信息快报和重大信息快报，以选取不同的sql获取不同的用户；

/**
* 发送短信
* 
* @param request
* @param response
* @throws Exception
*/
@RequestMapping(value = "/sendMsg")
public @ResponseBody String sendMsg(HttpServletRequest request, HttpServletResponse response) throws Exception {
ResMessage message = ResMessageFactory.getDefaultInstance(request);
// String model = URLDecoder.decode(URLDecoder.decode(request.getParameter("model"), "UTF-8"), "UTF-8");
String model = request.getParameter("msgcontent");

JSONObject jsonObject = new JSONObject();

//通过taskid，取得typeval的值，区分一般信息快报和重大信息快报，以选取不同的sql获取不同的用户；

String taskid = request.getParameter("taskid");
//判断是否为重大信息快报
String typeval = "";
String sql = "";
if(!"".equals(taskid.trim())) {
String sql1 = "select * from t_wflowreport where taskid = ?";
List<Object> dataList = new ArrayList<Object>();
dataList.add(taskid);
EntityManager entityManager = dao.getEntityManager();
List<Map<String, Object>> listcurr = ybzxTwoService.queryListMapByList(sql1, dataList, entityManager);
if(listcurr!=null && listcurr.size()>0) {
Map<String, Object> map = listcurr.get(0);
typeval = map.get("typeval".toUpperCase()) == null ? "" : map.get("typeval".toUpperCase()).toString();
}
if(typeval !=null && !"".equals(typeval.trim())) {
if("zdxi".equals(typeval)) {
sql = "select distinct mobileno from hssms.t_mobileuser where userid in (select userid from hssms.t_userandbiz  where bizid =  (select bizid from hssms.t_bizcode where bizname = '快报摘要')) and rsts = 1";
}else{
sql = "select distinct mobileno from hssms.t_mobileuser where userid in (select userid from hssms.t_userandbiz  where bizid =  (select bizid from hssms.t_bizcode where bizname = '快报摘要')) and rsts = 1 and userid not in (select userid from hssms.t_userandgroup where groupid=( select groupid from hssms.t_groupcode where groupname='市领导')) ";
}
}
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
LUser user = (LUser) request.getSession().getAttribute("user");
if (user == null) {
jsonObject.put("msg", "login");
this.setSuccess(message);
return jsonObject.toString();  //这个return一定要写
}
String username = user.getCname();
Properties pro = IndexDownloadUtils.getProperties("msg.properties");
// String[] phone = pro.get("jld").toString().split(",");
// String driver = "oracle.jdbc.driver.OracleDriver";
String url = "100.152.96.29:1521:SZ";// jdbc:oracle:thin:@
String uname = "";
String password = "";
List<String> list = new ArrayList<String>();
conn = ConnUtil.getConn("oracle", url, uname, password);
//String sql = "select distinct mobileno from hssms.t_mobileuser where userid in (select userid from hssms.t_userandbiz  where bizid =  (select bizid from hssms.t_bizcode where bizname = '快报摘要')) and rsts = 1";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
list.add(rs.getString("mobileno"));
}
String[] phone = list.toArray(new String[list.size()]);
//IndexDownloadUtils.generateMsgFile(phone, model, pro.getProperty("username"),pro.getProperty("sendport"));
jsonObject.put("msg", "OK");
this.setSuccess(message);
} catch (Exception e) {
log.error(e.getMessage(), e);
jsonObject.put("msg", "Error");
throw new Exception();
} finally {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
return jsonObject.toString();

}

在jsp中：

<script language="javascript" type="text/javascript">
function sendmsg(){
$.ajax({
type: "POST",
//url:path + "/pop/msgSend",
url:path + "/pop/sendMsg",
dataType:"json",
data:{
taskid:$("#taskid").val(),
msgcontent:$("#newmsgcontent").val()
},
success:function(data){
if(data.msg=="OK"){
alert("发送成功！");
window.close();
} else if (data.msg=="login") {

//判断如果没有登录，则弹框提示，并关闭当前窗口！
alert("请先登录！");
window.close();
} 
else{
alert("发送失败！");
}
}
});
}
</script>