operationnews.java

减肥看得见的时间开放的是开始的看放开的是 地放开

package com.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.util.ArrayList;

public class operationnews {

	public operationnews() {
		// TODO Auto-generated constructor stub
	}
	/**
	 * 添加新闻
	 * @param tt新闻标题
	 * @param ct新闻内容
	 * @param dt新闻时间
	 * @return i用来判断是否提交成功
	 */
    public  int addNews(news ubnews){
    	int i=1;
    	Connection con=dbcn.getCn();
    	try{
    		PreparedStatement ps=con.prepareStatement("insert into news(title,content,dat) values(?,?,?)");
    		ps.setString(1, ubnews.getTitle());
    		ps.setString(2, ubnews.getContent());
    		ps.setString(3, ubnews.getDat());
    		ps.executeUpdate();
    		i=0;
    	}catch(SQLException ce){
    		System.out.print(ce);
    	}
    	
    	return i;
    }
    /**
     * 查看新闻标题,时间
     * @param ubnews
     * @return
     */
    public  ArrayList listNews(){
    	ArrayList<news> list=new ArrayList<news>();
    	Connection con=dbcn.getCn();
    	try{
    		PreparedStatement ps=con.prepareStatement("select * from news order by id desc");
    		ResultSet rs=ps.executeQuery();
    		while(rs.next()){
    			news ub=new news();
    			ub.setId(rs.getInt(1));
    			ub.setTitle(rs.getString(2));
    			ub.setContent(rs.getString(3));
    			ub.setDat(rs.getString(4));
    			list.add(ub);
    			
    		}
    	}catch(SQLException ce){
    		System.out.print(ce);
    	}
    	
    	return list;
    }
   
}