Java开源生鲜电商平台-销售管理设计与架构(源码…
2018-06-18 00:28:53来源:未知 阅读 ()
Java开源生鲜电商平台-销售管理设计与架构(源码可下载)
说明:在Java开源生鲜电商平台中,销售人员我们称为跟餐饮店老板沟通与下载APP的一类地推人员。(所谓地推指的就是一个一个上门拜访。)
由于销售人员有以下几类特性:
1. 时间随意性,他们并不类似技术或者性质人员,需要天天呆在办公室,他们是需要去外面,时间上具有随意性。
2. 行动随意性 ,他们的行动过于随意,每天也不用来打卡,每天就是按照计划去拜访客户,然后推销生鲜电商APP,让客户来进行下单,那么行为很随意,站在公司的角度
我们是没办法控制这种行为,但是我们也很想知道目前销售人员进度 在哪里来了,遇到了什么问题,一般如何解决。
3. 内容随意性,每天早上开会,晚上复盘,很多的时候我们会问今天你们拜访了那些客户,遇到了那些问题,如何解决的,经验进行分享,但是很多时候我们其实不知道内容是真还是假的,因为销售的嘴皮太能说了。
那么如此多的问题,作为技术上,我们应该如何帮助公司呢?对此需要一个管理的销售APP。
1. 技术上设计,会设计到以下几点;
2. 销售人员本身的管理。
CREATE TABLE `sales` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自动增加ID', `phone` varchar(32) DEFAULT NULL COMMENT '手机号码', `password` varchar(32) DEFAULT NULL COMMENT 'md5加密', `true_name` varchar(16) DEFAULT NULL, `status` int(11) DEFAULT NULL COMMENT '1为在职,-1为离职', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `last_update_time` datetime DEFAULT NULL COMMENT '更新时间', `level` int(11) DEFAULT NULL COMMENT '类型1总监 2主管 3职员', `experience` decimal(12,2) DEFAULT NULL, `parent_id` bigint(20) DEFAULT NULL COMMENT '直属上级', PRIMARY KEY (`id`), KEY `unique_phone` (`phone`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='销售人员基本信息';
补充说明;任何人员的管理都会存在一个管理人员的权限问题,最高领导者应该具有查看所有的内容的权限。
3. 销售每天需要写日报,因此销售日报
CREATE TABLE `sales_daily` ( `sd_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `sale_id` bigint(20) DEFAULT NULL COMMENT '销售人员ID', `sd_date` date DEFAULT NULL COMMENT '工作日期', `task1` decimal(12,2) DEFAULT NULL COMMENT '销售任务', `task2` int(11) DEFAULT NULL COMMENT '日拜访量', `sd_street` varchar(256) DEFAULT NULL COMMENT '拜访街道', `sd_summary` varchar(512) DEFAULT NULL COMMENT '工作总结', `sd_time` datetime DEFAULT NULL COMMENT '提交时间', `look_status` int(11) DEFAULT NULL COMMENT '查阅状态(0未读 1已读)', `look_sale_id` bigint(20) DEFAULT NULL COMMENT '查阅人', `look_time` datetime DEFAULT NULL COMMENT '查阅时间', `look_reply` varchar(512) DEFAULT NULL COMMENT '主管回复', PRIMARY KEY (`sd_id`) ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='销售日报';
说明:主管以及以上的人员都需要进行日报是审批与处理,根据日报反应出来的问题,进行及时的处理。
4. 每天要做什么,怎么做,你需要有一个计划进行。
CREATE TABLE `sales_plan` ( `sp_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `sp_type` tinyint(4) DEFAULT NULL COMMENT '类型(1区域 2销售)', `sp_fmon` varchar(10) DEFAULT NULL COMMENT '月份', `sale_id` bigint(20) DEFAULT NULL COMMENT '销售人员ID', `area_id` bigint(20) DEFAULT NULL COMMENT '区域ID', `goal_amt` decimal(12,2) DEFAULT NULL COMMENT '销售总目标', `online_amt` decimal(12,2) DEFAULT NULL COMMENT '线上目标', `green_amt` decimal(12,2) DEFAULT NULL COMMENT '蔬菜销售', `register_num` int(11) DEFAULT NULL COMMENT '注册量', `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`sp_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='销售计划';
5. 销售过程中,肯定会出现一些其他的特殊情况,这种情况需要销售报备.
CREATE TABLE `sales_reported` ( `sr_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `sale_id` bigint(20) DEFAULT NULL COMMENT '销售ID', `sr_type` tinyint(4) DEFAULT NULL COMMENT '报备类型(1缺填日报 2其他)', `sr_desc` varchar(512) DEFAULT NULL COMMENT '报备原因', `sr_time` datetime DEFAULT NULL COMMENT '报备时间', `look_sale_id` bigint(20) DEFAULT NULL COMMENT '查阅人ID', `look_status` tinyint(4) DEFAULT NULL COMMENT '查阅状态', `look_time` datetime DEFAULT NULL COMMENT '查阅时间', `look_reply` varchar(512) DEFAULT NULL COMMENT '查阅回复', PRIMARY KEY (`sr_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='销售报备';
6. 对于一个销售人员而言,你每天需要做的事情很多都是陌生拜访,那么拜访,你总应该有个记录吧,无论是否拜访成功
这里是有一个成功率的问题的。不是每个都成功的。
CREATE TABLE `sales_visit` ( `sv_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `buyer_id` bigint(20) DEFAULT NULL COMMENT '商家ID', `sale_id` bigint(20) DEFAULT NULL COMMENT '销售人员ID', `sv_way` tinyint(4) DEFAULT NULL COMMENT '拜访方式(1预约 2其他)', `sv_type` tinyint(4) DEFAULT NULL COMMENT '拜访类型(1上门 2电话)', `sv_logo` varchar(128) DEFAULT NULL COMMENT '门头照', `sv_address` varchar(256) DEFAULT NULL COMMENT '拜访地址', `sv_status` tinyint(4) DEFAULT NULL COMMENT '拜访状态(0未 1已)', `sv_date` date DEFAULT NULL COMMENT '预约日期', `sv_time` datetime DEFAULT NULL COMMENT '拜访时间', `sv_remark` varchar(512) DEFAULT NULL COMMENT '拜访感想', PRIMARY KEY (`sv_id`) ) ENGINE=InnoDB AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COMMENT='销售拜访';
7,销售不管有日报还有周报,总结与分析这周的所有问题,成功的也好,失败的也好,需要分享与记录。
CREATE TABLE `sales_weekly` ( `sw_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `sale_id` bigint(20) DEFAULT NULL COMMENT '销售ID', `sw_fmon` varchar(10) DEFAULT NULL COMMENT '月份', `sw_range` varchar(128) DEFAULT NULL COMMENT '时间范围', `sw_summary` varchar(1024) DEFAULT NULL COMMENT '本周总结', `sw_plan` varchar(1024) DEFAULT NULL COMMENT '下周计划', `need_help` varchar(1024) DEFAULT NULL COMMENT '需求帮助', `sw_time` datetime DEFAULT NULL COMMENT '填写时间', `look_status` tinyint(4) DEFAULT NULL COMMENT '查看状态', `look_sale_id` bigint(20) DEFAULT NULL COMMENT '查看人', `look_time` datetime DEFAULT NULL COMMENT '查看时间', `look_reply` varchar(1024) DEFAULT NULL COMMENT '查看回复', PRIMARY KEY (`sw_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='销售周报';
8,最终根据业务的形态构建了系统架构,同时也设计的数据库,最终业务核心代码如下:
日报的核心代码:
/** */ @RestController @RequestMapping("/sales") public class DaliyController extends BaseController { private static final Logger logger = LoggerFactory.getLogger(DaliyController.class); @Autowired private DaliyService daliyService; /** * 销售人员日报列表 */ @RequestMapping(value = "/getSalesDaliyList", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getSalesDaliyList(HttpServletRequest request, HttpServletResponse response,Long saleId) { try { List<DaliyListVo> biList = daliyService.getSalesDaliyList(saleId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList); } catch (Exception ex) { logger.error("[DaliyController][getSalesDaliyList] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 销售人员日报详情 */ @RequestMapping(value = "/getSalesDaliyInfo", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getSalesDaliyInfo(HttpServletRequest request, HttpServletResponse response,Long saleId,String sdDate) { try { DaliyVo daliyVo = daliyService.getSalesDaliyInfo(saleId, sdDate); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", daliyVo); } catch (Exception ex) { logger.error("[DaliyController][getSalesDaliyInfo] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 添加工作计划 */ @RequestMapping(value = "/insertSalesDaliy", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult insertSalesDaliy(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesDaliy salesDaliy) { try { if(salesDaliy == null){ return new JsonResult(JsonResultCode.FAILURE, "参数有误!", ""); } int result = daliyService.insertSalesDaliy(salesDaliy); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", ""); } } catch (Exception ex) { logger.error("[DaliyController][insertSalesDaliy] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 修改工作计划 */ @RequestMapping(value = "/updateSalesDaliy", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult updateSalesDaliy(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesDaliy salesDaliy) { try { if(salesDaliy == null){ return new JsonResult(JsonResultCode.FAILURE, "参数有误!", ""); } if(salesDaliy.getSdId() == null){ return new JsonResult(JsonResultCode.FAILURE, "参数有误!", ""); } int result = daliyService.updateSalesDaliy(salesDaliy); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "更新信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "更新信息失败", ""); } } catch (Exception ex) { logger.error("[DaliyController][updateSalesDaliy] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 今日工作总结 */ @RequestMapping(value = "/updateSalesDaliySummary", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult updateSalesDaliySummary(HttpServletRequest request, HttpServletResponse response,Long saleId,String sdDate,String summary) { try { int result = daliyService.updateSalesDaliySummary(saleId, sdDate, summary); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "修改信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "修改信息失败", ""); } } catch (Exception ex) { logger.error("[DaliyController][updateSalesDaliySummary] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 添加客户拜访 */ @RequestMapping(value = "/insertSalesVisit", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult insertSalesVisit(HttpServletRequest request, HttpServletResponse response,@RequestBody MultipartFile[] svLogoFile ,Long saleId,Long buyerId,String svAddress,Short svType,String svRemark) { try { if(saleId == null || saleId == 0){ return new JsonResult(JsonResultCode.FAILURE, "参数saleId异常", ""); } if(buyerId == null || buyerId == 0){ return new JsonResult(JsonResultCode.FAILURE, "参数buyerId异常", ""); } List<String> logoList = MultipartFileUtils.getImgPath(request, response, svLogoFile); SalesVisit salesVisit = new SalesVisit(); salesVisit.setSaleId(saleId); salesVisit.setBuyerId(buyerId); if(logoList!=null && logoList.size()>0){ salesVisit.setSvLogo(logoList.get(0)); } salesVisit.setSvAddress(svAddress); salesVisit.setSvType(svType); salesVisit.setSvRemark(svRemark); VisitVo vv = daliyService.getVisitInfoById(saleId, buyerId); if(vv == null){ //直接拜访 salesVisit.setSvWay((short)2); salesVisit.setSvStatus((short)1); salesVisit.setSvTime("1"); int result = daliyService.insertSalesVisit(salesVisit); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", ""); } }else{ //预约拜访 if(vv.getSvStatus()==0){ salesVisit.setSvId(vv.getSvId()); daliyService.updateSalesVisit(salesVisit); return new JsonResult(JsonResultCode.SUCCESS, "更新信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "该商家您今天已经拜访过了!", ""); } } } catch (Exception ex) { logger.error("[DaliyController][insertSalesVisit] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 销售人员拜访记录列表 */ @RequestMapping(value = "/getSalesVisitList", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getSalesVisitList(HttpServletRequest request, HttpServletResponse response,Long saleId,Short svType) { try { List<VisitVo> biList = daliyService.getSalesVisitList(saleId,svType); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList); } catch (Exception ex) { logger.error("[DaliyController][getSalesVisitList] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 销售人员拜访记录详情 */ @RequestMapping(value = "/getSalesVisitInfo", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getSalesVisitInfo(HttpServletRequest request, HttpServletResponse response,Long svId) { try { VisitVo visitVo = daliyService.getSalesVisitInfo(svId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", visitVo); } catch (Exception ex) { logger.error("[DaliyController][getSalesDaliyInfo] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 主管查看 */ @RequestMapping(value = "/updateLookStatus", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult updateDaliyLookStatus(HttpServletRequest request, HttpServletResponse response,Long saleId,Long sdId,String reply) { try { int result = daliyService.updateDaliyLookStatus(saleId, sdId,reply); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "修改信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "修改信息失败", ""); } } catch (Exception ex) { logger.error("[DaliyController][updateLookStatus] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 添加工作报备 */ @RequestMapping(value = "/insertSalesReported", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult insertSalesReported(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesReported salesReported) { try { int result = daliyService.insertSalesReported(salesReported); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", ""); } } catch (Exception ex) { logger.error("[DaliyController][insertSalesReported] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 报备主管查看 */ @RequestMapping(value = "/updateReportedLookStatus", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult updateReportedLookStatus(HttpServletRequest request, HttpServletResponse response,Long saleId,Long srId,String reply) { try { int result = daliyService.updateReportedLookStatus(saleId, srId, reply); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "修改信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "修改信息失败", ""); } } catch (Exception ex) { logger.error("[DaliyController][updateReportedLookStatus] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 销售人员报备记录列表 */ @RequestMapping(value = "/getSalesReportedList", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getSalesReportedList(HttpServletRequest request, HttpServletResponse response,Long saleId) { try { List<ReportedVo> biList = daliyService.getSalesReportedList(saleId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList); } catch (Exception ex) { logger.error("[DaliyController][getSalesReportedList] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 管理人员查看销售人员报备记录列表 */ @RequestMapping(value = "/getMargeReportedList", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getMargeReportedList(HttpServletRequest request, HttpServletResponse response,Long saleId) { try { List<ReportedListVo> biList = daliyService.getMargeReportedList(saleId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList); } catch (Exception ex) { logger.error("[DaliyController][getMargeReportedList] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } }
周报的核心代码:
/** * 销售周报信息 */ @RestController @RequestMapping("/sales") public class WeeklyController extends BaseController { private static final Logger logger = LoggerFactory.getLogger(WeeklyController.class); @Autowired private SalesWeeklyService salesWeeklyService; /** * 销售人员周报列表 */ @RequestMapping(value = "/getWeeklyList", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getWeeklyList(HttpServletRequest request, HttpServletResponse response,Long saleId) { try { List<WeeklyVo> biList = salesWeeklyService.getWeeklyList(saleId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList); } catch (Exception ex) { logger.error("[WeeklyController][getWeeklyList] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 管理员查看周报列表 */ @RequestMapping(value = "/getMargerWeeklyList", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getMargerWeeklyList(HttpServletRequest request, HttpServletResponse response,Long saleId) { try { List<WeeklyListVo> biList = salesWeeklyService.getMargerWeeklyList(saleId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList); } catch (Exception ex) { logger.error("[WeeklyController][getMargerWeeklyList] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 销售人员周报详情 */ @RequestMapping(value = "/getWeeklyVo", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult getWeeklyVo(HttpServletRequest request, HttpServletResponse response,Long swId) { try { WeeklyVo weeklyVo = salesWeeklyService.getWeeklyVo(swId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", weeklyVo); } catch (Exception ex) { logger.error("[WeeklyController][getWeeklyVo] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 销售人员填写周报时调用 */ @RequestMapping(value = "/findWeeklyVo", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult findWeeklyVo(HttpServletRequest request, HttpServletResponse response,Long saleId) { try { WeeklyVo weeklyVo = salesWeeklyService.findWeeklyVo(saleId); return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", weeklyVo); } catch (Exception ex) { logger.error("[WeeklyController][findWeeklyVo] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 添加销售周报 */ @RequestMapping(value = "/insertSalesWeekly", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult insertSalesWeekly(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesWeekly salesWeekly) { try { if(salesWeekly == null){ return new JsonResult(JsonResultCode.FAILURE, "参数有误!", ""); } int result = salesWeeklyService.insertSalesWeekly(salesWeekly); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", ""); } } catch (Exception ex) { logger.error("[WeeklyController][insertSalesWeekly] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } /** * 管理员评价 */ @RequestMapping(value = "/updateWeeklyLookStatus", method = { RequestMethod.GET, RequestMethod.POST }) public JsonResult updateWeeklyLookStatus(HttpServletRequest request, HttpServletResponse response,Long saleId,String reply,Long swId) { try { int result = salesWeeklyService.updateWeeklyLookStatus(saleId, reply, swId); if(result > 0){ return new JsonResult(JsonResultCode.SUCCESS, "更新信息成功", ""); }else{ return new JsonResult(JsonResultCode.FAILURE, "跟新信息失败", ""); } } catch (Exception ex) { logger.error("[WeeklyController][updateWeeklyLookStatus] exception :", ex); return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", ""); } } }
Java开源生鲜电商平台-销售管理设计与架构(源码可下载),如果需要下载的话,可以在我的github下面进行下载。
群号:168096884
标签:
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有
上一篇:SSM+Redis瞎搞
下一篇:构造方法
- 国外程序员整理的Java资源大全(全部是干货) 2020-06-12
- 2020年深圳中国平安各部门Java中级面试真题合集(附答案) 2020-06-11
- 2020年java就业前景 2020-06-11
- 04.Java基础语法 2020-06-11
- Java--反射(框架设计的灵魂)案例 2020-06-11
IDC资讯: 主机资讯 注册资讯 托管资讯 vps资讯 网站建设
网站运营: 建站经验 策划盈利 搜索优化 网站推广 免费资源
网络编程: Asp.Net编程 Asp编程 Php编程 Xml编程 Access Mssql Mysql 其它
服务器技术: Web服务器 Ftp服务器 Mail服务器 Dns服务器 安全防护
软件技巧: 其它软件 Word Excel Powerpoint Ghost Vista QQ空间 QQ FlashGet 迅雷
网页制作: FrontPages Dreamweaver Javascript css photoshop fireworks Flash