newsbiz.java

用myeclipse编写的一个简单新闻发布

package com.newsassurace.biz;

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

import com.newsassurace.dao.BaseDAO;
import com.newsassurace.entity.FirstlevelTitleBean;
import com.newsassurace.entity.SecondLevelTitleBean;
import com.newsassurace.entity.UserBean;


public class NewsBiz {

	public String isExist(UserBean ub){	
		BaseDAO bdao=new BaseDAO();	
		Connection con=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		
		String id=null;
		
		con=bdao.openConnection();
		try{
			
			String sql="select * from creater where name=? and password=?";
			
			pstmt=con.prepareStatement(sql);
								
			pstmt.setString(1,ub.getName());
			pstmt.setString(2,ub.getPassword());

			rs=pstmt.executeQuery();
								
			while(rs.next()){
				id=rs.getString(1);
			return id;
			}
				
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			bdao.closeConnection(con,pstmt,rs);
		}
		return id;
	}
	public boolean saveFirstTitle(FirstlevelTitleBean bean){
		java.sql.Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		String sql="insert into FirstLevelTitle values(?,?,?)";
		BaseDAO bd=new BaseDAO();
		con=bd.openConnection();
		int i=0;
		try {
			pst=con.prepareStatement(sql); 
	
			pst.setString(1,bean.getTitleName() );
			pst.setString(2,bean.getCreaterId() );
			pst.setString(3,bean.getCreateTime());
			i=pst.executeUpdate();
			if(i>0){
				return true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			bd.closeConnection(con, pst, rs);
		}
		return false;
	}
	public ArrayList queryAllFirstTitle(){
		java.sql.Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		String sql="select * from FirstLevelTitle";
		BaseDAO bd=new BaseDAO();
		con=bd.openConnection();
		ArrayList list=new ArrayList();
		try {
			pst=con.prepareStatement(sql);
			rs=pst.executeQuery();
			while(rs.next()){
				FirstlevelTitleBean bean=new FirstlevelTitleBean();
					bean.setId(rs.getString(1));
					bean.setTitleName(rs.getString(2));
					bean.setCreaterId(rs.getString(3));
					bean.setCreateTime(rs.getString(4));
				list.add(bean);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			bd.closeConnection(con, pst, rs);
		}
		return list;
	}
	
	public boolean saveSecondTitle(SecondLevelTitleBean bean){
		java.sql.Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		String sql="insert into SecondLevelTitle values(?,?,?,?,?)";
		BaseDAO bd=new BaseDAO();
		con=bd.openConnection();
		int i=0;
		

		try {
			pst=con.prepareStatement(sql); 
	
			pst.setString(1,bean.getTitleName());
			pst.setString(2,bean.getFilePath() );
			pst.setString(3,bean.getCreaterId());
			pst.setString(4,bean.getCreateTime());
			pst.setString(5,bean.getParentId());
			i=pst.executeUpdate();
			if(i>0){
				return true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			bd.closeConnection(con, pst, rs);
		}
		return false;
	}
	
	public String queryParentId(String firstLevelTitleName){
		java.sql.Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		String sql="select f_id from FirstLevelTitle where titlename=?";
		BaseDAO bd=new BaseDAO();
		String parentId=null;
		
		con=bd.openConnection();
		ArrayList list=new ArrayList();
		try {
			pst=con.prepareStatement(sql);
			pst.setString(1, firstLevelTitleName);
			rs=pst.executeQuery();
			while(rs.next()){
				parentId=rs.getString(1);	
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			bd.closeConnection(con, pst, rs);
		}
		return parentId;
	}
	
	public ArrayList QuerySecondTitle(String patentid){
		java.sql.Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		String sql="select * from SecondLevelTitle where patentid=?";
		BaseDAO bd=new BaseDAO();
		con=bd.openConnection();
		ArrayList list=new ArrayList();
		try {
			pst=con.prepareStatement(sql);
			pst.setString(1, patentid);
			rs=pst.executeQuery();
			while(rs.next()){
				SecondLevelTitleBean bean=new SecondLevelTitleBean();
					bean.setId(rs.getString(1));
					bean.setTitleName(rs.getString(2));
					bean.setFilePath(rs.getString(3));
					bean.setCreaterId(rs.getString(4));
					bean.setCreateTime(rs.getString(5));
					bean.setParentId(rs.getString(6));
				list.add(bean);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			bd.closeConnection(con, pst, rs);
		}
		return list;
	}
	
	public boolean saveUser(UserBean bean){
		java.sql.Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		String sql="insert into creater values(?,?)";
		BaseDAO bd=new BaseDAO();
		con=bd.openConnection();
		int i=0;
		try {
			pst=con.prepareStatement(sql); 
	
			pst.setString(1,bean.getName() );
			pst.setString(2,bean.getPassword() );
		
			i=pst.executeUpdate();
			if(i>0){
				return true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			bd.closeConnection(con, pst, rs);
		}
		return false;
	}
}