You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
76 lines
2.1 KiB
76 lines
2.1 KiB
package com.dao;
|
|
import java.util.*;
|
|
|
|
import java.util.Date;
|
|
import java.sql.*;
|
|
import com.domain.Article;
|
|
|
|
public class ArticleDaoImpl implements ArticleDao {
|
|
|
|
|
|
@Override
|
|
public List<Article> listArticle() throws SQLException {
|
|
// TODO Auto-generated method stub
|
|
Article Article = new Article();
|
|
|
|
Connection conn = getConnection();
|
|
List<Article> list = new ArrayList<Article>();
|
|
String sql = "SELECT * FROM Article";
|
|
try (
|
|
PreparedStatement pstmt = conn.prepareStatement(sql);
|
|
ResultSet rs = pstmt.executeQuery()){
|
|
while(rs.next()){
|
|
// int Dyid = rs.getInt("Dyid");
|
|
// String Uid = rs.getString(2);
|
|
// String Uname = rs.getString(3);
|
|
// Date Rtime = rs.getDate(4);
|
|
// String Content = rs.getString(5);
|
|
// PostCheck s = new PostCheck();
|
|
// s.setDyid(Dyid);
|
|
// s.setUid(Uid);
|
|
// s.setUname(Uname);
|
|
// s.setRtime(Rtime);
|
|
// s.setContent(Content);
|
|
// System.out.println(list+"test2");//
|
|
// list.add(s);
|
|
Article.setAid(rs.getInt("Aid"));
|
|
Article.setUid(rs.getString("Uid"));
|
|
Article.setUname(rs.getString("Uname"));
|
|
Article.setTitle(rs.getString("Title"));
|
|
Article.setContent(rs.getString("Content"));
|
|
Article.setMid(rs.getString("Mid"));
|
|
Article.setDate(rs.getDate("date"));
|
|
Article.setStatics(rs.getString("Statics"));
|
|
list.add(Article);
|
|
}
|
|
|
|
return list;
|
|
|
|
}catch(SQLException e){
|
|
System.out.println(e);
|
|
return null;
|
|
}
|
|
}
|
|
@Override
|
|
// 删除文章
|
|
public int removeArticle(int Aid) throws SQLException {
|
|
// TODO Auto-generated method stub
|
|
Connection conn = getConnection();
|
|
String sql = "DELETE FROM Article WHERE Aid=?";
|
|
try {
|
|
PreparedStatement pstmt = conn.prepareStatement(sql);
|
|
pstmt.setInt(1, Aid);
|
|
return pstmt.executeUpdate();
|
|
}catch(SQLException sqle){
|
|
System.out.println(sqle);
|
|
return 0;
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|