package com.dao;
import com.bean.CollegeVo;
import com.bean.PageObject;
import com.bean.ProvinceVo;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class CollegeDAO {
//新增学校
public boolean add(CollegeVo t) {
try {
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
String sql = "insert into college(collegeName,contact,tel,collegeAddr,remark,pic) values('";
sql += t.getCollegeName() + "','";
sql += t.getContact() + "','";
sql += t.getTel() + "','";
sql += t.getCollegeAddr() + "','";
sql += t.getRemark() + "','')";
System.out.println("sql=" + sql);
//保存数据到teacher表中
stmt.executeUpdate(sql);
return true;
}catch (Exception e){
e.printStackTrace();
return false;
}
}
//修改学校
public boolean edit(CollegeVo t) {
try {
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
String sql = "update college set ";
sql += " collegeName= '"+t.getCollegeName() + "',";
sql += " contact='" + t.getContact() + "',";
sql += " tel='" + t.getTel() + "',";
sql += " collegeAddr='" + t.getCollegeAddr() + "',";
sql += " remark='"+ t.getRemark() + "',pic='' where collegeId=" + t.getCollegeId();
System.out.println("sql=" + sql);
//保存数据到teacher表中
stmt.executeUpdate(sql);
return true;
}catch (Exception e){
e.printStackTrace();
return false;
}
}
//删除学校
public boolean del(String collegeId) {
try {
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
String sql = "delete from college where collegeId=" + collegeId;
System.out.println("sql=" + sql);
//保存数据到teacher表中
stmt.executeUpdate(sql);
return true;
}catch (Exception e){
e.printStackTrace();
return false;
}
}
public List<CollegeVo> getList(PageObject pager){
List<CollegeVo> collegeList = new ArrayList<CollegeVo>();
try{
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
String sql = "select * from college limit " + pager.getStartIndex() + "," + pager.perCount;
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
CollegeVo c = new CollegeVo();
c.setCollegeId(rs.getInt("collegeId"));
c.setCollegeName(rs.getString("collegeName"));
c.setContact(rs.getString("contact"));
c.setTel(rs.getString("tel"));
c.setCollegeAddr(rs.getString("collegeAddr"));
c.setRemark(rs.getString("remark"));
c.setPic(rs.getString("pic"));
collegeList.add(c);
}
}catch (Exception e){
e.printStackTrace();
}
return collegeList;
}
public CollegeVo getById(String collegeId){
CollegeVo c = new CollegeVo();
try{
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
String sql = "select * from college where collegeId=" + collegeId;
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
c.setCollegeId(rs.getInt("collegeId"));
c.setCollegeName(rs.getString("collegeName"));
c.setContact(rs.getString("contact"));
c.setTel(rs.getString("tel"));
c.setCollegeAddr(rs.getString("collegeAddr"));
c.setRemark(rs.getString("remark"));
c.setPic(rs.getString("pic"));
}
}catch (Exception e){
e.printStackTrace();
}
return c;
}
public int getCount(){
int cnt = 0;
try{
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select count(*) cnt from college");
if(rs.next()){
cnt = rs.getInt("cnt");
}
}catch (Exception e){
e.printStackTrace();
}
return cnt;
}
//实现省市县三级联动
/*
* - 查询所有的省
select * from province where id like '__0000';
-- 查询江西省所有市
select * from province where id like '36__00' and id !='360000';
-- 查询赣州市所有的区县
select * from province where id like '3602__' and id !='360200';
* */
public List<ProvinceVo> getCity(int type,String id){
List<ProvinceVo> provList = new ArrayList<ProvinceVo>();
try{
Connection conn = DBConn.open();
Statement stmt = conn.createStatement();
String sql = "";
switch (type){
case 1: //查询省
sql = "select * from province where id like '__0000'";
break;
case 2: //查询市
sql = "select * from province where id like '"+ id+"__00' and id !='"+id+"0000'";
break;
case 3: //查询区县
sql = "select * from province where id like '"+id+"__' and id !='"+id+"00'";
break;
}
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
ProvinceVo p = new ProvinceVo();
p.setId(rs.getString("id"));
p.setName(rs.getString("name"));
provList.add(p);
}
}catch (Exception e){
e.printStackTrace();
}
return provList;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
项目内容从创建原生态的HTTPXMLRequest实现ajax开始,详细讲解ajax的应用,各种应用场合的实战案例;利用JQuery的ajax支持,详细讲解$.ajax,$.post,$.get等方法实现ajax技术;讲解ajax文件上传,三级联动等;利用ajax技术返回普通文本,xml格式,JSON格式数据等案例;具体案例如下: 1.前端创建HTTPXMLRequest对象及实现步骤,后台用jsp的servlet处理数据; 2.封装HTTPXMLRequest对象,实现通用的ajax技术; 3.利用ajax技术实现登录功能; 4.利用ajax技术,返回xml格式数据并处理,实战案例是实现局部刷新菜单;鼠标点击菜单收缩功能;鼠标点击弹出商品明细功能;模糊查询,模拟百度搜索框功能。 5.利用ajax技术,返回JSON格式数据; 6.利用JQuery的$.ajax,$.post,$.get方法,分别返回text,xml,json等格式数据,通过fastjson生成JSON格式数据; 7.使用JQuery的ajax技术,在一个页面实现新增、修改、删除、查询、分页,文件上传等功能;
资源推荐
资源详情
资源评论
收起资源包目录
ajaxProj(060702).rar (61个子文件)
ajaxProj
ajaxProj.iml 1KB
src
com
servlet
TTServlet.java 3KB
CollegeServlet.java 4KB
T4AjaxServlet.java 2KB
ProvinceServlet.java 2KB
AjaxServlet.java 1012B
RefreshServlet.java 2KB
LoginServlet.java 4KB
dao
DBConn.java 2KB
CollegeDAO.java 6KB
bean
ProvinceVo.java 426B
CollegeVo.java 1KB
LoginBean.java 402B
PageObject.java 2KB
web
WEB-INF
classes
com
servlet
TTServlet.class 4KB
LoginServlet.class 3KB
RefreshServlet.class 2KB
ProvinceServlet.class 2KB
T4AjaxServlet.class 3KB
AjaxServlet.class 2KB
CollegeServlet.class 4KB
dao
DBConn.class 1KB
CollegeDAO.class 6KB
bean
LoginBean.class 744B
PageObject.class 1KB
ProvinceVo.class 727B
CollegeVo.class 2KB
lib
javax.servlet-api-4.0.1.jar 93KB
fastjson-1.2.67.jar 647KB
jsp-api-2.0.jar 47KB
jstl-1.2.jar 405KB
mysql-connector-java-5.1.48.jar 983KB
web.xml 391B
index.jsp 309B
js
ajax.js 1KB
jquery-3.3.1.min.js 85KB
jquery.form.js 43KB
T4
ajaxFun.jsp 5KB
test.xml 170B
collegeAdd.html 9KB
T2
menu.html 3KB
refresh.jsp 949B
select.jsp 965B
searchsuggest.jsp 851B
tip.html 3KB
refresh.html 2KB
searchsuggest.html 3KB
tip.jsp 727B
T5
province.jsp 3KB
ajaxform.jsp 3KB
images
3.png 136KB
1.png 110KB
4.png 150KB
2.png 119KB
upload
T3
jqueryDemo2.html 1KB
jqueryEvent.html 1KB
jqueryDemo.html 3KB
T1
HttpRequestDemo.html 2KB
ajax.html 1KB
login.html 3KB
province.sql 1KB
共 61 条
- 1
资源评论
CSDN专家-赖老师(软件之家)
- 粉丝: 4711
- 资源: 30
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功