coursescoreinfodao.java

在本系统中

package jin.dao;

import java.sql.*;
import java.util.*;

import jin.bean.*;
import jin.config.*;
import jin.conn.*;

import jin.bean.*;

public class CourseScoreInfoDAO
{
	private Connection conn=null;
	
	//查询
	public ArrayList excuteQuery(String sql)
	{
		Statement stat=null;
		ResultSet rs=null;
		ArrayList CourseScoreInfos=new ArrayList();
		CourseScoreInfoBean courseScoreInfoBean=null;
		
		try
		{
			if(conn==null)
			{
				conn=new DBConnection().getConnection(new TextParser());
				if(conn==null)
				{
					System.out.println("连接失败");
				}
				
				else
					System.out.println("连接成功");	
			}
			stat=conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
			rs=stat.executeQuery(sql);
		
			while(rs.next())
			{	
			//课程成绩信息 :学生学号、课程编号、学年、学期、成绩、教师编号、状态、备注		
				courseScoreInfoBean=new CourseScoreInfoBean();				
 						
				courseScoreInfoBean.setStuID(rs.getString("stuID"));				
				courseScoreInfoBean.setCourseID(rs.getString("courseID"));				
				courseScoreInfoBean.setStudyYear(rs.getString("studyYear"));
				courseScoreInfoBean.setStudyTeam(rs.getString("studyTeam"));
				courseScoreInfoBean.setScore(rs.getString("score"));
				courseScoreInfoBean.setTeaID(rs.getString("teaID"));
				courseScoreInfoBean.setState(rs.getString("state"));
				courseScoreInfoBean.setOther(rs.getString("other"));
						
				CourseScoreInfos.add(courseScoreInfoBean);
							
			}			
		}
		
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
		
		return CourseScoreInfos;
	}
	
	//增加
	public boolean insert(String sql)  //MajorInfoBean majorInfoBean
	{
		//String sql="insert into majorInfo(majorID, majorName, belongTo, state) values("+majorInfoBean.getMajorID()+","+majorInfoBean.getMajorName()+","+majorInfoBean.getBelongTo()+","+majorInfoBean.getState()+")";
		Statement stat=null;
		int returnValue=0;
		
		try
		{
			if(conn==null)
			{
				conn=new DBConnection().getConnection(new TextParser());
			}
			stat=conn.createStatement();
			returnValue=stat.executeUpdate(sql);
			
		}
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
		
		if(returnValue>0)
		{
			return true;
		}
		else
		{
			return false;
		}
	}
	
	//删除
	public boolean delete(String sql)
	{
		return insert(sql);
	}
	
	//更新
	public boolean update(String sql)
	{
		return insert(sql);
	}
}