网站在线客服系统(Jsp+MySql)

<%@ page language="java" contentType="text/html;charset=gbk"%> <%@ page import="java.sql.*" %> <%@ page import="common.*" %> <%@ page import="Admin.siteDbcommon" %> <%@ page import="dbopt.SQLDBOperator"%> <% request.setCharacterEncoding("gbk"); String mobile=common.getString(request.getParameter("src"),""); if (mobile.equals("")){ out.print("-1"); return; } String channel=common.getString(request.getParameter("dst"),""); if (channel.equals("")){ out.print("-1"); return; } //String smo=request.getParameter("mo"); String msg=common.getString(request.getParameter("msg"),""); if (msg.equals("")){ out.print("-2"); return; } String SMSid="660001"; String subchannel=""; int index = channel.indexOf(SMSid); if (index>=0&&channel.length()>index+6) subchannel=channel.substring(index+6); else { out.print("-2"); return; } String siteid=null,myid=null,clientid=null; siteDbcommon scop=new siteDbcommon(); SQLDBOperator op=scop.getOperator(); Connection conn=null; conn=scop.getConnection(); ResultSet rs=null; String sql="select id,siteid,myid,clientid from smlist where mobile='"+mobile+"' and subchannel="+subchannel+" and status=0"; //System.out.println(sql); rs=op.executeQuery(conn,sql); if (rs.next()){ siteid=rs.getString("siteid"); myid=rs.getString("myid"); clientid=rs.getString("clientid"); op.executeUpdate(conn,"update smlist set channel='"+channel+"',rdate=now(),replymsg='"+msg+"',status=1 where id="+rs.getString("id")); } rs.close();rs=null; scop.close();scop=null; if (siteid!=null){ op=SQLDBOperator.getInstance(); conn=op.getConnection("epocs_"+siteid); sql="update chlist set status=0 where channelno="+subchannel; op.executeUpdate(conn,sql); sql="insert into msg(senduid,recvuid,message,wdate,msgtype,ifknow) values("+myid+","+clientid+",'"+msg+"',now(),8,0)"; op.executeUpdate(conn,sql); op.close("epocs_"+siteid,conn); } out.print("0"); //ok %>