/*
* (non-Javadoc)
*
* @see org.test.dao.impl.IDirayDao#readList()
*/
@Override
public List<Diray> readList(Integer uid) {
String sql = "select * from diray where uid=?";
con = DB.getCon();
List<Diray> list = new ArrayList<Diray>();
try {
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, uid);
rs = pstmt.executeQuery();
while (rs.next()) {
list.add(
new Diray(
rs.getInt(1),
rs.getString(2),
rs.getString(3),
new Usr(rs.getInt(4)),
rs.getString(5)));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.closeAll(con, pstmt, rs);
}
return list;
}
/*
* (non-Javadoc)
*
* @see org.test.dao.impl.IDirayDao#delete(java.lang.Integer)
*/
@Override
public boolean delete(Integer id) {
String sql = "delete from diray where id=?";
try {
pstmt = DB.getCon().prepareStatement(sql);
pstmt.setInt(1, id);
return pstmt.executeUpdate() > 0;
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.closeAll(con, pstmt, rs);
}
return false;
}
/*
* (non-Javadoc)
*
* @see org.test.dao.impl.IDirayDao#update(org.test.entity.Diray)
*/
@Override
public boolean update(Diray d) {
String sql = "update diray set title=?, centent=?,publishtime=? where id=?";
try {
con = DB.getCon();
pstmt = con.prepareStatement(sql);
pstmt.setString(1, d.getTitle());
pstmt.setString(2, d.getCentent());
pstmt.setString(3, d.getPublishtime());
pstmt.setInt(4, d.getId());
return pstmt.execute();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.closeAll(con, pstmt, rs);
}
return false;
}
/*
* (non-Javadoc)
*
* @see org.test.dao.impl.IDirayDao#read(java.lang.Integer)
*/
@Override
public Diray read(Integer id) {
String sql = "select * from diray where id=? ";
con = DB.getCon();
ResultSet rs = null;
try {
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, id);
rs = pstmt.executeQuery();
if (rs.next()) {
return new Diray(rs.getInt(1), rs.getString(2), rs.getString(3));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.closeAll(con, pstmt, rs);
}
return null;
}
/*
* (non-Javadoc)
*
* @see org.test.dao.impl.IDirayDao#create(org.test.entity.Diray)
*/
@Override
public boolean create(Diray d) {
String sql = "insert into diray(title,centent,uid,publishtime) values(?,?,?,?)";
con = DB.getCon();
try {
pstmt = con.prepareStatement(sql);
pstmt.setString(1, d.getTitle());
pstmt.setString(2, d.getCentent());
pstmt.setInt(3, d.getUsr().getId());
pstmt.setString(4, d.getPublishtime());
if (pstmt.executeUpdate() > 0) {
return true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.closeAll(con, pstmt, rs);
}
return false;
}