teach_login.java

在线考试系统

package com.gton.bean;

import java.sql.ResultSet;
import java.sql.SQLException;
import com.gton.bean.util.*;

public class teach_login {
	ResultSet  tab=null;
	DB_Conn db_conn=new DB_Conn();
	
	public String checkTeacherLogin(String t_name,String t_pwd) 
	{
		db_conn.ConnectDB();
		try 
		{
			
			String sql="select * from 教师 where 工作号='"+t_pwd.trim()+"' and 姓名='"+t_name.trim()+"'"; 
			tab=db_conn.sm.executeQuery(sql);     // 执行sql语句
			if(tab.next())
			    return "1";
			else 
				return "0";
			
		}
		catch (SQLException SqlE)
		{
			SqlE.printStackTrace();
			return "0";
		}
		catch (Exception E) 
		{
			E.printStackTrace();
			return "0";
			
		}
		finally 
		{
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}

}