sortdao.java

本人大学时大型作业用JAVA做的一个 BBS系统 模式MVC 非struts版 开发工具JCreator Pro 数据库SQL2

package db;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
import domain.*;
import listener.DataSourceListener;
import actions.*;
public class SortDao
{	
	private String selectAll="select sort_id,sort_name,sort_editHost from bbsSorts";
	private String selectById="select sort_id,sort_name,sort_editHost from bbsSorts where sort_id=?";
	private DataSource ds=null;
	public SortDao()
	{
		try
		{			
			Context cx=new InitialContext();
			ds=(DataSource)cx.lookup(DataSourceListener.JNDI_NAME);
		}
		catch(Exception e)
		{
		}			
	}
	public BBSSort getBBSSort(String sortId)
	{
		Connection conn=null;
		BBSSort sort=null;
		try
		{
			conn=ds.getConnection();
			PreparedStatement psmt=conn.prepareStatement(selectById);
			psmt.setInt(1,Integer.parseInt(sortId));
			ResultSet rs=psmt.executeQuery();
			rs.next();
			sort=new BBSSort(rs.getInt(1),
					rs.getString(2),
					rs.getString(3));				
		}
		catch(Exception e)
		{
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
			}
			catch(Exception ignore)
			{
			}
		}
		return sort;
	}
	public void addSort()
	{
		NewSortAction newSortAction=new NewSortAction();
		Connection conn=null;
		BBSSort sort=null;
		try
		{
			conn=ds.getConnection();
			Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			ResultSet rs=stmt.executeQuery("select * from bbsSorts");
			rs.moveToInsertRow();
			rs.updateString(2,newSortAction.getNewSort().getSortName());
			rs.updateString(3,newSortAction.getNewSort().getEditHost());
			rs.insertRow();
		}
		catch(Exception e)
		{			
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
			}
			catch(Exception ignore)
			{
			}
		}		
	}
	public HashMap getSorts()
	{
		Connection conn=null;
		HashMap sorts=null;
		try
		{
			conn=ds.getConnection();
			PreparedStatement psmt=conn.prepareStatement(selectAll);
			ResultSet rs=psmt.executeQuery();
			sorts=new HashMap();
			while(rs.next())
			{
				BBSSort sort=new BBSSort();
				sort.setSortId(rs.getInt(1));
				sort.setSortName(rs.getString(2));
				sort.setEditHost(rs.getString(3));			
				sorts.put(sort.getSortId(),sort);			
			}
		}
		catch(Exception e)
		{
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
			}
			catch(Exception ignore)
			{
			}
		}
		return sorts;
	}
}