package?com.gjy.edu.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.List;

import?com.gjy.edu.entity.Student;
import?com.gjy.edu.util.DBUtil;

/**
?*?DAO:Data?Access?object（和數(shù)據(jù)庫(kù)有關(guān)的操作）
?*?提供對(duì)t_user表的操作
?*?@author?Administrator
?*
?*/
public?class?StudentDao?{

	//?插入
	public?int?insert（object...parars）{
		
		return?0;
	}
	
	//?插入
	public?int?update（object...parars）{
		
		return?0;
	}
	
	//?插入
	public?int?delete（object...parars）{
		
		return?0;
	}
	
	//?插入
	public?List?query（object...parars）{
		
		return?null;
	}
	
	/**
	?*?根據(jù)用戶名和密碼查詢(xún)
	?*?@param?name
	?*?@param?pwd
	?*?@return
	?*/
	public?Student?queryByStuNoAndPwd（String?stuNoString?pwd）{
		Student?user?=?null;
		Connection?conn?=?null;
		PreparedStatement?pstmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBUtil.getConn（）;
			String?sql?=?“select?*?from?t_student?t?where?“?+
						?“t.valid=1?and?t.stuNo=??and?t.pwd=??“;
			pstmt?=?conn.prepareStatement（sql）;
			
			//?占位符是從1開(kāi)始的
			pstmt.setString（1?stuNo）;
			pstmt.setString（2?pwd）;
			
			rs?=?pstmt.executeQuery（）;
			
			if（rs.next（））{
				int?id?=?rs.getInt（“id“）;
				String?name?=?rs.getString（“name“）;
				String?createTime?=?rs.getString（“createTime“）;
				String?remark?=?rs.getString（“remark“）;
				int?valid?=?rs.getInt（“valid“）;
				
				//?將查詢(xún)結(jié)果封裝到實(shí)體類(lèi)
				user?=?new?Student（）;
				user.setId（id）;
				user.setStuNo（stuNo）;
				user.setName（name）;
				user.setPwd（pwd）;
				user.setCreateTime（createTime）;
				user.setRemark（remark）;
				user.setValid（valid）;
			}
			
		}catch?（Exception?e）?{
			e.printStackTrace（）;
		}finally?{
			DBUtil.closeConn（rs?pstmt?conn）;
		}
		return?user;
	}
	
	/**
	?*?修改密碼
	?*?@param?stuNo：學(xué)號(hào)
	?*?@param?newPwd：新密碼
	?*?@return?true：修改成功；false:修改失敗
	?*/
	public?boolean?updatePwdByStuNo（String?stuNoString?newPwd）{
		boolean?result?=?false;
		Connection?conn?=?null;
		PreparedStatement?pstmt?=?null;
		try?{
			conn?=?DBUtil.getConn（）;
			String?sql?=?“update?t_student?set?pwd=??where?stuNo=?“;
			pstmt?=?conn.prepareStatement（sql）;
			pstmt.setString（1?newPwd）;
			pstmt.setString（2?stuNo）;
			
			int?row?=?pstmt.executeUpdate（）;
			if（row?==?1）{
				result?=?true;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			DBUtil.closeConn（null?pstmt?conn）;
		}
		return?result;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件????????466??2017-12-25?22:34??educationAdmin\.classpath

?????文件????????390??2017-12-19?12:03??educationAdmin\.project

?????文件???????3219??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\dao\StudentDao.class

?????文件???????1664??2017-12-25?22:36??educationAdmin\bin\com\gjy\edu\entity\Student.class

?????文件???????1407??2017-12-25?22:36??educationAdmin\bin\com\gjy\edu\service\StudentService.class

?????文件???????3074??2017-12-26?11:24??educationAdmin\bin\com\gjy\edu\ui\ChenjiChaxun.class

?????文件????????826??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameLogin$1.class

?????文件???????1860??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameLogin$2.class

?????文件???????2534??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameLogin.class

?????文件????????505??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameMain$1.class

?????文件???????1154??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameMain$2.class

?????文件???????3940??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameMain.class

?????文件????????525??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameModifyPwd$1.class

?????文件???????2041??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameModifyPwd$2.class

?????文件????????771??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameModifyPwd$3.class

?????文件???????3200??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\frameModifyPwd.class

?????文件???????3154??2017-12-26?11:37??educationAdmin\bin\com\gjy\edu\ui\KebiaoChaxun.class

?????文件????????747??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\MyJframe$1.class

?????文件???????2027??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\ui\MyJframe.class

?????文件????????828??2017-12-26?11:02??educationAdmin\bin\com\gjy\edu\ui\ZhuYe$1.class

?????文件???????1735??2017-12-26?11:02??educationAdmin\bin\com\gjy\edu\ui\ZhuYe.class

?????文件???????1806??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\util\DBUtil.class

?????文件????????704??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\util\PropertiesReader.class

?????文件????????372??2017-12-25?22:37??educationAdmin\bin\com\gjy\edu\util\Util.class

?????文件????????116??2017-12-19?12:03??educationAdmin\bin\db.properties

?????文件?????158058??2017-12-19?12:03??educationAdmin\forms-1.3.0-src.zip

?????文件?????123353??2017-12-19?12:03??educationAdmin\forms-1.3.0.jar

?????文件?????709922??2017-12-19?12:03??educationAdmin\lib\mysql-connector-java-5.1.7-bin.jar

?????文件???????2621??2017-12-25?22:37??educationAdmin\src\com\gjy\edu\dao\StudentDao.java

?????文件???????1193??2017-12-25?22:36??educationAdmin\src\com\gjy\edu\entity\Student.java

............此處省略35個(gè)文件信息