newsdao.java

来自「某高校的门户网站源码」· Java 代码 · 共 46 行

package com.zzx.notes;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import net.ijsp.news.news.Factory;
import net.ijsp.news.news.News;
import net.ijsp.news.news.NewsFactory;

import com.zzx.util.DataConn;

public class NewsDAO {
	
	public NewsDAO() {
	}
	
	
	Factory factory = Factory.getInstance();
	News news = factory.getNews();	
	Connection conn = new DataConn().getConn();
	
	public  void delete(int id) throws Exception{
   	
		 PreparedStatement psmt = null;
		 String sql = "delete from news where id=?";			 
		 try {
				psmt = conn.prepareStatement(sql);
				psmt.setInt(1, id);
				psmt.executeUpdate();
				psmt.close();
				System.out.println("news delete successfully!");
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}			 
   }

}