majorinfodao.java

在本系统中

package jin.dao;

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

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

import jin.bean.*;

public class MajorInfoDAO
{
	private Connection conn=null;
	
	//查询
	public ArrayList excuteQuery(String sql)
	{
		//String sql="select * from majorInfo";
		Statement stat=null;
		ResultSet rs=null;
		ArrayList majorInfos=new ArrayList();
		MajorInfoBean majorInfoBean=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())
			{
				majorInfoBean=new MajorInfoBean();
				//userBean.setUserID(rs.getString(0));
 				majorInfoBean.setMajorID(rs.getString("majorID"));
				majorInfoBean.setMajorName(rs.getString("majorName"));
				majorInfoBean.setBelongTo(rs.getString("belongTo"));
				majorInfoBean.setState(rs.getString("state"));
				majorInfos.add(majorInfoBean);
							
			}			
		}
		
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
		
		return majorInfos;
	}
	
	//增加
	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);
	}
	
	/*
	public boolean update(String id,String password,int role,String flag)
	{
		PreparedStatement ps=null;
		boolean returnValue=false;
		String sql=null;
		
		sql="update login set id=? where password=? where role=? where flag=?";		
		try
		{
			if(conn==null)
			{
				conn=new DBConnection().getConnection(new TextParser());
			}
			ps=conn.prepareStatement(sql);
			ps.setString(1,id);
			ps.setString(2,password);
			ps.setInt(3,role);
			returnValue=ps.execute();
		}
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
				
		return !returnValue;		
	}
	*/

}