package bdqn.newsMange.Dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import bdqn.newsMange.Dao.BaseDao;
import bdqn.newsMange.Dao.categoryTBDao;
import bdqn.newsMange.entity.categoryTB;
/**
* 新闻类别实现类
*
* @author Administrator
*
*/
public class categoryTBDaoImpl extends BaseDao implements categoryTBDao {
// 查询
public List<categoryTB> getCategoryTBAll() {
String sql = "select categoryID,categoryName from categoryTB";
List<categoryTB> typelist = new ArrayList<categoryTB>();
try {
ResultSet rs = executeQurey(sql, null);
while (rs.next()) {
categoryTB cate = new categoryTB();
cate.setCategoryID(rs.getInt(1));
cate.setCategoryName(rs.getString(2));
typelist.add(cate);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll();
}
return typelist;
}
// 添加
public int addCategory(categoryTB cate) {
int rel = 0;
String sql = "insert categoryTB (categoryName) values(?)";
List<Object> prams = new ArrayList<Object>();
prams.add(cate.getCategoryName());
try {
rel = executeUpdate(sql, prams);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll();
}
return rel;
}
// 修改
public int updateCategory(categoryTB cate) {
int rel = 0;
String sql = "update categoryTB set categoryName=? where categoryId=?";
List<Object> prams = new ArrayList<Object>();
prams.add(cate.getCategoryName());
prams.add(cate.getCategoryID());
try {
rel = executeUpdate(sql, prams);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
closeAll();
}
return rel;
}
// 删除
public int delCategory(int id) {
int rel = 0;
String sql = "delete from categoryTB where categoryId=?";
List<Object> prams = new ArrayList<Object>();
prams.add(id);
try {
rel = executeUpdate(sql, prams);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll();
}
return rel;
}
// 根据类别查询
public categoryTB getCateByName(String catename) {
categoryTB cate = null;
String sql = "select categoryID,categoryName from categoryTB where categoryName=?";
List<Object> prams = new ArrayList<Object>();
prams.add(catename);
try {
ResultSet rs = executeQurey(sql, prams);
while (rs.next()) {
cate = new categoryTB();
cate.setCategoryID(rs.getInt("categoryId"));
cate.setCategoryName(rs.getString("categoryName"));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll();
}
return cate;
}
// 获取类别,根据id
public categoryTB getCateById(int id) {
categoryTB cate = null;
String sql = "select categoryID,categoryName from categoryTB where categoryId=?";
List<Object> prams = new ArrayList<Object>();
prams.add(id);
try {
ResultSet rs = executeQurey(sql, prams);
if (rs.next()) {
cate = new categoryTB();
cate.setCategoryID(rs.getInt(1));
cate.setCategoryName(rs.getString(2));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
closeAll();
}
return cate;
}
public int categoryId(String categoryName) {
int rel=0;
String sql="select categoryID,CategoryName from categoryTB where categoryName=?";
List<Object>prams=new ArrayList<Object>();
prams.add(categoryName);
ResultSet rs=null;
try {
rs=executeQurey(sql, prams);
if(rs.next()){
categoryTB cate=new categoryTB();
cate.setCategoryID(rs.getInt("CategoryID"));
cate.setCategoryName(rs.getString("CategoryName"));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeAll();
}
return rel;
}
}