📄 pubsdaoimpl.java
字号:
try {
conn = DBConn.getConnection();
prst = conn
.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where xiaoqu like ? and quyu=? and type=? order by pubstime desc");
prst.setString(1, "%"+pubs.getXiaoqu()+"%");
prst.setString(2, pubs.getQuyu());
prst.setInt(3, pubs.getType());
rs=prst.executeQuery();
while(rs.next()){
p=new Pubs();
p.setId(rs.getLong(1));
p.setType(rs.getInt(2));
p.setUid(rs.getLong(3));
p.setPubsTime(rs.getString(4));
p.setTitle(rs.getString(5));
p.setXiaoqu(rs.getString(6));
p.setQuyu(rs.getString(7));
p.setAddr(rs.getString(8));
p.setHuxing(rs.getString(9));
p.setWuyeleixing(rs.getString(10));
p.setMianji(rs.getInt(11));
p.setJiaoyijiage(rs.getInt(12));
p.setMiaoshu(rs.getString(13));
list.add(p);
}
} catch (SQLException ea) {
ea.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Huxing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Huxing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Huxing(com.fc.dao.Pubs)
*/
public List findByXiaoQu_Quyu_Huxing(Pubs pubs) {
Pubs p = null;
Connection conn = null;
PreparedStatement prst = null;
ResultSet rs = null;
List<Pubs> list=new ArrayList<Pubs>();
try {
conn = DBConn.getConnection();
prst = conn
.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where xiaoqu like ? and quyu=? and type=? and huxing=? order by pubstime desc");
prst.setString(1, "%"+pubs.getXiaoqu()+"%");
prst.setString(2, pubs.getQuyu());
prst.setInt(3, pubs.getType());
prst.setString(4, pubs.getHuxing());
rs=prst.executeQuery();
while(rs.next()){
p=new Pubs();
p.setId(rs.getLong(1));
p.setType(rs.getInt(2));
p.setUid(rs.getLong(3));
p.setPubsTime(rs.getString(4));
p.setTitle(rs.getString(5));
p.setXiaoqu(rs.getString(6));
p.setQuyu(rs.getString(7));
p.setAddr(rs.getString(8));
p.setHuxing(rs.getString(9));
p.setWuyeleixing(rs.getString(10));
p.setMianji(rs.getInt(11));
p.setJiaoyijiage(rs.getInt(12));
p.setMiaoshu(rs.getString(13));
list.add(p);
}
} catch (SQLException ea) {
ea.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Wuyeleixing(com.fc.dao.Pubs)
*/
public List findByXiaoQu_Quyu_Wuyeleixing(Pubs pubs) {
Pubs p = null;
Connection conn = null;
PreparedStatement prst = null;
ResultSet rs = null;
List<Pubs> list=new ArrayList<Pubs>();
try {
conn = DBConn.getConnection();
prst = conn
.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where xiaoqu like ? and quyu=? and type=? and wuyeleixing=? order by pubstime desc");
prst.setString(1, "%"+pubs.getXiaoqu()+"%");
prst.setString(2, pubs.getQuyu());
prst.setInt(3, pubs.getType());
prst.setString(4, pubs.getWuyeleixing());
rs=prst.executeQuery();
while(rs.next()){
p=new Pubs();
p.setId(rs.getLong(1));
p.setType(rs.getInt(2));
p.setUid(rs.getLong(3));
p.setPubsTime(rs.getString(4));
p.setTitle(rs.getString(5));
p.setXiaoqu(rs.getString(6));
p.setQuyu(rs.getString(7));
p.setAddr(rs.getString(8));
p.setHuxing(rs.getString(9));
p.setWuyeleixing(rs.getString(10));
p.setMianji(rs.getInt(11));
p.setJiaoyijiage(rs.getInt(12));
p.setMiaoshu(rs.getString(13));
list.add(p);
}
} catch (SQLException ea) {
ea.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Huxing_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Huxing_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Quyu_Huxing_Wuyeleixing(com.fc.dao.Pubs)
*/
public List findByXiaoQu_Quyu_Huxing_Wuyeleixing(Pubs pubs) {
Pubs p = null;
Connection conn = null;
PreparedStatement prst = null;
ResultSet rs = null;
List<Pubs> list=new ArrayList<Pubs>();
try {
conn = DBConn.getConnection();
prst = conn
.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where xiaoqu like ? and quyu=? and type=? and huxing=? and wuyeleixing=? order by pubstime desc");
prst.setString(1, "%"+pubs.getXiaoqu()+"%");
prst.setString(2, pubs.getQuyu());
prst.setInt(3, pubs.getType());
prst.setString(4, pubs.getHuxing());
prst.setString(5, pubs.getWuyeleixing());
rs=prst.executeQuery();
while(rs.next()){
p=new Pubs();
p.setId(rs.getLong(1));
p.setType(rs.getInt(2));
p.setUid(rs.getLong(3));
p.setPubsTime(rs.getString(4));
p.setTitle(rs.getString(5));
p.setXiaoqu(rs.getString(6));
p.setQuyu(rs.getString(7));
p.setAddr(rs.getString(8));
p.setHuxing(rs.getString(9));
p.setWuyeleixing(rs.getString(10));
p.setMianji(rs.getInt(11));
p.setJiaoyijiage(rs.getInt(12));
p.setMiaoshu(rs.getString(13));
list.add(p);
}
} catch (SQLException ea) {
ea.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByQuyu_Huxing_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByQuyu_Huxing_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByQuyu_Huxing_Wuyeleixing(com.fc.dao.Pubs)
*/
public List findByQuyu_Huxing_Wuyeleixing(Pubs pubs) {
Pubs p = null;
Connection conn = null;
PreparedStatement prst = null;
ResultSet rs = null;
List<Pubs> list=new ArrayList<Pubs>();
try {
conn = DBConn.getConnection();
prst = conn
.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where quyu=? and type=? and huxing=? and wuyeleixing=? order by pubstime desc");
prst.setString(1, pubs.getQuyu());
prst.setInt(2, pubs.getType());
prst.setString(3, pubs.getHuxing());
prst.setString(4, pubs.getWuyeleixing());
rs=prst.executeQuery();
while(rs.next()){
p=new Pubs();
p.setId(rs.getLong(1));
p.setType(rs.getInt(2));
p.setUid(rs.getLong(3));
p.setPubsTime(rs.getString(4));
p.setTitle(rs.getString(5));
p.setXiaoqu(rs.getString(6));
p.setQuyu(rs.getString(7));
p.setAddr(rs.getString(8));
p.setHuxing(rs.getString(9));
p.setWuyeleixing(rs.getString(10));
p.setMianji(rs.getInt(11));
p.setJiaoyijiage(rs.getInt(12));
p.setMiaoshu(rs.getString(13));
list.add(p);
}
} catch (SQLException ea) {
ea.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Wuyeleixing(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#findByXiaoQu_Wuyeleixing(com.fc.dao.Pubs)
*/
public List findByXiaoQu_Wuyeleixing(Pubs pubs) {
Pubs p = null;
Connection conn = null;
PreparedStatement prst = null;
ResultSet rs = null;
List<Pubs> list=new ArrayList<Pubs>();
try {
conn = DBConn.getConnection();
prst = conn
.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where xiaoqu like ? and wuyeleixing=? and type=? order by pubstime desc");
prst.setString(1, "%"+pubs.getXiaoqu()+"%");
prst.setString(2, pubs.getWuyeleixing());
prst.setInt(3, pubs.getType());
rs=prst.executeQuery();
while(rs.next()){
p=new Pubs();
p.setId(rs.getLong(1));
p.setType(rs.getInt(2));
p.setUid(rs.getLong(3));
p.setPubsTime(rs.getString(4));
p.setTitle(rs.getString(5));
p.setXiaoqu(rs.getString(6));
p.setQuyu(rs.getString(7));
p.setAddr(rs.getString(8));
p.setHuxing(rs.getString(9));
p.setWuyeleixing(rs.getString(10));
p.setMianji(rs.getInt(11));
p.setJiaoyijiage(rs.getInt(12));
p.setMiaoshu(rs.getString(13));
list.add(p);
}
} catch (SQLException ea) {
ea.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#save(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#save(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#save(com.fc.dao.Pubs)
*/
public boolean save(Pubs pubs){
boolean ok=false;
Connection conn = null;
PreparedStatement prst = null;
try{
conn = DBConn.getConnection();
prst = conn
.prepareStatement("insert into pubs (type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu)values(?,?,?,?,?,?,?,?,?,?,?,?)");
prst.setInt(1, pubs.getType());
prst.setLong(2, pubs.getUid());
prst.setString(3, pubs.getPubsTime());
prst.setString(4, pubs.getTitle());
prst.setString(5, pubs.getXiaoqu());
prst.setString(6, pubs.getQuyu());
prst.setString(7, pubs.getAddr());
prst.setString(8, pubs.getHuxing());
prst.setString(9, pubs.getWuyeleixing());
prst.setInt(10, pubs.getMianji());
prst.setInt(11, pubs.getJiaoyijiage());
prst.setString(12, pubs.getMiaoshu());
prst.execute();
ok=true;
}catch(SQLException ea){
ea.printStackTrace();
}finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return ok;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#modify(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#modify(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#modify(com.fc.dao.Pubs)
*/
public boolean modify(Pubs pubs){
boolean ok=false;
Connection conn = null;
PreparedStatement prst = null;
try{
conn = DBConn.getConnection();
prst = conn
.prepareStatement("update pubs set type=?,pubstime=?,title=?,xiaoqu=?,quyu=?,addr=?,huxing=?,wuyeleixing=?,mianji=?,jiaoyijiage=?,miaoshu=? where id=?");
prst.setInt(1, pubs.getType());
prst.setString(2, pubs.getPubsTime());
prst.setString(3, pubs.getTitle());
prst.setString(4, pubs.getXiaoqu());
prst.setString(5, pubs.getQuyu());
prst.setString(6, pubs.getAddr());
prst.setString(7, pubs.getHuxing());
prst.setString(8, pubs.getWuyeleixing());
prst.setInt(9, pubs.getMianji());
prst.setInt(10, pubs.getJiaoyijiage());
prst.setString(11, pubs.getMiaoshu());
prst.setLong(12, pubs.getId());
prst.execute();
ok=true;
}catch(SQLException ea){
ea.printStackTrace();
}finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return ok;
}
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#delete(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#delete(com.fc.dao.Pubs)
*/
/* (non-Javadoc)
* @see com.fc.dao.PubsDao#delete(com.fc.dao.Pubs)
*/
public boolean delete(Pubs pubs){
boolean ok=false;
Connection conn = null;
PreparedStatement prst = null;
try{
conn = DBConn.getConnection();
prst = conn
.prepareStatement("delete from pubs where id=?");
prst.setLong(1, pubs.getId());
prst.execute();
ok=true;
}catch(SQLException ea){
ea.printStackTrace();
}finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return ok;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -