newsfile.java

jsp制作的一个信息管理系统源码,完整实用版

package news;

import java.io.*;
import java.sql.*;
import common.DBManager;



public class NewsFile {
	
	public NewsFile() {
	}
	
	/**
	 *锟矫碉拷锟斤拷锟斤拷锟斤拷id锟斤拷应锟侥革拷锟斤拷锟斤拷
	 */
	public ResultSet getPicSet(int nid) {
		
		return (new DBManager()).execQuery("select * from NewsFile where nid=" + nid);
	}
	
	/**
	 *锟矫碉拷NewsFile锟斤拷锟斤拷锟斤拷锟斤拷FileID值
	 */
	public int getMaxID() {
		
		DBManager myDBManager = new DBManager();	
		String  myQueryString = "select max(fid) from NewsFile";
		ResultSet          rs = myDBManager.execQuery(myQueryString);
		
		int maxid = 0;
		
		try {
			if(rs != null && rs.next()) {
				maxid = rs.getInt(1);
				rs.close();
			}
			myDBManager.closeManager();
		} catch(SQLException ex) {
			System.err.println("NewsFileManager.getMaxID() : " + ex.getMessage());
		}		
		return maxid;
	}
	
	/**
	 *锟叫讹拷锟斤拷锟斤拷欠锟轿