Oracle课程设计管理系统

oracle期末大作业，设计一个管理系统项目，并用文档标识出每一部分组成，添加的数据库，包括需求，模块实现，数据库图示等特别详细。

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import entity.Admin;

public class AdminDao {
	public Admin login（Connection connectionAdmin admin）throws Exception{
		Admin resultAdmin = null;
		String sql = “select * from admin where username=? and password=?“;
		PreparedStatement pStatement = connection.prepareStatement（sql）;
		pStatement.setString（1 admin.getUserName（））;
		pStatement.setString（2 admin.getPassword（））;
		ResultSet resultSet = pStatement.executeQuery（）;
		
		if （resultSet.next（）） {
			resultAdmin = new Admin（）;
			resultAdmin.setUserName（resultSet.getString（“username“））;
			resultAdmin.setPassword（resultSet.getString（“password“））;
			return resultAdmin;
		}
		return null;
	}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-12-25 12:11  orcle大作业\
     文件     1012736  2018-12-25 12:11  orcle大作业\实验报告.doc
     目录           0  2018-12-25 12:08  orcle大作业\源代码\
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\
     文件        1725  2018-12-23 23:00  orcle大作业\源代码\backend\DatabaseDesign\.classpath
     文件         914  2017-04-04 21:42  orcle大作业\源代码\backend\DatabaseDesign\.project
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.settings\
     文件         567  2017-03-17 23:00  orcle大作业\源代码\backend\DatabaseDesign\.settings\.jsdtscope
     文件         364  2017-03-17 23:00  orcle大作业\源代码\backend\DatabaseDesign\.settings\org.eclipse.jdt.core.prefs
     文件         494  2017-04-04 21:42  orcle大作业\源代码\backend\DatabaseDesign\.settings\org.eclipse.wst.common.component
     文件         305  2017-04-20 23:14  orcle大作业\源代码\backend\DatabaseDesign\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2017-03-17 23:00  orcle大作业\源代码\backend\DatabaseDesign\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2017-03-17 23:00  orcle大作业\源代码\backend\DatabaseDesign\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.svn\
     文件           3  2018-12-20 19:08  orcle大作业\源代码\backend\DatabaseDesign\.svn\entries
     文件           3  2018-12-20 19:08  orcle大作业\源代码\backend\DatabaseDesign\.svn\format
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\21\
     文件        4674  2018-12-20 19:08  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\21\219f7669252f59488a232e3963a63f4ba104d3e0.svn-base
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\3d\
     文件       18821  2018-12-20 19:08  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\3d\3dd1313aaeed91bb04bb774122632e0c8a850b5b.svn-base
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\90\
     文件        1154  2018-12-20 19:08  orcle大作业\源代码\backend\DatabaseDesign\.svn\pristine\90\9001c7c2b1f1a05c675cf432793dcaa2b0e3f2ab.svn-base
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\.svn\tmp\
     目录           0  2018-12-25 14:11  orcle大作业\源代码\backend\DatabaseDesign\.svn\tmp\prop-base\
     目录           0  2018-12-25 14:11  orcle大作业\源代码\backend\DatabaseDesign\.svn\tmp\props\
     目录           0  2018-12-25 14:11  orcle大作业\源代码\backend\DatabaseDesign\.svn\tmp\text-base\
     文件       36864  2018-12-20 19:08  orcle大作业\源代码\backend\DatabaseDesign\.svn\wc.db
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\WebContent\
     目录           0  2018-12-25 11:47  orcle大作业\源代码\backend\DatabaseDesign\WebContent\meta-INF\
............此处省略117个文件信息