ccatadao.java

自己写的一个网络日志(BLOG)系统

package blog;
import java.sql.*;
import java.util.*;
/**
 * 
 * <p>Title: CCataDAO</p>
 * <p>Description: 分类管理类</p>
 * <p>Copyright: copyright (c) 2005-2005</p>
 * <p>Company: </p>
 * @author Administrator
 * @version 1.0.00_01
 */
public class CCataDAO {
	private Connection conn = null;
	private Statement stmt = null;
	private CallableStatement cstmt = null;
	private ResultSet rs = null;
	private static CCataDAO  cataDao= null;
	
	public static CCataDAO newInstance(){
		if(cataDao == null){
			cataDao = new CCataDAO();
		}
		return cataDao;
	}
	
	private CCataDAO(){
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=blogdata",
	        		"sa",
					"sa");
		} catch (Exception e) {
			System.err.println("blog.CCataDAO.CCataDAO()"+e.getMessage());
		}
	}
	
	public int executeInsert(CCatalog catalog){
		int i = 0;
		String sql = "insert Tcatalog values('"+catalog.getCataName()+"','"+catalog.getCataIntro()+"')";
		try{
			stmt = conn.createStatement();
			i = stmt.executeUpdate(sql);
			
		}catch(Exception e){
			System.err.println("blog.CCataDAO.executeInsert()"+e.getMessage());
		}
		return i;
	}
	
	public ArrayList executeQuery(){
		ArrayList cataList = null;
		String sql = "select * from Tcatalog";
		try{
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if(rs.next()){
				cataList = new ArrayList();
				do{
					CCatalog catalog = new CCatalog();
					catalog.setCataID(rs.getInt(1));
					catalog.setCataName(rs.getString(2));
					catalog.setCataIntro(rs.getString(3));
					cataList.add(catalog);
				}while(rs.next());
			}
		}catch(Exception e ){
			System.err.println("blog.CCataDAO.executeQuery()"+e.getMessage());
		}
		return cataList;
	}
	
	public String queryByID(int cataID){
		String cataName = null;
		String sql =  "select cataName from Tcatalog where cataID="+cataID;
		try{
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if(rs.next()){
				do{
					cataName = rs.getString(1);
				}while(rs.next());
			}
		}catch(Exception e){
			System.err.println("blog.CCataDAO.queryByID()"+e.getMessage());
		}
		return cataName;
	}
	
	public int delCata(int cataID){
		int i = 0;
		try{
	        cstmt = conn.prepareCall("{call ? = proc_delCata(?)}");
	        cstmt.registerOutParameter(1,Types.INTEGER);
	        cstmt.setInt(2,cataID);
	        cstmt.execute();
	        i= cstmt.getInt(1);
		}catch(Exception e){
			System.err.println("blog.CCataDAO.delCata()"+e.getMessage());
		}
		return i;
	}
	
	public int executeUpdate(CCatalog catalog){
		int i = 0;
		String sql = "update Tcatalog "+
					"set cataName='"+catalog.getCataName()+"',cataIntro='"+catalog.getCataIntro()+"' "+
					"where cataID="+catalog.getCataID();
		try {
			stmt = conn.createStatement();
			i = stmt.executeUpdate(sql);
		} catch (Exception e) {
			System.err.println("blog.CCataDAO.executeUpdate()"+e.getMessage());
		}
		return i;
	}
	
	

}