www.pudn.com > NewsAssurance.rar > NewsBiz.java

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; 
	} 
}