select * from huo t where date_format(t.createTime,'%Y%m%d') = '20150206';select count(*) count_,t.shuzi from huo t where date_format(t.createTime,'%Y%m%d') = '20170523' group by t.shuzi order by count_,shuziselect count(*) count_,t.shuzi from huo t group by t.shuzi order by count_,shuzi;
搞了那么久,原来是网络不通的问题.
搞了半天原来是ngrok服务器断了
ngrok服务器停了或者是ngrok版本太低了.
注册花生壳
http://domain.oray.com/?ici=console_passport_register&icn=domain_home
https://github.com/fatedier/frp/releases
package net.wxinterface;
import java.io.IOException;
import java.io.PrintWriter;
import java.security.MessageDigest;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.server.HouServer;
import wx.event.Subscribe_Unsubscribe;
import wx.in.In;
import wx.in.In_Text;
import wx.out.Out_Text;
import wx.util.Util;
public class WX_Interface extends HttpServlet {
/**
* Constructor of the object.
*/
public WX_Interface() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//�ż���ǩ��,signature����˿�������д��tocken����������е�timestamp����nonce����
String signature = request.getParameter("signature");
//ʱ���
String timestamp = request.getParameter("timestamp");
//�����
String nonce = request.getParameter("nonce");
String echostr = request.getParameter("echostr");
String tocken = "test";
try{
if(null != signature){
String[] ArrTmp = {tocken,timestamp,nonce};
Arrays.sort(ArrTmp);
StringBuffer sb = new StringBuffer();
for(int i=0;i<ArrTmp.length;i++){
sb.append(ArrTmp[i]);
}
MessageDigest md = MessageDigest.getInstance("SHA-1");
byte[] bytes = md.digest(new String(sb).getBytes());
StringBuffer buf = new StringBuffer();
for(int i=0;i<bytes.length;i++){
if(((int)bytes[i] & 0xff)<0x10){
buf.append("0");
}
buf.append(Long.toString((int) bytes[i] & 0xff,16));
}
if(signature.equals(buf.toString())){
response.getOutputStream().println(echostr);
}
}
}catch(Exception e){
e.printStackTrace();
}
System.out.println("test0");
System.out.println("doGet");
System.out.println("signature "+signature);
System.out.println("timstamp "+timestamp);
System.out.println("nonce "+nonce);
System.out.println("echostr "+echostr);
System.out.println("doGet");
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String requestStr = Util.getStringFromRequest(request);
In in = new In(requestStr);
System.out.println(in);
System.out.println(requestStr);
System.out.println("北风网");
/**
* 关注微信号时的欢迎信息
* 欢迎你关注本微信号
*/
if("event".equals(in.getMsgType())){//如果接收的消息是事件类型的话
Subscribe_Unsubscribe subscribe_Unsubscribe = new Subscribe_Unsubscribe(requestStr);
if("subscribe".equals(subscribe_Unsubscribe.getEvent())){
//Out_Text out_Text = new Out_Text(in);
Out_Text out_Text = new Out_Text(subscribe_Unsubscribe);
out_Text.setContent("欢迎你关注本微信号。本游戏说明");
out.print(out_Text.getStr());
}
//判断是text类型
}else if("text".equals(in.getMsgType())){
//得到文本类型的请求对象.
In_Text in_Text = new In_Text(requestStr);
System.out.println(in_Text);
//得到文本类型的被动响应对象.
//Out_Text out_Text = new Out_Text(in);
Out_Text out_Text = new Out_Text(in_Text);
//out_Text.setContent("这是您选择的数字"+in_Text.getContent());
/*------日期判断------------start------------------------------*/
Date date = new Date();
System.out.println(date);
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
//SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
try {
//2017年05月22日00时00分00秒
Date date1 = simpleDateFormat.parse("20170522000000");
//2017年05月23日00时00分00秒
Date date2 = simpleDateFormat.parse("20170526000000");
//判断是否是2017年05月22日
/*
* 如果是在这个区间,执行后续程序
*
* 如果不是,就给出提示,返回
*
*
*
* 活动还没开始
*
*/
if(date.before(date1)){
out_Text.setContent("活动还没开始");
out.println(out_Text.getStr());
return;
}
else if(date.after(date2)){
out_Text.setContent("活动已经结束了");
out.println(out_Text.getStr());
return;
}}catch (ParseException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
return;
}
/*-------日期判断------------------end------------------*/
/*--------------查询中奖名单--------start-------*/
if("?".equals(in_Text.getContent())){
/* StringBuffer strb = new StringBuffer();
strb.append("select");
strb.append("count(*) count_,t.shuzi");
strb.append("from huo t");
strb.append("group by t.shuzi");
strb.append("order by count_,shuzi");*/
try {
String str = HouServer.getRs();
out_Text.setContent(str);
} catch (SQLException e) {
// TODO Auto-generated catch block
out_Text.setContent("现在用户很踊跃,服务器太累了,您没有参与成功,请继续参与.");
e.printStackTrace();
}
out.println(out_Text.getStr());
return;
}
/*--------------查询中奖名单--------end-------*/
/*--------------这是验证部分-------start-------------*/
/*
* 需要验证的有:
* 必须是数字
* 必须在指定的范围内
*/
//判断,如果不是数字,抛出异常
//提示手机用户"这不是数字"
try {
Integer.parseInt(in_Text.getContent());
} catch (NumberFormatException e) {
// TODO Auto-generated catch block
//e.printStackTrace();
out_Text.setContent("这个不是数字");
System.out.println(out_Text.getStr());
out.println(out_Text.getStr());
return;
}
//判断,是否小于1000
//提示手机用户"这个数字太大了,应该小于1000"
if(1000<Integer.parseInt(in_Text.getContent())){
out_Text.setContent("这个数字太大了,应该小于1000");
System.out.println(out_Text.getStr());
out.println(out_Text.getStr());
return;
}
/*--------------这是验证部分-------end-------------*/
/*-------------验证结束--------start---------------------*/
//记录到数据库
try {//在Service层里面,这就需要处理异常了,要是这块真有数据库的异常比如说掉网或者是
//说数据库怎么样怎么着了,要给用户一个提示,不能再随随便便往外抛出异常了,要友好地提示
HouServer.saveJiLu(in.getFromUserName(),in_Text.getContent());
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
//当SQL执行异常时,给用户提示
out_Text.setContent("现在用户很踊跃,服务器太累了,您没有参与成功,请继续参与.");
out.println(out_Text.getStr());
return;
}
/*----------------------记录到数据库-----------end------------------*/
/*----------------------查询数据库,得到这个数字在数据库中的个数-------start--------------------------------------------*/
String str = "";
try {
str = HouServer.getCountByShuZi(in_Text.getContent());
out_Text.setContent("成功,"+in_Text.getContent()+"已经有"+str+"次被猜中了。");
} catch (SQLException e) {
// TODO Auto-generated catch block
out_Text.setContent("现在用户很踊跃,服务器太累了,您没有参与成功,请继续参与.");
e.printStackTrace();
}
//out_Text.setContent("成功,"+in_Text.getContent()+"已经有"+str+"次被猜中了。");
System.out.println(out_Text.getStr());
out.print(out_Text.getStr());
/*-----------查询数据库-----------------------end--------------------------------*/
}else{
Out_Text out_Text = new Out_Text(in);
out_Text.setContent("请选择一个数字");
out.print(out_Text.getStr());
}
out.flush();
out.close();
System.out.println("ok");
}
}
package net.server;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import net.db.DBUtil;
public class HouServer {
/**
* 保存记录
* @param openid
* @param shuzi
* @throws SQLException
*/
public static void saveJiLu(String openid,String shuzi) throws SQLException{//Server层的异常推荐使用向外抛出异常的方式.
//因为你要通知外面这个Server执行的有错误.
Connection conn = DBUtil.getConn();
Statement stmt = conn.createStatement();
//conn.prepareStatement(sql);//PrepareStatement是预编译/预处理,Statement就不行了
//Statement是PrepareSatement的父类/父接口.
String sql = "insert into huo (openid,shuzi) values ('"+openid+"','"+shuzi+"');";
//String sql = "insert into huo (openid,shuzi) values ('"+openid+"','"+shuzi+"')";
stmt.executeUpdate(sql);
if(null!=stmt){
stmt.close();
}
//关Connection涉及到一个数据源的问题.数据源/连接池,什么时候是真关闭(物理关闭),什么时候是逻辑关闭
//有人会用自己开发的数据源对Connection进行管理.关于数据库操作这一部分求职的时候会很容易被问到.
if(null!=conn){
conn.close();
}
}
/**
* 根据数字查询数据库.得到这个数字在数据库中的个数。
* @param shuZi
* @return
* @throws SQLException
*/
public static String getCountByShuZi(String shuZi) throws SQLException{
Date date = new Date();
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd");
String str = "";
/*得到Connection*/
Connection conn = DBUtil.getConn();
/*得到Statement*/
Statement stmt = conn.createStatement();
String sql = "select count(*) count_ from huo t where t.shuzi='"+shuZi+"' and date_format(t.createTime,'%Y%m%d')='"+simpleDateFormat.format(date)+"'";
//依赖注入的事，可能是拼接一个字符串
System.out.println(sql);
/*得到ResultSet*/
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
str = rs.getString("count_");
}
/*关闭rs*/
if(null != rs){
rs.close();
}
/*关闭stmt*/
if(null != stmt){
stmt.close();
}
/*关闭conn*/
if(null != conn){
conn.close();
}
return str;
}
public static String getRs() throws SQLException{
String str = "";
Date date = new Date();
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd");
/*
* sql语句
*
* 先按照根据结果分组
* 按照选中的次数排序
* 按照数字的大小排序
* */
StringBuffer strb = new StringBuffer();
strb.append("select ");
strb.append("count(*) count_,t.shuzi");
strb.append(" from huo t");
strb.append(" where date_format(t.createTime,'%Y%m%d') = '"+simpleDateFormat.format(date)+"'");
strb.append(" group by t.shuzi");
strb.append(" order by count_,shuzi");
//String sql = "select count(*) count_,t.shuzi from huo t where date_format(t.createTime,'%Y%m%d') = ''"+simpleDateFormat.format(date)+"'' group by t.shuzi order by count_,shuzi";
System.out.println(strb);
//得到Connection
Connection conn = DBUtil.getConn();
//得到Statement
Statement stmt = conn.createStatement();
//得到结果集
ResultSet rs = stmt.executeQuery(strb.toString());
//ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
str = rs.getString("shuzi")+" 是最接近0的, 一共被选择"+rs.getString("count_")+"次";
}
/*关闭rs*/
if(null!=rs){
rs.close();
}
/*关闭stmt*/
if(null!=stmt){
stmt.close();
}
/*关闭conn*/
if(null!=conn){
conn.close();
}
return str;
}
}
package wx.out;
import java.util.Date;
import wx.in.In;
public class Out_Video {
private String ToUserName = null;// 是 接收方帐号（收到的OpenID）
private String FromUserName =null;// 是 开发者微信号
private String CreateTime = null;// 是 消息创建时间 （整型）
private String MsgType =null;// 是 video
private String MediaId = null;//是 通过素材管理中的接口上传多媒体文件，得到的id
private String Title =null;// 否 视频消息的标题
private String Description =null;// 否 视频消息的描述
StringBuffer strb = new StringBuffer();
StringBuffer strb_ = new StringBuffer();
public Out_Video(In in) {
super();
Date date = new Date();
strb.append("<ToUserName><![CDATA["+in.getFromUserName()+"]]></ToUserName>");
strb.append("<FromUserName><![CDATA["+in.getToUserName()+"]]></FromUserName>");
//strb.append("<CreateTime>"+date.getTime()+"</CreateTime>");
strb.append("<CreateTime>"+in.getCreateTime()+"</CreateTime>");
//strb.append("<MsgType><![CDATA[video]]></MsgType>");
strb.append("<MsgType><![CDATA["+in.getMsgType()+"]]></MsgType>");
}
//public String getStr(String str){
public String getStr(){
strb_.append("<xml>");
strb_.append(strb);
strb_.append("<Video>");
strb_.append("<MediaId><![CDATA["+this.getMediaId()+"]]></MediaId>");
strb_.append("<Title><![CDATA["+this.getTitle()+"]]></Title>");
strb_.append("<Description><![CDATA["+this.getDescription()+"]]></Description>");
strb_.append("</Video>");
strb_.append("</xml>");
return strb_.toString();
}
public String getToUserName() {
return ToUserName;
}
public void setToUserName(String toUserName) {
ToUserName = toUserName;
}
public String getFromUserName() {
return FromUserName;
}
public void setFromUserName(String fromUserName) {
FromUserName = fromUserName;
}
public String getCreateTime() {
return CreateTime;
}
public void setCreateTime(String createTime) {
CreateTime = createTime;
}
public String getMsgType() {
return MsgType;
}
public void setMsgType(String msgType) {
MsgType = msgType;
}
public String getMediaId() {
return MediaId;
}
public void setMediaId(String mediaId) {
MediaId = mediaId;
}
public String getTitle() {
return Title;
}
public void setTitle(String title) {
Title = title;
}
public String getDescription() {
return Description;
}
public void setDescription(String description) {
Description = description;
}
@Override
public String toString() {
/*return "Out_Video [ToUserName=" + ToUserName + ", FromUserName="
+ FromUserName + ", CreateTime=" + CreateTime + ", MsgType="
+ MsgType + ", MediaId=" + MediaId + ", Title=" + Title
+ ", Description=" + Description + ", strb=" + strb
+ ", strb_=" + strb_ + "]";*/
return "Out_Video ["+this.getStr()+"]";
}
}
package wx.in;
public class In_Video extends In{
/* private String ToUserName =null;// 开发者微信号
private String FromUserName =null;// 发送方帐号（一个OpenID）
private String CreateTime =null;// 消息创建时间 （整型）
private String MsgType =null;// 视频为video
*/ private String MediaId =null;;// 视频消息媒体id，可以调用多媒体文件下载接口拉取数据。
private String ThumbMediaId =null;//视频消息缩略图的媒体id，可以调用多媒体文件下载接口拉取数据。
private String MsgId =null;//消息id，64位整型
public In_Video() {
super();
}
public In_Video(String requestStr) {
super();
this.setToUserName(In_Util.getStrByXML(requestStr,"ToUserName"));
this.setFromUserName(In_Util.getStrByXML(requestStr,"FromUserName"));
this.setCreateTime(In_Util.getStrByXML(requestStr,"CreateTime"));
this.setMsgType(In_Util.getStrByXML(requestStr,"MsgType"));
this.setMediaId(In_Util.getStrByXML(requestStr,"MediaId"));
this.setThumbMediaId(In_Util.getStrByXML(requestStr,"ThumbMediaId"));
this.setMsgId(In_Util.getStrByXML(requestStr,"MsgId"));
}
/*public String getToUserName() {
return ToUserName;
}
public void setToUserName(String toUserName) {
ToUserName = toUserName;
}
public String getFromUserName() {
return FromUserName;
}
public void setFromUserName(String fromUserName) {
FromUserName = fromUserName;
}
public String getCreateTime() {
return CreateTime;
}
public void setCreateTime(String createTime) {
CreateTime = createTime;
}
public String getMsgType() {
return MsgType;
}
public void setMsgType(String msgType) {
MsgType = msgType;
}*/
public String getMediaId() {
return MediaId;
}
public void setMediaId(String mediaId) {
MediaId = mediaId;
}
public String getThumbMediaId() {
return ThumbMediaId;
}
public void setThumbMediaId(String thumbMediaId) {
ThumbMediaId = thumbMediaId;
}
public String getMsgId() {
return MsgId;
}
public void setMsgId(String msgId) {
MsgId = msgId;
}
@Override
public String toString() {
return "In_Video [MediaId=" + MediaId + ", ThumbMediaId="
+ ThumbMediaId + ", MsgId=" + MsgId + "]";
}
}
package net.wxinterface;
import java.io.IOException;
import java.io.PrintWriter;
import java.security.MessageDigest;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.server.HouServer;
import wx.event.Subscribe_Unsubscribe;
import wx.in.In;
import wx.in.In_Text;
import wx.in.In_Video;
import wx.out.Out_Text;
import wx.out.Out_Video;
import wx.util.Util;
public class WX_Interface extends HttpServlet {
/**
* Constructor of the object.
*/
public WX_Interface() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//�ż���ǩ��,signature����˿�������д��tocken����������е�timestamp����nonce����
String signature = request.getParameter("signature");
//ʱ���
String timestamp = request.getParameter("timestamp");
//�����
String nonce = request.getParameter("nonce");
String echostr = request.getParameter("echostr");
String tocken = "test";
try{
if(null != signature){
String[] ArrTmp = {tocken,timestamp,nonce};
Arrays.sort(ArrTmp);
StringBuffer sb = new StringBuffer();
for(int i=0;i<ArrTmp.length;i++){
sb.append(ArrTmp[i]);
}
MessageDigest md = MessageDigest.getInstance("SHA-1");
byte[] bytes = md.digest(new String(sb).getBytes());
StringBuffer buf = new StringBuffer();
for(int i=0;i<bytes.length;i++){
if(((int)bytes[i] & 0xff)<0x10){
buf.append("0");
}
buf.append(Long.toString((int) bytes[i] & 0xff,16));
}
if(signature.equals(buf.toString())){
response.getOutputStream().println(echostr);
}
}
}catch(Exception e){
e.printStackTrace();
}
System.out.println("test0");
System.out.println("doGet");
System.out.println("signature "+signature);
System.out.println("timstamp "+timestamp);
System.out.println("nonce "+nonce);
System.out.println("echostr "+echostr);
System.out.println("doGet");
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String requestStr = Util.getStringFromRequest(request);
In in = new In(requestStr);
System.out.println(in);
System.out.println(requestStr);
System.out.println("北风网");
/**
* 关注微信号时的欢迎信息
* 欢迎你关注本微信号
*/
if("event".equals(in.getMsgType())){//如果接收的消息是事件类型的话
Subscribe_Unsubscribe subscribe_Unsubscribe = new Subscribe_Unsubscribe(requestStr);
if("subscribe".equals(subscribe_Unsubscribe.getEvent())){
//Out_Text out_Text = new Out_Text(in);
Out_Text out_Text = new Out_Text(subscribe_Unsubscribe);
out_Text.setContent("欢迎你关注本微信号。本游戏说明");
out.print(out_Text.getStr());
}
//判断是text类型
}else if("text".equals(in.getMsgType())){
//得到文本类型的请求对象.
In_Text in_Text = new In_Text(requestStr);
System.out.println(in_Text);
//得到文本类型的被动响应对象.
//Out_Text out_Text = new Out_Text(in);
Out_Text out_Text = new Out_Text(in_Text);
//out_Text.setContent("这是您选择的数字"+in_Text.getContent());
/*------日期判断------------start------------------------------*/
Date date = new Date();
System.out.println(date);
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
//SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
try {
//2017年05月22日00时00分00秒
Date date1 = simpleDateFormat.parse("20170522000000");
//2017年05月23日00时00分00秒
Date date2 = simpleDateFormat.parse("20170526000000");
//判断是否是2017年05月22日
/*
* 如果是在这个区间,执行后续程序
*
* 如果不是,就给出提示,返回
*
*
*
* 活动还没开始
*
*/
if(date.before(date1)){
out_Text.setContent("活动还没开始");
out.println(out_Text.getStr());
return;
}
else if(date.after(date2)){
out_Text.setContent("活动已经结束了");
out.println(out_Text.getStr());
return;
}}catch (ParseException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
return;
}
/*-------日期判断------------------end------------------*/
/*--------------查询中奖名单--------start-------*/
if("?".equals(in_Text.getContent())){
/* StringBuffer strb = new StringBuffer();
strb.append("select");
strb.append("count(*) count_,t.shuzi");
strb.append("from huo t");
strb.append("group by t.shuzi");
strb.append("order by count_,shuzi");*/
try {
String str = HouServer.getRs();
out_Text.setContent(str);
} catch (SQLException e) {
// TODO Auto-generated catch block
out_Text.setContent("现在用户很踊跃,服务器太累了,您没有参与成功,请继续参与.");
e.printStackTrace();
}
out.println(out_Text.getStr());
return;
}
/*--------------查询中奖名单--------end-------*/
/*--------------这是验证部分-------start-------------*/
/*
* 需要验证的有:
* 必须是数字
* 必须在指定的范围内
*/
//判断,如果不是数字,抛出异常
//提示手机用户"这不是数字"
try {
Integer.parseInt(in_Text.getContent());
} catch (NumberFormatException e) {
// TODO Auto-generated catch block
//e.printStackTrace();
out_Text.setContent("这个不是数字");
System.out.println(out_Text.getStr());
out.println(out_Text.getStr());
return;
}
//判断,是否小于1000
//提示手机用户"这个数字太大了,应该小于1000"
if(1000<Integer.parseInt(in_Text.getContent())){
out_Text.setContent("这个数字太大了,应该小于1000");
System.out.println(out_Text.getStr());
out.println(out_Text.getStr());
return;
}
/*--------------这是验证部分-------end-------------*/
/*-------------验证结束--------start---------------------*/
//记录到数据库
try {//在Service层里面,这就需要处理异常了,要是这块真有数据库的异常比如说掉网或者是
//说数据库怎么样怎么着了,要给用户一个提示,不能再随随便便往外抛出异常了,要友好地提示
HouServer.saveJiLu(in.getFromUserName(),in_Text.getContent());
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
//当SQL执行异常时,给用户提示
out_Text.setContent("现在用户很踊跃,服务器太累了,您没有参与成功,请继续参与.");
out.println(out_Text.getStr());
return;
}
/*----------------------记录到数据库-----------end------------------*/
/*----------------------查询数据库,得到这个数字在数据库中的个数-------start--------------------------------------------*/
String str = "";
try {
str = HouServer.getCountByShuZi(in_Text.getContent());
out_Text.setContent("成功,"+in_Text.getContent()+"已经有"+str+"次被猜中了。");
} catch (SQLException e) {
// TODO Auto-generated catch block
out_Text.setContent("现在用户很踊跃,服务器太累了,您没有参与成功,请继续参与.");
e.printStackTrace();
}
//out_Text.setContent("成功,"+in_Text.getContent()+"已经有"+str+"次被猜中了。");
System.out.println(out_Text.getStr());
out.print(out_Text.getStr());
/*-----------查询数据库-----------------------end--------------------------------*/
}else{
if("video".equals(in.getMsgType())){
In_Video in_Video = new In_Video(requestStr);
System.out.println(in_Video);
Out_Video out_video = new Out_Video(in_Video);
out_video.setMediaId(in_Video.getMediaId());
System.out.println(out_video.toString());
System.out.println(out_video.getStr());
out.println(out_video.getStr());
}else{
Out_Text out_Text = new Out_Text(in);
out_Text.setContent("请选择一个数字");
out.print(out_Text.getStr());
}
}
out.flush();
out.close();
System.out.println("ok");
}
}
116
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
