JavaWeb简单科研管理系统(jsp+Mysql8.0)

最新推荐文章于 2023-05-07 09:53:40 发布
最新推荐文章于 2023-05-07 09:53:40 发布
阅读量814 收藏 7
点赞数 1
分类专栏： java 文章标签： java intellij-idea myeclipse
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wxlinlin/article/details/122377495
版权

课程设计

具备部分增、删、改、查功能，无JavaScrip，前端界面只有普通得表格，后端代买写这写着关系就写乱了。
项目文件

Bean代码

AdminiUserBean.java（这个bean作废了，后面没用）

package com.linlin.bean;

public class AdminiUserBean {
	private String admini_no;
	private String admini_passwd;
	public void setAdmini_no(String admini_no) {
		this.admini_no=admini_no;
	}
	public void setAdmini_passwd(String admini_passwd) {
		this.admini_passwd=admini_passwd;
	}
	public String getAdmini_no() {
		return admini_no;
	}
	public String getAdmini_passwd() {
		return admini_passwd;
	}
}

ProjectAuditBean.java

package com.linlin.bean;

public class ProjectAuditBean {
	private String rese_no;
	private String rese_name;
	private String check_projeckname;
	private String check_projmoney;
	private String check_start;
	private String check_end;
	private String check_status;
	private String check_name;
	private String check_no;
	public void setRese_no(String rese_no) {
		this.rese_no=rese_no;
	}
	public void setRese_name(String rese_name) {
		this.rese_name=rese_name;
	}
	public void setCheck_projeckname(String check_projieckname) {
		this.check_projeckname=check_projieckname;
	}
	public void setCheck_projmoney(String check_projmoney) {
		this.check_projmoney=check_projmoney;
	}
	public void setCheck_start(String check_start) {
		this.check_start=check_start;
	}
	public void setCheck_end(String check_end) {
		this.check_end=check_end;
	}
	public void setCheck_status(String check_status) {
		this.check_status=check_status;
	}
	public void setCheck_name(String check_name) {
		this.check_name=check_name;
	}
	public void setCheck_no(String check_no) {
		this.check_no=check_no;
	}
	
	public String getCheck_projeckname() {
		return check_projeckname;
	}
	public String getCheck_projmoney() {
		return check_projmoney;
	}
	public String getCheck_start() {
		return check_start;
	}
	public String getCheck_end() {
		return check_end;
	}
	public String getCheck_status() {
		return check_status;
	}
	public String getCheck_name() {
		return check_name;
	}
	public String getRese_no() {
		return rese_no;
	}
	public String getRese_name() {
		return rese_name;
	}
	public String getCheck_no() {
		return check_no;
	}
}

ResearchersBean.java

package com.linlin.bean;

public class ResearchersBean {
	private String rese_no;
	private String rese_name;
	private String rese_sex;
	private String rese_birthday;
	private String rese_degree;
	private String rese_profess;
	private String rese_dapart;
	private String total_paper;
	private String total_rewark;
	private String total_prizewinner;
	
	
	public void setRese_no(String rese_no) {
		this.rese_no=rese_no;
	}
	public void setRese_name(String rese_name) {
		this.rese_name=rese_name;
	}
	public void setRese_sex(String rese_sex) {
		this.rese_sex=rese_sex;
	}
	public void setRese_birthday(String rese_birthday) {
		this.rese_birthday=rese_birthday;
	}
	public void setRese_degree(String rese_degree) {
		this.rese_degree=rese_degree;
	}
	public void setRese_profess(String rese_profess) {
		this.rese_profess=rese_profess;
	}
	public void setRese_dapart(String rese_dapart) {
		this.rese_dapart=rese_dapart;
	}
	public void setTotal_paper(String total_paper) {
		this.total_paper=total_paper;
	}
	public void setTotal_rewark(String total_rewark) {
		this.total_rewark=total_rewark;
	}
	public void setTotal_prizewinner(String total_prizewinner) {
		this.total_prizewinner=  total_prizewinner;
	}
	
	
	
	public String getRese_no() {
		return rese_no;
	}
	public String getRese_name() {
		return rese_name;
	}
	public String getRese_sex() {
		return rese_sex;
	}
	public String getRese_birthday() {
		return rese_birthday;
	}
	public String getRese_degree() {
		return rese_degree;
	}
	public String getRese_profess() {
		return rese_profess;
	}
	public String getRese_dapart() {
		return rese_dapart;
	}
	public String getTotal_paper() {
		return total_paper;
	}
	public String getTotal_rewark() {
		return total_rewark;
	}
	public String getTotal_prizewinner() {
		return total_prizewinner;
	}
}

ResearchersUserBean.java

package com.linlin.bean;

public class ResearchersUserBean {
	private String rese_no;
	private String rese_name;
	private String rese_sex;
	private String rese_birthday;
	private String rese_degree;
	private String rese_profess;
	private String rese_dapart;
	private String rese_passwd;
	private String role;
	
	public void setRese_no(String rese_no) {
		this.rese_no=rese_no;
	}
	public void setRese_name(String rese_name) {
		this.rese_name=rese_name;
	}
	public void setRese_sex(String rese_sex) {
		this.rese_sex=rese_sex;
	}
	public void setRese_birthday(String rese_birthday) {
		this.rese_birthday=rese_birthday;
	}
	public void setRese_degree(String rese_degree) {
		this.rese_degree=rese_degree;
	}
	public void setRese_profess(String rese_profess) {
		this.rese_profess=rese_profess;
	}
	public void setRese_dapart(String rese_dapart) {
		this.rese_dapart=rese_dapart;
	}
	public void setRese_passwd(String rese_passwd) {
		this.rese_passwd=rese_passwd;
	}
	public void setRole(String role) {
		this.role=role;
	}
	
	
	public String getRese_no() {
		return rese_no;
	}
	public String getRese_name() {
		return rese_name;
	}
	public String getRese_sex() {
		return rese_sex;
	}
	public String getRese_birthday() {
		return rese_birthday;
	}
	public String getRese_degree() {
		return rese_degree;
	}
	public String getRese_profess() {
		return rese_profess;
	}
	public String getRese_dapart() {
		return rese_dapart;
	}
	public String getRese_Passwd() {
		return rese_passwd;	
	}
	public String gerRole() {
		return role;
	}
}

UserBean.java

package com.linlin.bean;

public class UserBean {
	private String rese_no;
	private String rese_passwd;
	public void setRese_no(String rese_no) {
		this.rese_no=rese_no;
	}
	public void setRese_passwd(String rese_passwd) {
		this.rese_passwd=rese_passwd;
	}
	public String getRese_no() {
		return rese_no;
	}
	public String getRese_passwd() {
		return rese_passwd;
	}
}

Dao

BaseDao.java

package com.linlin.dao;

import java.sql.SQLException;
import java.util.List;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.bean.ResearchersBean;
import com.linlin.bean.ResearchersUserBean;

public interface BaseDao<T> {
//	/**
//	 * @param check_no
//	 * @return 通过check_no查询单个 
//	 * @throws Exception
//	 */
	T get(String rese_no) throws  Exception;
/**
 * 
 * @param check_status
 * @return 未通过审核的项目
 * @throws Exception
 */
	List<T> getlist(String check_status) throws Exception;
	/**
	 * @return 查询全部
	 * @throws Exception
	 */
	List<T> list() throws Exception;
	/**
	 * @return 统计总数
	 * @throws Exception
	 */
	Integer count() throws Exception;
	/**
	 * @param 研究院编号rese_no
	 * @return  指定研究院成果信息
	 * @throws Exception
	 */
	//T getreseinfo(String rese_no) throws Exception;
	T getreseinfo(String rese_no) throws Exception;
	T getreseproinfo(String rese_no) throws Exception;
	boolean del(String rese_no) throws Exception;
}

ProjectAuditeDao.java

package com.linlin.dao;

import com.linlin.bean.ProjectAuditBean;

public interface ProjectAuditeDao extends BaseDao<ProjectAuditBean>{
	
}

ResearchersDao.java

package com.linlin.dao;

import com.linlin.bean.ResearchersBean;

public interface ResearchersDao extends BaseDao<ResearchersBean>{


}

ResearchersUserDao.java

package com.linlin.dao;

import com.linlin.bean.ResearchersBean;

public interface ResearchersUserDao extends BaseDao<ResearchersBean> {

}

ReseUserDao.java

package com.linlin.dao;

import java.sql.SQLException;

import com.linlin.bean.UserBean;

public interface UserDao {
	/**
	 * @param user,role
	 * @return 返回登录是否成功
	 * @throws Exception
	 */
	UserBean findUser(UserBean user, String role) throws SQLException;
}

Dao.impl

BaseDaoImpl.java

package com.linlin.dao.impl;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ScalarHandler;

import com.linlin.dao.BaseDao;
import com.linlin.dao.util.DataSourceUtil;

public abstract class BaseDaoImpl<T> implements BaseDao<T>{
	/**
	 * 表名字
	 */
	protected String tableName = tableName();
	
	/**
	 * 子类可以通过重写配置表名
	 */
	protected abstract String tableName();
	/**
	 * 统计记录数
	 */
	@Override
	public Integer count() throws Exception {
		 String sql = "SELECT COUNT(*) FROM " + tableName;
		 QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		 return queryRunner.query(sql, new ScalarHandler<Number>(1)).intValue();
	}
}

ProjectAuditeDaoImpl.java

package com.linlin.dao.impl;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.dao.ProjectAuditeDao;
import com.linlin.dao.util.DataSourceUtil;

public class ProjectAuditeDaoImpl extends BaseDaoImpl<ProjectAuditBean> implements ProjectAuditeDao{


	@Override
	public List<ProjectAuditBean> list() throws Exception {
		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		return (List<ProjectAuditBean>) queryRunner.query("select * from submitprojeckinfo", new BeanListHandler(ProjectAuditBean.class));
	}

	@Override
	protected String tableName() {
		// TODO 自动生成的方法存根
		return "submitprojeckinfo";
	}

	@Override
	public ProjectAuditBean get(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource()); 	
		return (ProjectAuditBean) queryRunner.query("select * from total_rese where rese_no=?", new BeanListHandler(ProjectAuditBean.class),rese_no);
	}

	@Override
	public List<ProjectAuditBean> getlist(String check_status) throws Exception {
		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		return (List<ProjectAuditBean>) queryRunner.query("select * from submitprojeckinfo where check_status=?", new BeanListHandler(ProjectAuditBean.class),check_status);
	}

	public boolean update_aucheck(String status,String check_no) throws Exception {
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		int row=queryRunner.update("update aucheck set check_status=? where check_no=?",status,check_no);
		System.out.println(row);
			return row>=1;
	}
//	@Override
//	public ProjectAuditBean get(String check_no) throws Exception {
//		// TODO 自动生成的方法存根
//		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
//		return queryRunner.query("select * from submitprojeckinfo ", beanHandler);
//	}

	@Override
	public ProjectAuditBean getreseinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		
		return null;
	}

	public ProjectAuditBean getreseproinfo(String rese_no) throws SQLException {
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		return (ProjectAuditBean) queryRunner.query("select * from submitprojeckinfo where rese_no=?", new BeanHandler(ProjectAuditBean.class),rese_no);
	}

	@Override
	public boolean del(String rese_no) throws Exception {
		return false;
		// TODO 自动生成的方法存根
	}


}

ResearchersDaoImpl.java

package com.linlin.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.linlin.bean.ResearchersBean;
import com.linlin.dao.ResearchersDao;
import com.linlin.dao.util.DataSourceUtil;

public class ResearchersDaoImpl extends BaseDaoImpl<ResearchersBean> implements ResearchersDao{

	@Override
	public List<ResearchersBean> list() throws Exception {
		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		return (List<ResearchersBean>) queryRunner.query("select * from total_rese", new BeanListHandler(ResearchersBean.class));
	}

	@Override
	protected String tableName() {
		// TODO 自动生成的方法存根
		return "total_rese";
	}

	@Override
	public ResearchersBean get(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		return (ResearchersBean) queryRunner.query("select * from total_rese where rese_no=?",new BeanHandler(ResearchersBean.class),rese_no);
	}

	@Override
	public List<ResearchersBean> getlist(String check_status) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}
	
//	public List<ResearchersBean> getreseinfo() throws Exception {
//		return null;
//		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		return (List<ResearchersBean>) queryRunner.query("CALL total_researchers('114141');", new BeanListHandler(ResearchersBean.class));
//	}

	@Override
	public ResearchersBean getreseinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource()); 	
		return (ResearchersBean) queryRunner.query("select * from total_rese where rese_no=?", new BeanListHandler(ResearchersBean.class),rese_no);
	}

	@Override
	public ResearchersBean getreseproinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public boolean del(String rese_no) throws Exception {
		return false;
		// TODO 自动生成的方法存根

	}

	
}

ResearchersUserDaoImpl.java

package com.linlin.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.bean.ResearchersBean;
import com.linlin.bean.ResearchersUserBean;
import com.linlin.dao.ResearchersUserDao;
import com.linlin.dao.util.DataSourceUtil;

public class ResearchersUserDaoImpl extends BaseDaoImpl<ResearchersBean> implements ResearchersUserDao{

	@Override
	public ResearchersBean get(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public List<ResearchersBean> getlist(String check_status) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}
	
	public boolean insert_researchers(ResearchersUserBean userbean) throws Exception {
		QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
		int row=queryRunner.update( "insert into researchers(rese_no,rese_name,rese_passwd,role,rese_sex,rese_birthday,rese_degree,rese_profess,rese_dapart) values(?,?,?,?,?,?,?,?,?)",
				userbean.getRese_no(),userbean.getRese_name(),userbean.getRese_Passwd(),
				userbean.gerRole(),userbean.getRese_sex(),userbean.getRese_birthday(),
				userbean.getRese_degree(),userbean.getRese_profess(),userbean.getRese_dapart());
		return row>=1;
	}

	
	@Override
	public List<ResearchersBean> list() throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	protected String tableName() {
		// TODO 自动生成的方法存根
		return "researchers";
	}

	@Override
	public ResearchersBean getreseinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public ResearchersBean getreseproinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public boolean del(String rese_no) throws Exception {
		return false;
		// TODO 自动生成的方法存根

	}

}

UserDaoImpl.java

package com.linlin.dao.impl;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import com.linlin.bean.UserBean;
import com.linlin.dao.UserDao;
import com.linlin.dao.util.DataSourceUtil;


public class UserDaoImpl implements UserDao {

	@Override
	public UserBean findUser(UserBean user, String role) throws SQLException {
		// TODO 自动生成的方法存根
			QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());
			//String sql = "select * from administrator where admini_no=? and admini_passwd=?";
			String sql = "select * from researchers where rese_no=? and rese_passwd=? and role=?";
			UserBean isuser = (UserBean) queryRunner.query(sql, new BeanHandler(UserBean.class), new Object[] {user.getRese_no(),user.getRese_passwd(),role});
			return isuser;
	}
	

}

dao.util

DataSourceUtil.java

package com.linlin.dao.util;


import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory;

public class DataSourceUtil {
	
	private static DataSource ds;
	
	/**
	 *  获取数据源
	 */
	public static DataSource getDataSource() {
		return ds;
	}
	
	/**
	 *  获取数据库连接
	 * @throws SQLException
	 */
	public static Connection getConnection() throws SQLException {
		return ds.getConnection();
	}
 	/**
	 * 初始化
	 */ 
	static {
		//c3p0
//		ds = new ComboPooledDataSource("dev");
		
		//dbcp
		try(InputStream is = DataSourceUtil.class.getClassLoader().getResourceAsStream("dbcp.properties")) {
			Properties props = new Properties();
			props.load(is);
			ds = BasicDataSourceFactory.createDataSource(props);
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	
 	/**
	 * 测试
	 */ 
	public static void main(String[] args) throws SQLException {
		System.out.println(getConnection().getMetaData());
	}

}

filter

package com.linlin.filter;
import java.io.IOException;
import java.io.UnsupportedEncodingException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletRequestWrapper;
import javax.servlet.http.HttpServletResponse;

@WebFilter("/*")
public class CharacterFilter implements Filter {
	public void init(FilterConfig filterConfig) throws ServletException {
	}
	public void doFilter(ServletRequest req, ServletResponse resp,
			FilterChain chain) throws IOException, ServletException {
		
		HttpServletRequest request = (HttpServletRequest) req;
		HttpServletResponse response = (HttpServletResponse) resp;
		
		// 拦截所有的请求 解决全站中文乱码
		// 指定 request 和 response 的编码
		request.setCharacterEncoding("utf-8"); // 只对消息体有效
		
		//响应消息
		response.setContentType("text/html;charset=utf-8");
		
		// 对request进行包装
		CharacterRequest characterRequest = new CharacterRequest(request);
		chain.doFilter(characterRequest, response);
	}
	public void destroy() {
	}
}
// 继承 默认包装类HttpServletRequestWrapper
// 解决Tomcat 7 下get请求乱码
class CharacterRequest extends HttpServletRequestWrapper {
	public CharacterRequest(HttpServletRequest request) {
		super(request);
	}
	// 子类继承父类一定会覆写一些方法，此处用于重写getParamter()方法
	public String getParameter(String name) {
		// 调用被包装对象的getParameter()方法，获得请求参数
		String value = super.getParameter(name);
		if (value == null)
			return null;
		// 判断请求方式
		String method = super.getMethod();
		if ("get".equalsIgnoreCase(method)) {
			try {
					value = new String(value.getBytes("iso-8859-1"), "utf-8");
			} catch (UnsupportedEncodingException e) {
				throw new RuntimeException(e);
			}
		}
		// 解决乱码后返回结果
		return value;
	}
}

service

BaseService.java

package com.linlin.service;

import java.util.List;

public interface BaseService<T> {
	/**
	 * 查询单个
	 */
	T get(String check_no) throws Exception;

	T getreseinfo(String rese_no) throws Exception;
	
	
	/**
	 * 查询全部
	 */
	List<T> list() throws Exception;
	/**
	 * 查询个数
	 */
	int count() throws Exception;

}

LoginService.java

package com.linlin.service;

import java.sql.SQLException;

import com.linlin.bean.UserBean;
	public interface LoginService {
		boolean login(UserBean user, String role) throws SQLException;
	}

RegisterResearchersService.java

package com.linlin.service;

import java.sql.SQLException;

import com.linlin.bean.UserBean;

public interface RegisterResearchersService {
	boolean insert(UserBean user, String role) throws SQLException;
}

ResearchersService.java

package com.linlin.service;

import java.sql.SQLException;

import com.linlin.bean.ResearchersBean;

public interface ResearchersService extends BaseService<ResearchersBean>{
	boolean query(ResearchersBean userinfo,String rese_no) throws SQLException;
}

Service.impl

BaseServiceImpl.java

package com.linlin.service.impl;

import java.util.List;

import com.linlin.dao.BaseDao;
import com.linlin.service.BaseService;

public abstract class BaseServiceImpl<T> implements BaseService<T>{
	protected BaseDao<T> dao = getDao();
	
	/**
	 * 由子类实现
	 */
	protected abstract BaseDao<T> getDao() ;
	
	


	@Override
	public List<T> list() throws Exception {
		// TODO 自动生成的方法存根
		return dao.list();
	}

	@Override
	public int count() throws Exception {
		// TODO 自动生成的方法存根
		return dao.count();
	}

}

LoginServiceImpl.java

package com.linlin.service.impl;

import java.sql.SQLException;

import com.linlin.bean.UserBean;
import com.linlin.dao.impl.UserDaoImpl;
import com.linlin.service.LoginService;


public class LoginServiceImpl implements LoginService {
	UserDaoImpl us = new UserDaoImpl();

	@Override
	public boolean login(UserBean user, String role) throws SQLException {
		// TODO 自动生成的方法存根
		UserBean isUser = us.findUser(user,role);
		if (isUser==null) {
			return false;
		}
		else {
			return true;
		}
	}


}

ProjectAuditeServiceImpl.java

package com.linlin.service.impl;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.dao.BaseDao;
import com.linlin.dao.impl.ProjectAuditeDaoImpl;

public class ProjectAuditeServiceImpl extends BaseServiceImpl<ProjectAuditBean>{

	@Override
	protected BaseDao<ProjectAuditBean> getDao() {
		// TODO 自动生成的方法存根
		return new ProjectAuditeDaoImpl();
				}

	@Override
	public ProjectAuditBean get(String check_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public ProjectAuditBean getreseinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

}

ResearcherServiceImpl.java

package com.linlin.service.impl;

import java.sql.SQLException;
import java.util.List;

import com.linlin.bean.ResearchersBean;
import com.linlin.dao.BaseDao;
import com.linlin.service.ResearchersService;

public class ResearchersServiceImpl extends BaseServiceImpl<ResearchersBean> implements ResearchersService {

	@Override
	public ResearchersBean get(String check_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public ResearchersBean getreseinfo(String rese_no) throws Exception {
		// TODO 自动生成的方法存根
		return null;
	}

	@Override
	public boolean query(ResearchersBean userinfo, String rese_no) throws SQLException {
		// TODO 自动生成的方法存根
		return false;
	}

	@Override
	protected BaseDao<ResearchersBean> getDao() {
		// TODO 自动生成的方法存根
		return null;
	}
}

servlet

BaseServlet.java

package com.linlin.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public abstract class BaseServlet extends HttpServlet {

	/**
	 * 转发请求 
	 * @param request
	 * @param response
	 * @param path 转发的/WEB-INF/page/下的目标资源，参数值不含/WEB-INF/page/ 部分  
	 * @throws ServletException
	 * @throws IOException
	 */
	protected void forward(HttpServletRequest request, HttpServletResponse response, String path)
	        throws ServletException, IOException {
	    request.getRequestDispatcher(path).forward(request, response);
	}

	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

CheckServlet.java

package com.linlin.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.dao.BaseDao;
import com.linlin.dao.impl.ProjectAuditeDaoImpl;

@WebServlet("/CheckServlet")
public class CheckServlet extends HttpServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
  		BaseDao<ProjectAuditBean> service = new ProjectAuditeDaoImpl();
		List<ProjectAuditBean> alltable;
		try {
			alltable = service .getlist("审核中");
			System.out.println("审核中");
			req.setAttribute("datas", alltable);
			forward(req,resp,"/check.jsp");
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
	}
	
	/**
	 * 转发请求 
	 * @param request
	 * @param response
	 * @param path 转发的/WEB-INF/page/下的目标资源，参数值不含/WEB-INF/page/ 部分  
	 * @throws ServletException
	 * @throws IOException
	 */
	protected void forward(HttpServletRequest request, HttpServletResponse response, String path)
	        throws ServletException, IOException {
	    request.getRequestDispatcher(path).forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

DeleteServlet.java

package com.linlin.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.linlin.dao.impl.ReseUserDaoImpl;
@WebServlet("/DeleteServlet")
public class DeleteServlet extends BaseServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		String rese_no = req.getParameter("rese_no");
		ReseUserDaoImpl rudi = new ReseUserDaoImpl();
		
		System.out.println("开始删除"+rese_no);
		try {
			if(rudi.del(rese_no)) {
				System.out.println("删除成功");
				req.setAttribute("dele","删除成功");
				forward(req, resp, "/QueryReseinfoServlet");
				
			}
			else {
				req.setAttribute("dele","删除失败");
				forward(req, resp, "/QueryReseinfoServlet");
			}
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
		
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

LoginServlet.java

package com.linlin.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.bean.ResearchersBean;
import com.linlin.bean.UserBean;
import com.linlin.dao.BaseDao;
import com.linlin.dao.ProjectAuditeDao;
import com.linlin.dao.impl.ProjectAuditeDaoImpl;
import com.linlin.dao.impl.ResearchersDaoImpl;
import com.linlin.service.impl.LoginServiceImpl;


@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String username = req.getParameter("username");
		String password = req.getParameter("password");
		UserBean user = new UserBean();
		user.setRese_no(username);
		user.setRese_passwd(password);
		System.out.println(user.getRese_no());
		LoginServiceImpl userimpl = new LoginServiceImpl();
		//判断权限获取选项值
		String role = req.getParameter("access");
		System.out.println(role);
		
				try {
					if (userimpl.login(user,role)) {
						//判断用户权限
						if(role.equals("1")){
					  		BaseDao<ProjectAuditBean> service = new ProjectAuditeDaoImpl();
							List<ProjectAuditBean> alltable = service .list();
							System.out.println(alltable);
							System.out.println(alltable.get(0).getCheck_no());
							System.out.println(alltable.get(1).getCheck_no());
							req.setAttribute("datas", alltable);
							req.getSession().setAttribute("user", user);
							forward(req,resp,"/admini.jsp");
						}
						else {
					  		BaseDao<ResearchersBean> service = new ResearchersDaoImpl();
							ResearchersBean alltable = service .get(username);
							System.out.println(alltable);
							System.out.println(alltable.getRese_no());
							req.setAttribute("datas", alltable);
							req.getSession().setAttribute("user", user);
							forward(req,resp,"/reselogin.jsp");
							
							//resp.sendRedirect(req.getContextPath()+"/reselogin.jsp");
						}
						//HttpSession session = req.getSession();
						
					} else {
						if(role.equals("1")) {
							req.setAttribute("errerMsg","非管理员账户或用户名或密码错误");
						} else {
							req.setAttribute("errerMsg","非教师账户或用户名或密码错误");
							req.getRequestDispatcher("login.jsp").forward(req, resp);
						}
						req.getRequestDispatcher("login.jsp").forward(req, resp);
					}
				} catch (SQLException e) {
					// TODO 自动生成的 catch 块
					e.printStackTrace();
				} catch (ServletException e) {
					// TODO 自动生成的 catch 块
					e.printStackTrace();
				} catch (IOException e) {
					// TODO 自动生成的 catch 块
					e.printStackTrace();
				} catch (Exception e) {
					// TODO 自动生成的 catch 块
					e.printStackTrace();
				}
			}

/**
 * 转发请求 
 * @param request
 * @param response
 * @param path 转发的/WEB-INF/page/下的目标资源，参数值不含/WEB-INF/page/ 部分  
 * @throws ServletException
 * @throws IOException
 */
protected void forward(HttpServletRequest request, HttpServletResponse response, String path)
        throws ServletException, IOException {
    request.getRequestDispatcher(path).forward(request, response);
}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		this.doPost(req, resp);
	}
}

LogouServlet.java

package com.linlin.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/LogoutServlet")
public class LogouServlet extends HttpServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		req.getSession().removeAttribute("user");
		resp.sendRedirect(req.getContextPath()+"/login.jsp");
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}

}

QueryReseinfoServlet.java

package com.linlin.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.linlin.bean.ResearchersUserBean;
import com.linlin.dao.BaseDao;
import com.linlin.dao.impl.ReseUserDaoImpl;
import com.linlin.dao.impl.ResearchersUserDaoImpl;
@WebServlet("/QueryReseinfoServlet")
public class QueryReseinfoServlet extends BaseServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		ResearchersUserDaoImpl rud = new ResearchersUserDaoImpl();
		
  		BaseDao<ResearchersUserBean> service = new ReseUserDaoImpl();
		List<ResearchersUserBean> alltable;
		try {
			alltable = service .list();
			System.out.println(alltable);
//			System.out.println(alltable.get(0).getRese_no());
//			System.out.println(alltable.get(1).getRese_no());
			
			req.setAttribute("datas", alltable);
			forward(req,resp,"/reseinfo.jsp");
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}

	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

QueryServlet.java

package com.linlin.servlet;

import java.io.IOException;



import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.linlin.bean.ResearchersBean;
import com.linlin.dao.BaseDao;
import com.linlin.dao.impl.ResearchersDaoImpl;


@WebServlet("/QueryServlet")
public class QueryServlet extends HttpServlet{
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		String user_no = req.getParameter("rese_no");
		System.out.println("开始查询"+user_no);
		BaseDao<ResearchersBean> service = new ResearchersDaoImpl(); 
		ResearchersBean alltable;
		try {
			alltable = service .get(user_no);
			if(alltable!=null) {
				System.out.println(user_no); 							
				System.out.println(alltable.getRese_no()); 							
				req.setAttribute("datas", alltable); 							
				forward(req,resp,"/query.jsp");
			}
			else {
				req.setAttribute("error","没有该人员");
				forward(req,resp,"/query.jsp");
			}
			
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		} 		
	}
	/**
	 * 转发请求 
	 * @param request
	 * @param response
	 * @param path 转发的/WEB-INF/page/下的目标资源，参数值不含/WEB-INF/page/ 部分  
	 * @throws ServletException
	 * @throws IOException
	 */
	protected void forward(HttpServletRequest request, HttpServletResponse response, String path)
	        throws ServletException, IOException {
	    request.getRequestDispatcher(path).forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

RegisterServlet.java

package com.linlin.servlet;

import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;

import com.linlin.bean.ResearchersUserBean;
import com.linlin.dao.impl.ResearchersUserDaoImpl;
@WebServlet("/Register")
public class RegisterServlet extends HttpServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根;
		System.out.println("register");
		ResearchersUserDaoImpl reg = new ResearchersUserDaoImpl();
		Map<String,String[]> map = req.getParameterMap();
		ResearchersUserBean user = new ResearchersUserBean();
		try {
			BeanUtils.populate(user,map);
		} catch (IllegalAccessException e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
		System.out.println(user.getRese_name());
		System.out.println(user.getRese_no());
		//开始插入数据库
		try {
			if(reg.insert_researchers(user)) {
				System.out.println("注册成功");
				req.setAttribute("info","研究员"+user.getRese_name()+"注册成功");
				req.getRequestDispatcher("register.jsp").forward(req, resp);
			}
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
		
	}
	
	/**
	 * 转发请求 
	 * @param request
	 * @param response
	 * @param path 转发的/WEB-INF/page/下的目标资源，参数值不含/WEB-INF/page/ 部分  
	 * @throws ServletException
	 * @throws IOException
	 */
	protected void forward(HttpServletRequest request, HttpServletResponse response, String path)
	        throws ServletException, IOException {
	    request.getRequestDispatcher(path).forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

RereProServlet.jva

package com.linlin.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.linlin.bean.ProjectAuditBean;
import com.linlin.bean.UserBean;
import com.linlin.dao.BaseDao;
import com.linlin.dao.impl.ProjectAuditeDaoImpl;
@WebServlet("/ReseServlet")
public class ReseProServlet extends BaseServlet{
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		HttpSession session = req.getSession();
		UserBean user = (UserBean) session.getAttribute("user");
		ProjectAuditeDaoImpl padi = new ProjectAuditeDaoImpl();
		System.out.println("登录用户"+user.getRese_no());
		try {
			
			BaseDao<ProjectAuditBean> service = new ProjectAuditeDaoImpl();
			ProjectAuditBean alltable = service.getreseproinfo(user.getRese_no());
			req.setAttribute("datas", alltable);
			forward(req,resp,"/resepro.jsp");
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

UpdateServlet.java

package com.linlin.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.linlin.dao.impl.ProjectAuditeDaoImpl;



@WebServlet("/UpdateServlet")
public class UpdateServlet extends HttpServlet{
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		ProjectAuditeDaoImpl padi = new ProjectAuditeDaoImpl();
		String check = req.getParameter("check");
		String check_no = req.getParameter("check_no");
		System.out.println(check_no);
		if(check==null) {
			
			return;
		}
		System.out.println(check);
		if(check.equals("yes")) {
			try {
				System.out.println("更新");
				padi.update_aucheck("通过", check_no);
			} catch (Exception e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			}
			req.setAttribute("updatesuccess","更新成功");
			forward(req, resp, "/CheckServlet");
		}
		else if(check.equals("no")) {
			System.out.println("更新no");
			try {
				padi.update_aucheck("不予通过", check_no);
			} catch (Exception e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			}
			forward(req, resp, "/CheckServlet");
		}
		else {
			System.out.println("waiting");
			forward(req, resp, "/CheckServlet");
			//forward(req, resp, "/CheckServlet");
		}
	}
	
	/**
	 * 转发请求 
	 * @param request
	 * @param response
	 * @param path 
	 * @throws ServletException
	 * @throws IOException
	 */
	protected void forward(HttpServletRequest request, HttpServletResponse response, String path)
	        throws ServletException, IOException {
	    request.getRequestDispatcher(path).forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO 自动生成的方法存根
		this.doGet(req, resp);
	}
}

配置文件

 #连接设置
 driverClassName=com.mysql.cj.jdbc.Driver
 url=jdbc:mysql://localhost:3306/gxkygl?useSSL=false&serverTimezone=CST&characterEncoding=utf-8
 username=root
 password=123456
 #初始化连接
 initialSize=5
 #最大连接数量
 maxActive=10
 #最大空闲连接
 maxIdle=3000

JSP

admini.jsp

在这里插入代<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <title></title>
  </head>
  <body style="text-align:center;">
	<h1>管理员界面</h1>
	<span>管理员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
	<br>
	<div style="margin:0 auto">
	<form action="${pageContext.request.contextPath }/CheckServlet" method="post" >
	<input type="submit" value="开始审核" />
	</form><br />
	<form action="${pageContext.request.contextPath }/register.jsp" method="post" >
	<input type="submit" value="注册研究员" />
	</form>
	<form action="${pageContext.request.contextPath }/QueryReseinfoServlet">
		<input type="submit" value="查询教师基本信息"/>
	</form>
	<form action="${pageContext.request.contextPath }/QueryServlet" method="post" >
		<label>请输入研究人员编号</label>
		<input type="text" name="rese_no" />
		<input type="submit" value="查询研究人员信息" />
	</form>

	</div>
	<div style="margin:0 auto">
	     <table border="1" cellspacing="0" style="margin:0 auto">
	     <caption><h3>审核表</h3></caption>
	     	 <tr>
	     	 	<td><h3>审核号</h3></td>
	     	 	<td><h3>项目名</h3></td>
	     	 	<td><h3>研究员姓名</h3></td>
	     	 	<td><h3>项目经费</h3></td>
	     	 	<td><h3>项目启动时间</h3></td>
	     	 	<td><h3>项目状态</h3></td>
	     	 	<td><h3>项目结束时间</h3></td>
	     	 	<td><h3>审核人员</h3></td>
	     	 </tr>
	     	<c:forEach items="${datas}" var="item">
	     	<tr>
	     	 <td>${item.check_no }</td>
	         <td>${item.rese_name }</td>
	         <td>${item.check_projeckname }</td>
	         <td>${item.check_projmoney }</td>
	         <td>${item.check_start }</td>
	         <td>${item.check_status }</td>
	         <td>${item.check_end }</td>
	         <td>${item.check_name }</td>
	        </tr>
	        </c:forEach>
	     </table>  
	</div>
  </body>
</html>
码片

check.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <title></title>
  </head>
  <body style="text-align:center;">
	<h1>管理员界面</h1>
	<span>管理员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
	<br>
	<div style="margin:0 auto">
	     <table border="1" cellspacing="0" style="margin:0 auto">
	     <caption><h3>待审核表</h3></caption>
	     	 <tr>
	     	 	<td><h3>序号</h3></td>
	     	 	<td><h3>审核号</h3></td>
	     	 	<td><h3>项目名</h3></td>
	     	 	<td><h3>研究员姓名</h3></td>
	     	 	<td><h3>项目经费</h3></td>
	     	 	<td><h3>项目提交时间</h3></td>
	     	 	<td><h3>项目状态</h3></td>
	     	 	<td><h3>审核人员</h3></td>
	     	 	<td><h3>是否通过</h3></td>
	     	 </tr>
	     	<c:forEach items="${datas}" var="item">
	     	<tr>
	     	 <td>${status.count }</td>
	     	 <td>${item.check_no }</td>
	         <td>${item.rese_name }</td>
	         <td>${item.check_projeckname }</td>
	         <td>${item.check_projmoney }</td>
	         <td>${item.check_start }</td>
	         <td>${item.check_status }</td>
	         <td>${item.check_name }</td>
	         <td><form action="${pageContext.request.contextPath }/UpdateServlet" method="post">
	         <select name="check_no" id="access" lay-verify="required">
	         	<option value="${item.check_no }">审核号</option>
	         </select>
	         	<input type="radio" name="check" value="yes" />通过
	        	<input type="radio" name="check" value="no" />不予通过
	        	<input type="radio" name="check" value="waiting" />待讨论
	        	<input type="submit" value="提交" />
	         </form></td>
	        </tr>
	        </c:forEach>
	     </table>  
	</div>
  </body>
</html>

login.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" 
pageEncoding="UTF-8" %>
<!DOCTYPE html>
<head>
    <meta charset="utf-8" />
    <title>登录页面</title>
</head>
<body style="text-align:center">
<h2 style="color:red;">${errerMsg }</h2>
	<form action="${pageContext.request.contextPath }/loginServlet" metho="post" />
	<table border="1" width="600px" cellpadding="0" cellspacing="0" align="center">
		<tr>
			<td height="30" align="center">用户名</td>
			<td>&nbsp;&nbsp;
			<input type="text" name="username" /></td>
		</tr>
		<tr>
			<td height="30" align="center">密&nbsp;&nbsp;码</td>
			<td>&nbsp;&nbsp;
			<input type="password" name="password" /></td>
		</tr>
		<tr>
			<td height="30" colspan="2" align="center">
			<input type="submit" value="登录" />
			&nbsp;&nbsp;&nbsp;&nbsp;
			<select name="access" id="access" lay-verify="required">
					<option value="1">管理员</option>
					<option value="2">教师</option>
			</select>
			</td>
		</tr>
	</table>
</body>
</html>

query.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <title></title>
  </head>
  <body style="text-align:center;">
	<h1>管理员界面</h1>
	<span>管理员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
	<br>
	<div style="margin:0 auto">
	<h3 style="color:red;">${error }</h3>
	<form action="${pageContext.request.contextPath }/QueryServlet" method="post" >
		<label>请输入研究人员编号</label>
		<input type="text" name="rese_no" />
		<input type="submit" value="查询研究人员信息" />
	</form>

	</div>
	<div style="margin:0 auto">
	
	     <table border="1" cellspacing="0" style="margin:0 auto">
	     <caption><h3>研究人员信息表</h3></caption>
	     	 <tr>
				<td>编号</td>
				<td>姓名</td>
				<td>性别</td>
				<td>出生日期</td>
				<td>学位</td>
				<td>职称</td>
				<td>部门</td>
				<td>发表论文数</td>
				<td>获奖数</td>
				<td>出版著作数</td>
	     	 </tr>
	     	<tr>
				<td>${datas.rese_no }</td>
				<td>${datas.rese_name }</td>
				<td>${datas.rese_sex }</td>
				<td>${datas.rese_birthday }</td>
				<td>${datas.rese_degree }</td>
				<td>${datas.rese_profess }</td>
				<td>${datas.rese_dapart }</td>
				<td>${datas.total_paper }</td>
				<td>${datas.total_rewark }</td>
				<td>${datas.total_prizewinner }</td>
	        </tr>
	     </table>  
	</div>
  </body>
</html>

register.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <title></title>
  </head>
<body style="text-align:center">
<h2 style="color:red;">研究员注册</h2>
<span>管理员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
<h3 style="color:blue;">${info }</h3>
	<form action="${pageContext.request.contextPath }/Register" method="post" >
	<table border="1" width="600px" cellpadding="0" cellspacing="0" align="center">
		<tr>
			<td height="30" align="center">姓名</td>
			<td>&nbsp;&nbsp;
			<input type="text" name="rese_name" /></td>
		</tr>
		<tr>
			<td height="30" align="center">账号</td>
			<td>&nbsp;&nbsp;
			<input type="text" name="rese_no" /></td>
		</tr>
		<tr>
			<td height="30" align="center">密码</td>
			<td>&nbsp;&nbsp;
			<input type="password" name="rese_passwd" /></td>
		</tr>
		<tr>
			<td height="30" align="center">权限</td>
			<td>&nbsp;&nbsp;
			<select name="role" id="access" lay-verify="required">
					<option value="1">管理员</option>
					<option value="2">教师</option>
			</select>
			</td>
		</tr>
		<tr>
			<td height="30" align="center">性别</td>
			<td>&nbsp;&nbsp;
			<select name="rese_sex" id="access" lay-verify="required">
					<option value="1">男</option>
					<option value="2">女</option>
			</select>
			</td>
		</tr>
		<tr>
			<td height="30" align="center">出生日期</td>
			<td>&nbsp;&nbsp;
			<input type="date" name="rese_birthday" /></td>
			<input name="birthday" id="date1" autocomplete="off" class="layui-input" type="text">
		</tr>
		<tr>
			<td height="30" align="center">学位</td>
			<td>&nbsp;&nbsp;
			<input type="text" name="rese_degree" /></td>
		</tr>
		<tr>
			<td height="30" align="center">职称</td>
			<td>&nbsp;&nbsp;
			<input type="text" name="rese_profess" /></td>
		</tr>
		<tr>
			<td height="30" align="center">部门</td>
			<td>&nbsp;&nbsp;
			<input type="text" name="rese_dapart" /></td>
		</tr>
		<tr>
			<td height="30" colspan="2" align="center">
			<input type="submit" value="注册" />
			</td>
		</tr>
	</table>
	</form>
</body>
</html>

reseinfo.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <title></title>
  </head>
  <body style="text-align:center;">
	<h1>管理员界面</h1>
	<span>管理员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
	<br>
	<div style="margin:0 auto">
<h3 style="color:blue;">${dele }</h3>
	</div>
	<div style="margin:0 auto">
	     <table border="1" cellspacing="0" style="margin:0 auto">
	     <caption><h3>人员信息表</h3></caption>
	     	 <tr>
	     	 	<td><h3>编号</h3></td>
	     	 	<td><h3>姓名名</h3></td>
	     	 	<td><h3>性别</h3></td>
	     	 	<td><h3>出生日期</h3></td>
	     	 	<td><h3>学位</h3></td>
	     	 	<td><h3>职称</h3></td>
	     	 	<td><h3>部门</h3></td>
	     	 </tr>
	     	<c:forEach items="${datas}" var="item">
	     	<tr>
	     	 <td>${item.rese_no }</td>
	         <td>${item.rese_name }</td>
	         <td>${item.rese_sex }</td>
	         <td>${item.rese_birthday }</td>
	         <td>${item.rese_degree }</td>
	         <td>${item.rese_profess }</td>
	         <td>${item.rese_dapart }</td>
	        <td>
	        <form action="${pageContext.request.contextPath }/DeleteServlet" method="post">
	        <select name="rese_no" id="access" lay-verify="required">
	         	<option value="${item.rese_no }">编号</option>
	        </select>
	         	<input type="submit" name="check" value="删除" />
	        </form></td>
	        </tr>
	        </c:forEach>
	     </table>  
	</div>
  </body>
</html>

reselogin.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>

<!DOCTYPE html>
<html>
  <head>
    <title>教师登录界面</title>
  </head>
  <body style="text-align:center;">
	<h1>教师登录界面</h1>
	<span>研究员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
	<div style="test-align:center;">
	<form action="${pageContext.request.contextPath }/ReseServlet" method="post" >
	
		<input type="submit" value="查询研究人员信息" />
	</form>
	<table  border="1" width="600px" cellpadding="0" cellspacing="0" align="center">
		<tr>
		<td>编号</td>
		<td>姓名</td>
		<td>性别</td>
		<td>出生日期</td>
		<td>学位</td>
		<td>职称</td>
		<td>部门</td>
		<td>发表论文数</td>
		<td>获奖数</td>
		<td>出版著作数</td>
	</tr>
	<tr>
		<td>${datas.rese_no }</td>
		<td>${datas.rese_name }</td>
		<td>${datas.rese_sex }</td>
		<td>${datas.rese_birthday }</td>
		<td>${datas.rese_degree }</td>
		<td>${datas.rese_profess }</td>
		<td>${datas.rese_dapart }</td>
		<td>${datas.total_paper }</td>
		<td>${datas.total_rewark }</td>
		<td>${datas.total_prizewinner }</td>
	</td>
	</table>
	</div>
  </body>
</html>

resepro.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8" language="java" 
pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <title></title>
  </head>
  <body style="text-align:center;">
	<h1>教师界面</h1>
	<span>研究员:${user.rese_no }</span><a href="${pageContext.request.contextPath }/LogoutServlet">注销</a>
	<br>
	<div style="margin:0 auto">

	</div>
	<div style="margin:0 auto">
	     <table border="1" cellspacing="0" style="margin:0 auto">
	     <caption><h3>我的项目表</h3></caption>
	     	 <tr>
	     	 	<td><h3>审核号</h3></td>
	     	 	<td><h3>项目名</h3></td>
	     	 	<td><h3>研究员姓名</h3></td>
	     	 	<td><h3>项目经费</h3></td>
	     	 	<td><h3>项目启动时间</h3></td>
	     	 	<td><h3>项目状态</h3></td>
	     	 	<td><h3>项目结束时间</h3></td>
	     	 	<td><h3>审核人员</h3></td>
	     	 </tr>
	     	<tr>
	     	 <td>${datas.check_no }</td>
	         <td>${datas.rese_name }</td>
	         <td>${datas.check_projeckname }</td>
	         <td>${datas.check_projmoney }</td>
	         <td>${datas.check_start }</td>
	         <td>${datas.check_status }</td>
	         <td>${datas.check_end }</td>
	         <td>${datas.check_name }</td>
	        </tr>
	     </table>  
	</div>
  </body>
</html>

SQL部分（这是不同时期做的数据库，数据库功能较多只做了一点点）

CREATE TABLE `gxkygl`.`Untitled`  (
  `rese_no` char(6) NOT NULL COMMENT '研究人员编号',
  `rese_name` char(12) NOT NULL COMMENT '姓名',
  `rese_sex` enum('男','女') COMMENT '性别',
  `rese_birthday` date COMMENT '出生日期',
  `rese_degree` char(4) COMMENT '学位',
  `rese_profess` char(12) COMMENT '职称',
  `rese_dapart` char(50) COMMENT '部门',
  PRIMARY KEY (`rese_no`)
);


CREATE TABLE `aucheck`  (
  `check_no` char(10) NOT NULL COMMENT '审核号',
  `check_reseno` char(6) NOT NULL COMMENT '科研人员编号',
  `check_projmoney` int(0) COMMENT '项目经费',
  `check_projeckname` char(60)  COMMENT '项目名称',
  `check_start` date  COMMENT '提交时间',
  `check_end` date COMMENT '审核时间',
  `check_status` enum('审核中','通过','不予通过') COMMENT '审核状态',
  `check_name` char(10) COMMENT '审核人',
  PRIMARY KEY (`check_no`) USING BTREE,
  INDEX `jajf_KEY`(`check_reseno`) USING BTREE,
  CONSTRAINT `jajf_KEY` FOREIGN KEY (`check_reseno`) REFERENCES `researchers` (`rese_no`)
);

CREATE TABLE `projeck`  (
  `projeck_no` char(20) COMMENT '项目编号',
  `projeck_name` char(60) COMMENT '项目名称',
  `projeck_money` int(0) COMMENT '项目经费',
  `projeck_date` date COMMENT '立项时间',
  `projeck_status` enum('在研','完成','暂停','撤销','审核中')COMMENT '项目状态',
  PRIMARY KEY (`projeck_no`) USING BTREE,
  UNIQUE INDEX `index_pro`(`projeck_no`) USING BTREE
);




CREATE TABLE `scirese`  (
  `projeck_no` char(20) COMMENT '项目编号',
  `rese_no` char(6) COMMENT '科研人员编号',
  PRIMARY KEY (`projeck_no`, `rese_no`) USING BTREE,
  INDEX `rese_KEY`(`rese_no`) USING BTREE,
  CONSTRAINT `peojeck_KEY` FOREIGN KEY (`projeck_no`) REFERENCES `projeck` (`projeck_no`),
  CONSTRAINT `rese_KEY` FOREIGN KEY (`rese_no`) REFERENCES `researchers` (`rese_no`)
);



CREATE TABLE `paper`  (
  `paper_no` char(20)  NOT NULL COMMENT '论文编号',
  `paper_name` char(60)  COMMENT '论文名称',
  `paper_author` char(6)  NOT NULL COMMENT '论文作者编号',
  `paper_publish` char(60)  COMMENT '出版社',
  `paper_qkno` char(20)  COMMENT '期刊号',
  `paper_date` date COMMENT '出版时间',
  PRIMARY KEY (`paper_no`) USING BTREE,
  INDEX `jfja_KEY`(`paper_author`) USING BTREE,
  CONSTRAINT `jfja_KEY` FOREIGN KEY (`paper_author`) REFERENCES `researchers` (`rese_no`)
);



CREATE TABLE `prizewinner`  (
  `prizewinner_no` char(20) NOT NULL COMMENT '著作编码',
  `prizewinner_name` char(60)  COMMENT '著作名称',
  `prizewinner_author` char(6) NOT NULL COMMENT '作者编码',
  `prizewinner_bookno` char(20)  COMMENT '书号',
  `prizewinner_publish` char(40)  COMMENT '出版社',
  `prizewinner_date` date  COMMENT '出版时间',
  PRIMARY KEY (`prizewinner_no`) USING BTREE,
  INDEX `prizewinner_key`(`prizewinner_author`) USING BTREE,
  UNIQUE INDEX `index_prize`(`prizewinner_no`) USING BTREE,
  CONSTRAINT `prizewinner_key` FOREIGN KEY (`prizewinner_author`) REFERENCES `researchers` (`rese_no`)
);




CREATE TABLE `reward`  (
  `reward_no` char(20) NOT NULL COMMENT '获奖编号',
  `reward_name` char(60)  COMMENT '成果名称',
  `reward_author` char(6) NOT NULL COMMENT '作者编码',
  `reward_rename` char(20)  COMMENT '奖励名称',
  `reward_degree` enum('特等奖','一等奖','二等奖','三等奖')  COMMENT '奖励等级',
  `reward_rank` enum('国家级','省部级','市级','校级')  COMMENT '奖励级别',
  PRIMARY KEY (`reward_no`) USING BTREE,
  INDEX `reward`(`reward_author`) USING BTREE,
  CONSTRAINT `reward` FOREIGN KEY (`reward_author`) REFERENCES `researchers` (`rese_no`)
);



CREATE TABLE `administrator`  (
  `admini_no` char(20) NOT NULL COMMENT '管理员账号',
  `admini_name` char(10) COMMENT '管理员姓名',
  `admini_passwd` char(20) NOT NULL COMMENT '管理员密码'
);

CREATE TABLE `person`  (
  `person_no` char(10) NOT NULL COMMENT '用户账号',
  `person_passwd` char(20) NOT NULL COMMENT '密码',
  PRIMARY KEY (`person_no`) USING BTREE
);

--添加缩印
ALTER TABLE `gxkygl`.`paper` 
ADD UNIQUE INDEX `index_paper`(`paper_name`);

ALTER TABLE `gxkygl`.`paper` 
DROP INDEX `author_key`,
DROP INDEX `index_paper`,
ADD UNIQUE INDEX `author_key`(`paper_author`) USING BTREE,
ADD INDEX `index_paper`(`paper_name`) USING BTREE;

ALTER TABLE `gxkygl`.`researchers` 
ADD INDEX `index_rese`(`rese_no`);

ALTER TABLE `gxkygl`.`projeck` 
ADD UNIQUE INDEX `index_pro`(`projeck_no`);

CREATE UNIQUE INDEX index_admi ON administrator(admini_no);
CREATE UNIQUE INDEX index_person ON person(person_no);

--查看科研人员研究项目的视图
CREATE VIEW `reseofprojeck` AS SELECT
	researchers.rese_no,
	researchers.rese_name,
	projeck.projeck_no,
	projeck.projeck_name,
	projeck.projeck_money,
	projeck.projeck_date,
	projeck.projeck_status 
FROM
	projeck
	INNER JOIN scirese ON projeck.projeck_no = scirese.projeck_no
	INNER JOIN researchers ON researchers.rese_no = scirese.rese_no;




  --查看科研人员具体获奖信息的视图
CREATE VIEW `reseofreward` AS SELECT
	researchers.rese_name, 
	reward.*
FROM
	researchers
	INNER JOIN
	reward
	ON 
		researchers.rese_no = reward.reward_author;


--查看体检项目审核情况
CREATE VIEW submitprojeckinfo AS SELECT
	researchers.rese_no, 
	researchers.rese_name, 
	aucheck.check_projmoney, 
	aucheck.check_projeckname, 
	aucheck.check_start, 
	aucheck.check_end, 
	aucheck.check_status, 
	aucheck.check_name
FROM
	aucheck
	INNER JOIN
	researchers
	ON 
		aucheck.check_reseno = researchers.rese_no;

--查看科研人员论文情况
CREATE VIEW count_paper AS SELECT
	researchers.*, 
	COUNT(paper.paper_no) AS total_paper
FROM
	paper
	INNER JOIN
	researchers
	ON 
		paper.paper_author = researchers.rese_no
	GROUP BY
		rese_no;

--查看科研人员著作相关情况
CREATE VIEW count_prizewinner AS SELECT
	researchers.*, 
	COUNT(prizewinner.prizewinner_no) AS total_prizewinner
FROM
	prizewinner
	INNER JOIN
	researchers
	ON 
		prizewinner.prizewinner_author = researchers.rese_no
	GROUP BY
		rese_no;

--查看科研人员获奖信息
CREATE VIEW jutihuojiang AS SELECT
	researchers.*, 
	COUNT(reward.reward_no) AS total_reward
FROM
	reward
	INNER JOIN
	researchers
	ON 
		reward.reward_author = researchers.rese_no
	GROUP BY
		rese_no;

害！总算是完成了老师的要求

傲娇小霖霖
关注
专栏目录
基于java的科研信息管理平台
【完整】
02-21 1159
欢迎添加微信互相交流学习哦！ 项目源码：https://gitee.com/oklongmm/biye 摘要:随着计算机应用水平的提高和科研管理的规范化和制度化，建立一套适用于高校科研管理工作管理信息系统，已经成为各大高校较为迫切的需求。科研信息管理平台主要实现对高校科研情况的有效管理以及对科研活动的全程跟踪。通过科研管理信息化平台，可以实现科研工作的网络化管理，形成一个及时更新的科研数据中心和科研管理沟通平台，全面、实时、准确提供学校的有关科研信息，为学校领导有关科研决策提供辅助支持，为学校教师
jsp高校科研项目管理系统Java源码
07-22
jsp高校科研项目管理系统Java源码
JAVA的科研管理系统设计
Gefangenes的博客
05-07 139
科研项目管理系统，以项目化管理为思想，以现实中管理制度为核心，对科研项目申报、项目开题、项目合同、实施进度、项目风险分析及控制计划、项目经费、项目质量、项目文档、科研成果等科研活动全面管理，实现科研项目“管理标准的沉淀优化、组织流程的优化、管理水平的提升、内外部资源整合的延伸”，保障科研项目完成与落实，出人才、出成果、出效益，提高竞争力。在对网络工具的认知程度上，较为传统的office软件等仍是人们使用的主要工具，而相对全面且专业的信息管理软件仍没有得到大多数人的了解或认可。
基于java语言的高校科研成果管理系统
07-20
系统实现对高校科研成果信息的管理，分为管理员模块和教师模块。登录系统统一使用工号和密码，管理员分配所有教师的工号和初始密码，不需要注册。一个较为简略的界面，功能不是很完善
科研管理系统
05-19
科研管理系统，运用jsp和SQL sever2008开发，本论文关于web的网络科研管理
基于Servlet+jsp+mysql开发javaWeb学生成绩管理系统
10-19
系统采用技术：Servlet+jsp+mysql+jQuery+bootstrap+面向接口编程 系统管理员： 个人信息管理，课程管理，成绩管理，学生信息管理，教师管理，所有账号管理等。 教师： 个人信息管理，课程管理，成绩管理，...
javaWeb项目：基于servlet+jsp+mysql实现的学生宿舍管理系统
最新发布
11-06
本项目是一套基于servlet学生宿舍管理系统，主要针对计算机相关专业的正在做bishe的学生和需要项目实战练习的Java学习者。 包含：项目源码、数据库脚本等，该项目可以直接作为bishe使用。 项目都经过严格调试，确保...
javaweb学生成绩管理系统课程设计代码 基于Servlet+jsp+mysql开发javaWeb学生成绩管理系统
07-01
javaweb学生成绩管理系统课程设计代码 基于Servlet+jsp+mysql开发javaWeb学生成绩管理系统 系统环境：Windows10 开发工具：Eclipse4.8.0 / MyEclipse2014 / IDEA 编码集：UTF-8 Java版本：JDK 1.8 服务器：tomcat ...
基于JavaWeb + Mysql + Layui实现的宿舍管理系统源码+数据库+演示截图+项目说明.zip
08-22
基于JavaWeb + Mysql + Layui实现的宿舍管理系统源码+数据库+演示截图+项目说明.zip 1、该资源内项目代码都是经过测试运行成功，功能ok的情况下才上传的，请放心下载使用！ 2、本项目适合计算机相关专业(如计科、...
Java项目:车险理赔管理系统(java+SSM+JSP+echarts+jQuery+Mysql)
07-09
车险理赔管理系统源码，分为三个用户，一个管理员，一个工作人员，一个普通人员 管理员功能：登录、发放赔偿金、赔偿金发放列表、申请理赔列表、申请理赔通过、我的资料、用户列表 工作人员功能：勘察员-待调查事故...
科研项目管理系统
06-10
开发的项目申报系统功能齐，本系统是一个采用基于网络运行的，面向政府的对外公共服务协作的项目审批事务处理，实现对科技项目申报审批的有效执行、监督和管理的电子政务应用系统。通过实施该系统，将可实现以下目标：
基于WEB的科研管理系统源代码
10-15
J2EE项目开发 SSH框架 MYSQL数据库
jsp连接mysql
01-11
jsp连接mysql
高校科研管理系统源码
04-04
vb户籍管理系统源码
高校科研管理系统
12-18
大型的开发项目，有重要的参考价值，涉及MVC项目实践，包含web,servlet,后台是MySql数据库，是个项目文件，下载就可一运行。。。
基于javaweb+jsp的高校科研项目管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)
m0_70029952的博客
04-22 2216
基于javaweb+jsp的高校科研项目管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot) JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap. 基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot...均可 开发工具：eclipse/idea/myeclip
【20】基于java的科研管理系统实现
qq_42526473的博客
05-29 838
文章目录SSM 科研项目申报系统 可用做政府部门或大学项目申报背景及意义主要功能项目搭建环境项目实现数据库的设计部分核心代码实现项目部分功能展示登录页面管理员功能教师角色学生角色 SSM 科研项目申报系统 可用做政府部门或大学项目申报 背景及意义 目前许多人仍将传统的纸质工具作为信息管理的主要工具，而网络技术的应用只是起到辅助作用。在对网络工具的认知程度上，较为传统的office软件等仍是人们使用的主要工具，而相对全面且专业的信息管理软件仍没有得到大多数人的了解或认可。本选题则旨在通过标签分类管理等方式，
java基于mvc的高校教师科研信息管理系统
QQ58850198的博客
09-04 483
本文的主要内容包括MyEclipse ，MySQL数据库，Java语言的基本概念及高级应用，JSP与数据库的连接。此次系统研究的主要内容与基本要求有：注册登录模块的实现，分为教师和学生注册登录并且可以修改自己的个人信息密码；教师接收学生并处理学生的申请，管理信息的填写、修改，并且可以增加科研项目；前台学生和老师是一样的，后台差别在于学生只能查询，而教师可以修改项目信息并且处理学生申请页面中的信息。主要模块有：学生管理模块、科研项目管理模块、项目申请管理模块、教师管理模块、班级管理模块、管理员管理模块。
java科研管理系统项目总结_java实现科研信息管理系统
weixin_34826752的博客
02-26 202
package科研信息管理系统;import javax.swing.*;import java.awt.*;import java.awt.event.*;import javax.swing.event.*;import javax.swing.tree.*;public class WindowsView implements TreeSelectionListener,ActionList...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值