/*
* (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#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;
}