teachermanage.java

用JSP实现毕业设计选题系统,老师在网上出题,学生通过WEB来选题等功能

/**
 * 
 */
package teacher;
import util.ConnData;
import java.sql.*;

/**
 * @author 朱定芬
 *
 */
public class TeacherManage 
{
	ConnData cd=null;
	Statement stmt=null;
	ResultSet rs=null;
	boolean bn=false;
	int i=0;
	String sql=null;
	public TeacherManage()
	{
		cd=new ConnData();
		stmt=cd.OpenStmt();
	}
	
	//保存老师信息
	public int SaveTeacherInfo(TeacherBean tb)
	{
		try
		{
			sql="Insert Into Teacher(TeacherID,TeacherPsd,TeacherName,TeacherDuty,TeacherTel,TeacherEmail,RegDate) Values('"
				+tb.getTeacherID()+"','"
				+tb.getTeacherPsd()+"','"
				+tb.getTeacherName()+"','"
				+tb.getTeacherDuty()+"','"
				+tb.getTeacherTel()+"','"
				+tb.getTeacherEmail()+"','"
				+tb.getRegDate()+"')";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sq)
		{
			System.err.print(sq.getMessage());
		}
		return i;
	}
	//修改老师信息
	public int EditTeacherInfo(TeacherBean tb)
	{
		try
		{
			sql="Update Teacher Set TeacherName='"
				+tb.getTeacherName()+"',TeacherDuty='"
				+tb.getTeacherDuty()+"',TeacherTel='"
				+tb.getTeacherTel()+"',TeacherEmail='"
				+tb.getTeacherEmail()+"' Where TeacherID='"
				+tb.getTeacherID()+"'";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sql)
		{
			System.err.print(sql.getMessage());
		}
		return i;
	}
	//删除老师信息
	public int DeleteTeacherInfo(String id)
	{
		try
		{
			sql="Delete From Teacher Where TeacherID='"+id+"'";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sqle)
		{
			System.err.print(sqle.getMessage());
		}
		return i;
	}
	//得到所有老师信息
	public ResultSet GetAllTeacher()
	{
		try
		{
			sql="Select * From Teacher Order By RegDate";
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException sqlex)
		{
			System.err.print(sqlex.getMessage());
		}
		return rs;
	}
	//得到指定老师信息
	public ResultSet GetOneTeacher(String id)
	{
		try
		{
			sql="Select * From Teacher Where TeacherID='"+id+"'";
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException sqlex)
		{
			System.err.print(sqlex.getMessage());
		}
		return rs;
	}
	//检测老师是否存在
	public boolean ChkTeacher(String id,String psd)
	{
		try
		{
			sql="Select * From Teacher Where TeacherID='"+id+"' and TeacherPsd='"+psd+"'";
			rs=stmt.executeQuery(sql);
			if(rs.next())
			{
				bn=true;
			}
			else
			{
				bn=false;
			}
		}
		catch(SQLException sqlexx)
		{
			System.err.print(sqlexx.getMessage());
		}
		return bn;
	}
	//检测ID是否已经注册
	public boolean ChkID(String id)
	{
		try
		{
			sql="Select * From Teacher Where TeacherID='"+id+"'";
			rs=stmt.executeQuery(sql);
			if(rs.next())
			{
				bn=true;
			}
			else
			{
				bn=false;
			}
		}
		catch(SQLException sqlexx)
		{
			System.err.print(sqlexx.getMessage());
		}
		return bn;
	}
	//修改老师密码
	public int UpdatePsd(TeacherBean tb)
	{
		try
		{
			sql="Update Teacher Set TeacherPsd='"
				+tb.getTeacherPsd()+"' Where TeacherID='"
				+tb.getTeacherID()+"'";
			i=stmt.executeUpdate(sql);
		}
		catch(SQLException sqlexxx)
		{
			System.err.print(sqlexxx.getMessage());
		}
		return i;
	}
}