treebulletin.java

JSP移动商品管理平台源代码.........

package imis_main;

import java.io.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import database.DBPoolManager;

public class TreeBulletin{

	private ArrayList treenodes;
	
	public TreeBulletin() {
		treenodes = new ArrayList();
	}
	public String ISOtoGB(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("iso-8859-1"),"gb2312");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {

    				e.printStackTrace();
    			}
    		}
    		return out; 		
        } 
	public String GBtoISO(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("gb2312"),"iso-8859-1");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {

    				e.printStackTrace();
    			}
    		}
    		return out;		
        } 
	public ArrayList getMenuTree() {
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;						
			String    sql  = "select * from bulletin order by adddate Desc";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("newsid") == null){
					ht.put("newsid", "");
				}
				else{
				        s = rest.getString("newsid");
				        s = s.trim();
					ht.put("newsid", s);
				}
				if (rest.getString("subject") == null){
					ht.put("subject", "");
				}
				else{
				        s = rest.getString("subject");
				        s = s.trim();
					ht.put("subject", s);
				}
				if (rest.getString("content") == null){
					ht.put("content", "");
				}
				else{
				        s = rest.getString("content");
				        s = s.trim();
					ht.put("content", s);
				}
				if (rest.getString("person") == null){
					ht.put("person", "");
				}
				else{
				        s = rest.getString("person");
				        s = s.trim();
					ht.put("person", s);
				}
				if (rest.getString("adddate") == null){
					ht.put("adddate", "");
				}
				else{
				        s = rest.getString("adddate");
				        s = s.trim();
					ht.put("adddate", s);
				}															
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get MenuTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	public ArrayList getMenuTree(String newsid) {
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;						
			String    sql  = "select * from bulletin where newsid="+newsid;
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("newsid") == null){
					ht.put("newsid", "");
				}
				else{
				        s = rest.getString("newsid");
				        s = s.trim();
					ht.put("newsid", s);
				}
				if (rest.getString("subject") == null){
					ht.put("subject", "");
				}
				else{
				        s = rest.getString("subject");
				        s = s.trim();
					ht.put("subject", s);
				}
				if (rest.getString("content") == null){
					ht.put("content", "");
				}
				else{
				        s = rest.getString("content");
				        s = s.trim();
					ht.put("content", s);
				}
				if (rest.getString("person") == null){
					ht.put("person", "");
				}
				else{
				        s = rest.getString("person");
				        s = s.trim();
					ht.put("person", s);
				}
				if (rest.getString("adddate") == null){
					ht.put("adddate", "");
				}
				else{
				        s = rest.getString("adddate");
				        s = s.trim();
					ht.put("adddate", s);
				}															
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get MenuTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	
	public  boolean creatMenuTree(String subject,String content,String person) {
		boolean res = false;
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		dbpool.setAutoCommit(false);
		try {
			
			Statement stmt = dbpool.conn.createStatement();
			String sql	  =	 "insert into bulletin(newsid, subject,content,person,adddate)values(NEWSID.nextval,'"+subject+"','"+content+"','"+person+"',sysdate)";

			stmt.executeUpdate(sql);
			stmt.close();
			res=true;
			dbpool.commit();
		} catch (SQLException ex) {
			res = false;
			dbpool.rollback();
			System.err.println("Get SyslogBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}
		return res;
	}
	public  boolean updateMenuTree(String newsid,String subject,String content,String person) {
		boolean res = false;
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		dbpool.setAutoCommit(false);
		try {
			
			Statement stmt = dbpool.conn.createStatement();
			String sql	  ="update bulletin set subject='"+subject+"',content='"+content+"',person='"+person+"'where newsid='"+newsid+"'";
			stmt.executeUpdate(sql);
			stmt.close();
			res=true;
			dbpool.commit();
		} catch (SQLException ex) {
			res = false;
			dbpool.rollback();
			System.err.println("Get SyslogBean SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}
		return res;
	}

public  boolean delMenuTree(String newsid) {
	boolean res = false;
	DBPoolManager dbpool = new DBPoolManager();
	dbpool.getConnection();
	dbpool.setAutoCommit(false);
	try {
		
		Statement stmt = dbpool.conn.createStatement();
		String sql	  ="delete from bulletin where newsid='"+newsid+"'";
		stmt.executeUpdate(sql);
		stmt.close();
		res=true;
		dbpool.commit();
	} catch (SQLException ex) {
		res = false;
		dbpool.rollback();
		System.err.println("Get SyslogBean SQLException: " + ex.toString());
	} finally {
		dbpool.freeConnection();
	}
	return res;
}
}