下载资源后端资源详情
eastnet_wechat.zip
大小:2.76MB
价格:45积分
下载量:0
评分:
5.0
上传者:fanguoddd
更新日期:2025-09-22

servlet+jdbc实现微信公众号开发 源码下载

资源文件列表(大概)

文件名
大小
eastnet_wechat/
-
eastnet_wechat/.classpath
878B
eastnet_wechat/.myeclipse/
-
eastnet_wechat/.mymetadata
311B
eastnet_wechat/.project
1.59KB
eastnet_wechat/.settings/
-
eastnet_wechat/.settings/.jsdtscope
500B
eastnet_wechat/.settings/org.eclipse.core.resources.prefs
88B
eastnet_wechat/.settings/org.eclipse.jdt.core.prefs
364B
eastnet_wechat/.settings/org.eclipse.wst.common.component
476B
eastnet_wechat/.settings/org.eclipse.wst.common.project.facet.core.xml
252B
eastnet_wechat/.settings/org.eclipse.wst.jsdt.ui.superType.container
49B
eastnet_wechat/.settings/org.eclipse.wst.jsdt.ui.superType.name
6B
eastnet_wechat/src/
-
eastnet_wechat/src/com/
-
eastnet_wechat/src/com/eastnet/
-
eastnet_wechat/src/com/eastnet/wechat/
-
eastnet_wechat/src/com/eastnet/wechat/main/
-
eastnet_wechat/src/com/eastnet/wechat/main/MenuManager.java
4.35KB
eastnet_wechat/src/com/eastnet/wechat/message/
-
eastnet_wechat/src/com/eastnet/wechat/message/req/
-
eastnet_wechat/src/com/eastnet/wechat/message/req/BaseMessage.java
1.48KB
eastnet_wechat/src/com/eastnet/wechat/message/req/ImageMessage.java
311B
eastnet_wechat/src/com/eastnet/wechat/message/req/LinkMessage.java
644B
eastnet_wechat/src/com/eastnet/wechat/message/req/LocationMessage.java
869B
eastnet_wechat/src/com/eastnet/wechat/message/req/TextMessage.java
338B
eastnet_wechat/src/com/eastnet/wechat/message/req/VoiceMessage.java
485B
eastnet_wechat/src/com/eastnet/wechat/message/resp/
-
eastnet_wechat/src/com/eastnet/wechat/message/resp/Article.java
1.03KB
eastnet_wechat/src/com/eastnet/wechat/message/resp/BaseMessage.java
1.12KB
eastnet_wechat/src/com/eastnet/wechat/message/resp/Music.java
946B
eastnet_wechat/src/com/eastnet/wechat/message/resp/MusicMessage.java
321B
eastnet_wechat/src/com/eastnet/wechat/message/resp/NewsMessage.java
650B
eastnet_wechat/src/com/eastnet/wechat/message/resp/TextMessage.java
348B
eastnet_wechat/src/com/eastnet/wechat/pojo/
-
eastnet_wechat/src/com/eastnet/wechat/pojo/AccessToken.java
534B
eastnet_wechat/src/com/eastnet/wechat/pojo/Button.java
242B
eastnet_wechat/src/com/eastnet/wechat/pojo/CommonButton.java
437B
eastnet_wechat/src/com/eastnet/wechat/pojo/ComplexButton.java
318B
eastnet_wechat/src/com/eastnet/wechat/pojo/Menu.java
260B
eastnet_wechat/src/com/eastnet/wechat/pojo/ViewButton.java
347B
eastnet_wechat/src/com/eastnet/wechat/service/
-
eastnet_wechat/src/com/eastnet/wechat/service/EastnetService.java
8.78KB
eastnet_wechat/src/com/eastnet/wechat/servlet/
-
eastnet_wechat/src/com/eastnet/wechat/servlet/CreateMenuServlet.java
5.63KB
eastnet_wechat/src/com/eastnet/wechat/servlet/EastnetServlet.java
2.26KB
eastnet_wechat/src/com/eastnet/wechat/test/
-
eastnet_wechat/src/com/eastnet/wechat/test/Test.java
1.76KB
eastnet_wechat/src/com/eastnet/wechat/utils/
-
eastnet_wechat/src/com/eastnet/wechat/utils/DBCPConnection.java
1.11KB
eastnet_wechat/src/com/eastnet/wechat/utils/MessageUtil.java
4.61KB
eastnet_wechat/src/com/eastnet/wechat/utils/MyX509TrustManager.java
688B
eastnet_wechat/src/com/eastnet/wechat/utils/OpenDBConnection.java
2.16KB
eastnet_wechat/src/com/eastnet/wechat/utils/OperatorUtil.java
12.57KB
eastnet_wechat/src/com/eastnet/wechat/utils/SignUtil.java
2.53KB
eastnet_wechat/src/com/eastnet/wechat/utils/WeixinUtil.java
6.09KB
eastnet_wechat/src/com/eastnet/wechat/weChat
191B
eastnet_wechat/src/dbcp.properties
595B
eastnet_wechat/WebRoot/
-
eastnet_wechat/WebRoot/index.jsp
922B
eastnet_wechat/WebRoot/META-INF/
-
eastnet_wechat/WebRoot/META-INF/MANIFEST.MF
36B
eastnet_wechat/WebRoot/success.jsp
840B
eastnet_wechat/WebRoot/WEB-INF/
-
eastnet_wechat/WebRoot/WEB-INF/classes/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/main/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/main/MenuManager.class
3.22KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/BaseMessage.class
1.65KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/ImageMessage.class
614B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/LinkMessage.class
1009B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/LocationMessage.class
1.21KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/TextMessage.class
605B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/req/VoiceMessage.class
815B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/Article.class
1.14KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/BaseMessage.class
1.44KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/Music.class
1.17KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/MusicMessage.class
676B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/NewsMessage.class
1.09KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/message/resp/TextMessage.class
618B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/AccessToken.class
773B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/Button.class
541B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/CommonButton.class
752B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/ComplexButton.class
639B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/Menu.class
586B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/pojo/ViewButton.class
746B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/service/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/service/EastnetService.class
4.51KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/servlet/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/servlet/CreateMenuServlet.class
3.68KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/servlet/EastnetServlet.class
2.01KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/test/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/test/Test.class
2.21KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/
-
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/DBCPConnection.class
1.19KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/MessageUtil$1$1.class
1.37KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/MessageUtil$1.class
759B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/MessageUtil.class
3.85KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/MyX509TrustManager.class
903B
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/OpenDBConnection.class
2.42KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/OperatorUtil.class
9.32KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/SignUtil.class
3.13KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/utils/WeixinUtil.class
5.12KB
eastnet_wechat/WebRoot/WEB-INF/classes/com/eastnet/wechat/weChat
191B
eastnet_wechat/WebRoot/WEB-INF/classes/dbcp.properties
1.31KB
eastnet_wechat/WebRoot/WEB-INF/lib/
-
eastnet_wechat/WebRoot/WEB-INF/lib/com.springsource.org.apache.commons.logging-1.1.1.jar
60.02KB
eastnet_wechat/WebRoot/WEB-INF/lib/com.springsource.org.apache.commons.pool-1.5.3.jar
94.85KB
eastnet_wechat/WebRoot/WEB-INF/lib/commons-beanutils-1.7.0.jar
184.25KB
eastnet_wechat/WebRoot/WEB-INF/lib/commons-collections-3.1.jar
546.26KB
eastnet_wechat/WebRoot/WEB-INF/lib/commons-dbcp-1.4.jar
156.76KB
eastnet_wechat/WebRoot/WEB-INF/lib/commons-lang-2.3.jar
239.53KB
eastnet_wechat/WebRoot/WEB-INF/lib/dom4j-1.6.1.jar
306.54KB
eastnet_wechat/WebRoot/WEB-INF/lib/ezmorph-1.0.3.jar
76KB
eastnet_wechat/WebRoot/WEB-INF/lib/json-lib-2.4-jdk15.jar
155.39KB
eastnet_wechat/WebRoot/WEB-INF/lib/mysql-connector-java-5.1.7-bin.jar
693.28KB
eastnet_wechat/WebRoot/WEB-INF/lib/slf4j-log4j12-1.7.7.jar
8.66KB
eastnet_wechat/WebRoot/WEB-INF/lib/xmlpull_1_0_5.jar
5.93KB
eastnet_wechat/WebRoot/WEB-INF/lib/xstream-1.4.jar
481.17KB
eastnet_wechat/WebRoot/WEB-INF/web.xml
1.28KB

资源内容介绍

原生servlet+jdbc实现微信公众号开发,包含自定义菜单等。
package com.eastnet.wechat.utils;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import com.mysql.jdbc.StringUtils;public class OperatorUtil { /** * 获取账号绑定状态 * @param fromUserName * @return */public String getBindStatus(String fromUserName){Connection conn=null; PreparedStatement ps=null; ResultSet rs=null;conn=new DBCPConnection().getConnection();String selectSql="select * from crm_stu_wechat where open_id='"+fromUserName+"'";if(conn==null){return "连接数据库失败";}else{try {ps=conn.prepareStatement(selectSql);rs=ps.executeQuery();if(rs.next()){return "用户名已绑定";}else{return "请输入\"用户名绑定\"+登录用户名 如:用户名绑定fangw";}} catch (SQLException e) {return "查询数据库失败";}finally{closeConnection(conn,ps,rs);}}}public List<String> getAllUser(){Connection conn=null;List<String> list=new ArrayList<String>(); PreparedStatement ps=null; ResultSet rs=null;conn=new DBCPConnection().getConnection();String selectSql="select * from qx_users ";if(conn==null){return null;}else{try {ps=conn.prepareStatement(selectSql);rs=ps.executeQuery();while(rs.next()){list.add(rs.getString("USERNAME"));}} catch (SQLException e) {return null;}finally{closeConnection(conn,ps,rs);}}return list;}/** * 绑定账号 * @param fromUserName * @param userName * @return */public String bindAccount(String fromUserName,String userName){Connection conn=null; PreparedStatement ps=null; ResultSet rs=null;String result=getBindStatus(fromUserName);if("连接数据库失败".equals(result)||("查询数据库失败".equals(result))){return "连接数据库失败";}else if("用户名已绑定".equals(result)){return "用户名已绑定,无需重复绑定";}conn = new DBCPConnection().getConnection();List<String> list=getAllUser();if(!list.contains(userName)){return "用户名不存在,绑定失败";} int i = 0; String sql = "insert into crm_stu_wechat (open_id,user_name) values(?,?)"; try { ps = conn.prepareStatement(sql); ps.setString(1, fromUserName); ps.setString(2, userName); i = ps.executeUpdate(); if(i>0){ return "用户名绑定成功"; }else{ return "用户名绑定失败"; } } catch (SQLException e) { return "用户名绑定失败,未知错误"; }finally{ closeConnection(conn,ps,rs); }}/** * 解除账号绑定 * @param fromUserName * @param userName * @return */public String unBindAccount(String userName){Connection conn=null; PreparedStatement ps=null; ResultSet rs=null;conn = new DBCPConnection().getConnection(); int i = 0; String sql=" delete from crm_stu_wechat where user_name= ?"; try { ps = conn.prepareStatement(sql); ps.setString(1, userName); i = ps.executeUpdate(); if(i>0){ return "用户名解除绑定成功"; }else{ return "该用户名不存在"; } } catch (SQLException e) { return "用户名解除绑定失败,未知错误"; }finally{ closeConnection(conn,ps,rs); }}/** * 行程添加 * @param fromUserName * @return */public String addTravel(String fromUserName){Connection conn=null; PreparedStatement ps=null; ResultSet rs=null;String sbStr="";conn = new DBCPConnection().getConnection();String selectSql="select * from crm_stu_wechat where open_id='"+fromUserName+"'";if(conn==null){return "连接数据库失败";}else{try {ps=conn.prepareStatement(selectSql);rs=ps.executeQuery();if(rs.next()){String userName=rs.getString("user_name"); String selectTravelSql="select * from crm_student where user_id='"+userName+"'";Connection connTravel= new DBCPConnection().getConnection();PreparedStatement psTravel=connTravel.prepareStatement(selectTravelSql);ResultSet rsTravel=psTravel.executeQuery();if(rsTravel.next()){String name=rsTravel.getString("id");sbStr="点击添加行程"; return sbStr;}else{return "您未注册,请在电脑端完成注册";}}else{return "用户名未绑定,请输入\"用户名绑定\"+登录用户名 如:用户名绑定fangw";}} catch (SQLException e) {return "查询数据库失败";}finally{closeConnection(conn,ps,rs);}}}/** * 行程查看 * @param fromUserName * @return */public String viewTravel(String fromUserName){Connection conn=null; PreparedStatement ps=null; ResultSet rs=null;StringBuffer sb=new StringBuffer();conn = new DBCPConnection().getConnection();String selectSql="select * from crm_stu_wechat where open_id='"+fromUserName+"'";if(conn==null){return "连接数据库失败";}else{try {ps=conn.prepareStatement(selectSql);rs=ps.executeQuery();if(rs.next()){String userName=rs.getString("user_name"); String selectTravelSql="select * from crm_student_info where user_id='"+userName+"'";Connection connTravel= new DBCPConnection().getConnection();PreparedStatement psTravel=connTravel.prepareStatement(selectTravelSql);ResultSet rsTravel=psTravel.executeQuery();while(rsTravel.next()){sb.append("考试时间:").append(rsTravel.getString("exam_time")).append("\n");sb.append("考试院校:").append(rsTravel.getString("exam_school")).append("\n");sb.append("考试地点:").append(rsTravel.getString("exam_area")).append("\n");sb.append("居住城市:").append(rsTravel.getString("live_city")).append("\n");sb.append("\n"); sb.append("---------------------------------");sb.append("\n"); }if((sb.toString()==null||("".equals(sb.toString())))){return "暂无您的行程";}else{return sb.toString();}}else{return "用户名未绑定,请输入\"用户名绑定\"+登录用户名 如:用户名绑定fangw";}} catch (SQLException e) {return "查询数据库失败";}finally{closeConnection(conn,ps,rs);}}}/** * 查看个人信息 * @return */public String viewStuInfo(String fromUserName){Connection conn=null; PreparedStatement ps=null; ResultSet rs=null;StringBuffer sb=new StringBuffer();conn = new DBCPConnection().getConnection();String selectSql="select * from crm_stu_wechat where open_id='"+fromUserName+"'";if(conn==null){return "连接数据库失败";}else{try {ps=conn.prepareStatement(selectSql);rs=ps.executeQuery();if(rs.next()){String userName=rs.getString("user_name"); String selectStuSql="select * from crm_student where user_id='"+userName+"'";Connection connStu= new DBCPConnection().getConnection();PreparedStatement psStu=connStu.prepareStatement(selectStuSql);ResultSet rsStu=psStu.executeQuery();if(rsStu.next()){sb.append("用户名:").append(rsStu.getString("user_id")).append("\t").append("\n");sb.append("姓名:").append(rsStu.getString("stu_name")).append("\t").append("\n");if("0".equals(rsStu.getString("stu_sex"))){sb.append("性别:").append("男").append("\t").append("\n");}else{sb.append("性别:").append("女").append("\t").append(

用户评论 (0)

发表评论

captcha