stuinfodao.java

在本系统中

package jin.dao;

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

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

import jin.bean.*;

public class StuInfoDAO
{
	private Connection conn=null;
	
	//查询
	public ArrayList excuteQuery(String sql)
	{
		//String sql="select * from majorInfo";
		Statement stat=null;
		ResultSet rs=null;
		ArrayList stuInfos=new ArrayList(20);
		StuInfoBean stuInfoBean=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())
			{
				stuInfoBean=new StuInfoBean();
				
 				stuInfoBean.setStuID(rs.getString("stuID"));
 				stuInfoBean.setStuName(rs.getString("stuName"));
				stuInfoBean.setClassID(rs.getString("classID"));						
				stuInfoBean.setState(rs.getString("state"));
				stuInfoBean.setDelRecord(rs.getString("delRecord"));
				stuInfos.add(stuInfoBean);
							
			}			
		}
		
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
		
		return stuInfos;
	}
	
	//增加
	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);
	}
}