typedao.java

网上书城 购物车 创建SESSION等 具体网上书城 类库

package com.wl.db.dao;
import java.sql.*;

import com.wl.db.*;
import com.wl.db.vo.*;

public class TypeDAO extends BooksDAO {
	public TypeDAO(){
		
	}
	public String getTypeName(int typeID) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String a=null;
			try{
				String sql="select tyepName from T_bookstype where typeID="+typeID+"";
				BooksType booktype=new BooksType();
				ResultSet rs=db.executeQuery(sql);
			while(rs.next()){
				a=rs.getString("tyepName");
				
				}return a;
			}catch (Exception ex){
				ex.printStackTrace();
				return null;
			}
			finally{
				db.closeConnection();
			}
			
		}
}