7080b1c9eeac001d12e9c6aae1085a9a

jsp的课程实践

package course.dao;
import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import student.dao.DataBase;
import course.beans.Course;
public class CourseDAO {
    private DataBase db;
    public CourseDAO()
    {
    	super();
    	db=new DataBase();
    }
    public Course getCourseInfo(String id)
    {
    	Course course=null;
    	try
    	{
    		String sql="select * from course where courseId='"+id+"'";
    		ResultSet rst =db.executeQuery(sql);
    		while(rst.next())
    		{
    			String courseId=rst.getString("courseId");
    			String courseName=rst.getString("courseName");
    			String teacher=rst.getString("teacher");
    			String courseDes=rst.getString("courseDes");
    			int credit=rst.getInt("credit");
    			course=new Course(courseId,courseName,teacher,courseDes,credit);
    		}
    	}
    	catch(SQLException ex)
    	{
    		ex.printStackTrace();
    	}
    	return course;
    }
    public ArrayList<Course> getAllCourse()
    {
    	ArrayList<Course> list=new ArrayList<Course>();
    	try
    	{
    		String sql="select * from course";
    		ResultSet rst=db.executeQuery(sql);
    		while(rst.next())
    		{
    			Course course=null;
    			String courseId=rst.getString("courseId");
    			String courseName=rst.getString("courseName");
    			String teacher=rst.getString("teacher");
    			String courseDes=rst.getString("courseDes");
    			int credit=rst.getInt("credit");
    			course=new Course(courseId,courseName,teacher,courseDes,credit);
    			list.add(course);
    		}
    	}
    	catch(SQLException ex)
    	{
    		ex.printStackTrace();
    	}
    	return list;
    }
   
    public ArrayList<Course>findCourse(String argCourseId,String argCourseName,String argTeacher,String argCourseDes,String argCredit)
    {
    	ArrayList<Course>courses=new ArrayList<Course>();
    	try
    	{
    		String argCourseId2=new String(argCourseId.getBytes("iso-8859-1"),"gbk");
    		String argCourseName2=new String(argCourseName.getBytes("iso-8859-1"),"gbk");
    		String argTeacher2=new String(argTeacher.getBytes("iso-8859-1"),"gbk");
    		String argCourseDes2=new String(argCourseDes.getBytes("iso-8859-1"),"gbk");
    		String argCredit2=new String(argCredit.getBytes("iso-8859-1"),"gbk");
        	//String sql="select * from course where courseId='"+ argCourseId2 +"' or courseName='"+argCourseName2+"' or teacher='"+
        	//argTeacher2+"' or courseDes='"+argCourseDes2+"' or credit='"+argCredit2+"'";
    		String sql="select * from course where courseId like '%"+ argCourseId2 +"%' or courseName='"+argCourseName2+"' or teacher='"+
        	argTeacher2+"' or courseDes='"+argCourseDes2+"' or credit='"+argCredit2+"'";
    		ResultSet rst=db.executeQuery(sql);
			while(rst.next())
			{
				Course course=null;
    			String courseId=rst.getString("courseId");
    			String courseName=rst.getString("courseName");
    			String teacher=rst.getString("teacher");
    			String courseDes=rst.getString("courseDes");
    			int credit=rst.getInt("credit");
    			course=new Course(courseId,courseName,teacher,courseDes,credit);
    			courses.add(course);
			}
    	}
    	catch(SQLException ex)
    	{
    		ex.printStackTrace();
    	}
    	catch( UnsupportedEncodingException ex)
    	{
    		ex.printStackTrace();
    	}
    	return courses;
    }
/*    public ArrayList<Course>findCourse(String argCourseId,String argCourseName,String argTeacher,String argCourseDes,String argCredit)
	{
    	ArrayList<Course>courses=new ArrayList<Course>();
		//利用编码技巧实现实现SQL语句查询
		try
    	{
			String argCourseId2=new String(argCourseId.getBytes("iso-8859-1"),"gbk");
    		String argCourseName2=new String(argCourseName.getBytes("iso-8859-1"),"gbk");
    		String argTeacher2=new String(argTeacher.getBytes("iso-8859-1"),"gbk");
    		String argCourseDes2=new String(argCourseDes.getBytes("iso-8859-1"),"gbk");
    		String argCredit2=new String(argCredit.getBytes("iso-8859-1"),"gbk");
    	String conditionSql=new String("".getBytes("iso-8859-1"),"gbk");
		String whereSql=new String("where".getBytes("iso-8859-1"),"gbk");
		if((argCourseId2==null||argCourseId2.equals(""))&&(argCourseName2==null||argCourseName2.equals(""))&&(argTeacher2==null||argTeacher2.equals(""))&&
				(argCourseDes2==null||argCourseDes2.equals(""))&&(argCredit2==null||argCredit2.equals("")))
		{
			whereSql="";
		}
		else
		{
			if(argCourseId2!=null&&!argCourseId2.equals(""))
			{
			    conditionSql+="courseId like '%"+argCourseId2+"%' or ";
			}
			if(argCourseName2!=null&&!argCourseName2.equals(""))
			{
				conditionSql+="courseName like '%"+argCourseName2+"%' or ";
			}
			if(argTeacher2!=null && !argTeacher2.equals(""))
			{
				conditionSql+="teacher like '%"+argTeacher2+"%' or ";
			}
			if(argCourseDes2!=null &&!argCourseDes2.equals(""))
			{
				conditionSql+="courseDes like '%"+argCourseDes2+"%' or ";
			}
			if(argCredit2!=null && !argCredit2.equals(""))
			{
				conditionSql+="credit like '%"+argCredit2+"%' or ";
			}
			if(conditionSql!=null&&!conditionSql.equals(""))
			{
				conditionSql=conditionSql.substring(0, conditionSql.length()-3);
			}
		}
		
		String sql="select * from course "+ whereSql+conditionSql;
    		ResultSet rst=db.executeQuery(sql);
			while(rst.next())
			{
				Course course=null;
    			String courseId=rst.getString("courseId");
    			String courseName=rst.getString("courseName");
    			String teacher=rst.getString("teacher");
    			String courseDes=rst.getString("courseDes");
    			int credit=rst.getInt("credit");
    			course=new Course(courseId,courseName,teacher,courseDes,credit);
    			courses.add(course);
			}
    	}
        catch(SQLException ex){
        	ex.printStackTrace();
        }
        catch( UnsupportedEncodingException ex)
    	{
    		ex.printStackTrace();
    	}
        
		return courses;
	}*/
}