cata.java

新闻采用在线编辑器

package popten.web;

import popten.db.DBConnect;
import popten.util.*;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;

public class Cata{

private String cata_id,cata_name,cata_coun;

public String getcata_id() { return cata_id;}
public String getcata_name() { return cata_name;}
public String getcata_coun() { return cata_coun;}

public void setcata_id(String cata_id) { this.cata_id = cata_id; }
public void setcata_name(String cata_name) { this.cata_name = cata_name; }
public void setcata_coun(String cata_coun) { this.cata_coun = cata_coun; }

public Cata(){}

		/**
		* 读取一级目录基本信息
		*/
		public Vector Cata0All(){
			DBConnect dbc = null;
			Vector cataVector = new Vector();
			try{
			dbc  = new DBConnect();
			dbc.prepareStatement("Select * from cata0");
			ResultSet rs = dbc.executeQuery();
			while(rs.next()){
				Cata cata = new Cata();
				cata.setcata_id(rs.getString("cata0_id"));
				cata.setcata_name(rs.getString("cata0_name"));
				cata.setcata_coun(rs.getString("coun"));
				cataVector.add(cata);
			}
		
			}
			catch(Exception e){
				System.err.println(e+"error");
			}
			finally{
				try{
					dbc.close();
				}
				catch(Exception e){
					e.printStackTrace();
				}
			}
			return cataVector;
	 	}
	 	
	 	/**
		* 添加一级目录基本信息
		*/
		
		public static void addCata0(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String cata0_name = ParamUtils.getString(request,"cata0_name","");
			DBConnect dbc = new DBConnect();
			ResultSet rs;
			if(cata0_name.equals("") || cata0_name==null){
				errMsg = errMsg + "□ 您没有输入一级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(!foundErr){	
				
				dbc.prepareStatement("Select * from cata0 where cata0_name=?");
				dbc.setBytes(1,cata0_name.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next()){
					rs.close();
					errMsg = errMsg + "□ 您输入的一级目录名已经存在！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";	
					foundErr = true;
					}
				}
			if(!foundErr){					
				dbc.prepareStatement("INSERT INTO cata0 (cata0_name) VALUES (?)");
				dbc.setBytes(1,cata0_name.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
				}
			if(foundErr) throw new Exception(errMsg); 
			}
			
			
		/**
		* 修改一级目录基本信息
		*/
		
		public static void editCata0(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String cata0_name = ParamUtils.getString(request,"cata0_name","");
			String cata0_id = ParamUtils.getString(request,"cata0_id","");
			DBConnect dbc = new DBConnect();
			ResultSet rs;
			if(cata0_name.equals("") || cata0_name==null){
				errMsg = errMsg + "□ 您没有输入一级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(cata0_id.equals("") || cata0_id==null){
				errMsg = errMsg + "□ 您没有输入序号!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}	
			if(!foundErr){	
				
				dbc.prepareStatement("Select * from cata0 where cata0_name=?");
				dbc.setBytes(1,cata0_name.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next()){
					rs.close();
					errMsg = errMsg + "□ 您输入的一级目录名已经存在！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";	
					foundErr = true;
					}
				}
			if(!foundErr){					
				dbc.prepareStatement("UPDATE cata0 SET cata0_name=? WHERE cata0_id=?");
				dbc.setBytes(1,cata0_name.getBytes("GBK"));
				dbc.setBytes(2,cata0_id.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
				}
			if(foundErr) throw new Exception(errMsg); 
			}
			
		/**
		* 读取二级目录基本信息
		*/
		public Vector Cata1All(String cata0_id) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			//String cata0_id = ParamUtils.getString(request,"cata0_id","");
			if(cata0_id.equals("") || cata0_id==null || cata0_id.equals("0")){
				errMsg = errMsg + "□ 您没有选择一级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(foundErr) throw new Exception(errMsg);
			DBConnect dbc = null;
			Vector cata1Vector = new Vector();
			try{
			dbc  = new DBConnect();
			dbc.prepareStatement("Select * from cata1 where cata0_id="+cata0_id);
			ResultSet rs = dbc.executeQuery();
			while(rs.next()){
				Cata cata1 = new Cata();
				cata1.setcata_id(rs.getString("cata1_id"));
				cata1.setcata_name(rs.getString("cata1_name"));
				cata1.setcata_coun(rs.getString("coun"));
				cata1Vector.add(cata1);
			}
		
			}
			catch(Exception e){
				System.err.println(e+"error");
			}
			finally{
				try{
					dbc.close();
				}
				catch(Exception e){
					e.printStackTrace();
				}
			}
			return cata1Vector;
	 	}
	 	
	 	/**
		* 添加二级目录基本信息
		*/
		
		public static void addCata1(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String cata1_name = ParamUtils.getString(request,"cata1_name","");
			String cata0_id = ParamUtils.getString(request,"cata0_id","");
			DBConnect dbc = new DBConnect();
			ResultSet rs;
			if(cata1_name.equals("") || cata1_name==null){
				errMsg = errMsg + "□ 您没有输入二级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(cata0_id.equals("") || cata0_id==null || cata0_id.equals("0")){
				errMsg = errMsg + "□ 您没有选择一级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}	
			if(!foundErr){	
				
				dbc.prepareStatement("Select * from cata1 where cata1_name=?");
				dbc.setBytes(1,cata1_name.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next()){
					rs.close();
					errMsg = errMsg + "□ 您输入的二级目录名已经存在！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";	
					foundErr = true;
					}
				}
			if(!foundErr){					
				dbc.prepareStatement("INSERT INTO cata1 (cata1_name,cata0_id) VALUES (?,?)");
				dbc.setBytes(1,cata1_name.getBytes("GBK"));
				dbc.setBytes(2,cata0_id.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
				}
			if(foundErr) throw new Exception(errMsg); 
			}
			
		/**
		* 修改二级目录基本信息
		*/
		
		public static void editCata1(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String cata1_name = ParamUtils.getString(request,"cata1_name","");
			String cata1_id = ParamUtils.getString(request,"cata1_id","");
			DBConnect dbc = new DBConnect();
			ResultSet rs;
			if(cata1_name.equals("") || cata1_name==null){
				errMsg = errMsg + "□ 您没有输入二级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(cata1_id.equals("") || cata1_id==null){
				errMsg = errMsg + "□ 您没有输入序号!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}	
			if(!foundErr){	
				
				dbc.prepareStatement("Select * from cata1 where cata1_name=?");
				dbc.setBytes(1,cata1_name.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next()){
					rs.close();
					errMsg = errMsg + "□ 您输入的二级目录名已经存在！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";	
					foundErr = true;
					}
				}
			if(!foundErr){					
				dbc.prepareStatement("UPDATE cata1 SET cata1_name=? WHERE cata1_id=?");
				dbc.setBytes(1,cata1_name.getBytes("GBK"));
				dbc.setBytes(2,cata1_id.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
				}
			if(foundErr) throw new Exception(errMsg); 
			}
			
		/**
		* 读取三级目录基本信息
		*/
		public Vector Cata2All(String cata1_id) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			//String cata1_id = ParamUtils.getString(request,"cata1_id","");
			if(cata1_id.equals("") || cata1_id==null || cata1_id.equals("0")){
				errMsg = errMsg + "□ 您没有选择二级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(foundErr) throw new Exception(errMsg);
			DBConnect dbc = null;
			Vector cata2Vector = new Vector();
			try{
			dbc  = new DBConnect();
			dbc.prepareStatement("Select * from cata2 where cata1_id="+cata1_id);
			ResultSet rs = dbc.executeQuery();
			while(rs.next()){
				Cata cata2 = new Cata();
				cata2.setcata_id(rs.getString("cata2_id"));
				cata2.setcata_name(rs.getString("cata2_name"));
				cata2.setcata_coun(rs.getString("coun"));
				cata2Vector.add(cata2);
			}
		
			}
			catch(Exception e){
				System.err.println(e+"error");
			}
			finally{
				try{
					dbc.close();
				}
				catch(Exception e){
					e.printStackTrace();
				}
			}
			return cata2Vector;
	 	}	
			
		/**
		* 添加三级目录基本信息
		*/
		
		public static void addCata2(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String cata2_name = ParamUtils.getString(request,"cata2_name","");
			String cata1_id = ParamUtils.getString(request,"cata1_id","");
			DBConnect dbc = new DBConnect();
			ResultSet rs;
			if(cata2_name.equals("") || cata2_name==null){
				errMsg = errMsg + "□ 您没有输入三级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(cata1_id.equals("") || cata1_id==null || cata1_id.equals("0")){
				errMsg = errMsg + "□ 您没有选择二级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}	
			if(!foundErr){	
				
				dbc.prepareStatement("Select * from cata2 where cata2_name=?");
				dbc.setBytes(1,cata2_name.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next()){
					rs.close();
					errMsg = errMsg + "□ 您输入的三级目录名已经存在！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";	
					foundErr = true;
					}
				}
			if(!foundErr){					
				dbc.prepareStatement("INSERT INTO cata2 (cata2_name,cata1_id) VALUES (?,?)");
				dbc.setBytes(1,cata2_name.getBytes("GBK"));
				dbc.setBytes(2,cata1_id.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
				}
			if(foundErr) throw new Exception(errMsg); 
			}
			
		/**
		* 修改三级目录基本信息
		*/
		
		public static void editCata2(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String cata2_name = ParamUtils.getString(request,"cata2_name","");
			String cata2_id = ParamUtils.getString(request,"cata2_id","");
			DBConnect dbc = new DBConnect();
			ResultSet rs;
			if(cata2_name.equals("") || cata2_name==null){
				errMsg = errMsg + "□ 您没有输入三级目录名!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}
			if(cata2_id.equals("") || cata2_id==null){
				errMsg = errMsg + "□ 您没有输入序号!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
				}	
			if(!foundErr){	
				
				dbc.prepareStatement("Select * from cata2 where cata2_name=?");
				dbc.setBytes(1,cata2_name.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next()){
					rs.close();
					errMsg = errMsg + "□ 您输入的三级目录名已经存在！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";	
					foundErr = true;
					}
				}
			if(!foundErr){					
				dbc.prepareStatement("UPDATE cata2 SET cata2_name=? WHERE cata2_id=?");
				dbc.setBytes(1,cata2_name.getBytes("GBK"));
				dbc.setBytes(2,cata2_id.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
				}
			if(foundErr) throw new Exception(errMsg); 
			}
		
}