学籍管理系统源码（附数据库脚本）

学籍管理系统源码(含数据库脚本)

package com.ischoolbar.programmer.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.ischoolbar.programmer.model.Admin;
import com.ischoolbar.programmer.model.Clazz;

/**
 * 
 * @author ly
 *管理员数据库操作封装
 */
public class AdminDao extends baseDao {
	
	public Admin login（String name String password）{
		String sql = “select * from s_admin where name = ‘“ + name + “‘ and password = ‘“ + password + “‘“;
		ResultSet resultSet = query（sql）;
		try {
			if（resultSet.next（））{
				Admin admin = new Admin（）;
				admin.setId（resultSet.getInt（“id“））;
				admin.setName（resultSet.getString（“name“））;
				admin.setPassword（resultSet.getString（“password“））;
				admin.setStatus（resultSet.getInt（“status“））;
				return admin;
			}
		} catch （SQLException e） {
	

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件     246533  2018-12-16 20:38  StudentManagerWeb\db_student_manager_web\db_student_manager_web.sql

     文件        800  2019-04-15 10:03  StudentManagerWeb\StudentManagerWeb\.classpath

     文件       1050  2018-05-30 19:54  StudentManagerWeb\StudentManagerWeb\.project

     文件        503  2018-05-30 19:54  StudentManagerWeb\StudentManagerWeb\.settings\.jsdtscope

     文件        670  2019-03-25 15:23  StudentManagerWeb\StudentManagerWeb\.settings\org.eclipse.jdt.core.prefs

     文件        503  2018-05-30 19:54  StudentManagerWeb\StudentManagerWeb\.settings\org.eclipse.wst.common.component

     文件        345  2019-03-25 15:26  StudentManagerWeb\StudentManagerWeb\.settings\org.eclipse.wst.common.project.facet.core.xml

     文件         49  2018-05-30 19:54  StudentManagerWeb\StudentManagerWeb\.settings\org.eclipse.wst.jsdt.ui.superType.container

     文件          6  2018-05-30 19:54  StudentManagerWeb\StudentManagerWeb\.settings\org.eclipse.wst.jsdt.ui.superType.name

     文件       2005  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\AdminDao.class

     文件       4393  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\AttendanceDao.class

     文件       1400  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\baseDao.class

     文件       3493  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\ClazzDao.class

     文件       5981  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\CourseDao.class

     文件       3806  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\LeaveDao.class

     文件       6509  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\ScoreDao.class

     文件       4302  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\SelectedCourseDao.class

     文件       6817  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\StudentDao.class

     文件       6817  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\dao\TeacherDao.class

     文件       1675  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\filter\LoginFilter.class

     文件       1142  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Admin.class

     文件       1335  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Attendance.class

     文件        929  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Clazz.class

     文件       1743  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Course.class

     文件       1532  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Leave.class

     文件        963  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Page.class

     文件       1346  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Score.class

     文件        915  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\SelectedCourse.class

     文件       2142  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Student.class

     文件       2119  2019-04-23 18:14  StudentManagerWeb\StudentManagerWeb\build\classes\com\ischoolbar\programmer\model\Teacher.class

............此处省略324个文件信息