MyJavawebProject/src/com/dao/StuDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
import com.entity.Stu;
import com.util.DBconn;
 
public class StuDaoImpl implements StuDao{
	//1.注册
		public boolean register(Stu stu) {
			boolean flag = false;
			DBconn.init();
			int i =DBconn.addUpdDel("insert into stu(name,pwd,sex,home,grades,info) " +
					"values('"+stu.getName()+"','"+stu.getPwd()+"','"+stu.getSex()+"','"+stu.getHome()+"','"+stu.getGrades()+"','"+stu.getInfo()+"')");
			if(i>0){
				flag = true;
			}
			DBconn.closeConn();
			return flag;
		}
		//2.登录(学生与管理员的区别是查找的表不一样)
		//(学生)
	    public boolean stulogin(String name, String pwd) {
			boolean flag = false;
			try {
				    DBconn.init();
					ResultSet rs = DBconn.selectSql("select * from stu where name='"+name+"' and pwd='"+pwd+"'");
					while(rs.next()){
						if(rs.getString("name").equals(name) && rs.getString("pwd").equals(pwd)){
							flag = true;
						}
					}
					DBconn.closeConn();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			return flag;
		}
	  //(管理员)
	    public boolean mgrlogin(String name, String pwd) {
			boolean flag = false;
			try {
				    DBconn.init();
					ResultSet rs = DBconn.selectSql("select * from mgr where name='"+name+"' and pwd='"+pwd+"'");
					while(rs.next()){
						if(rs.getString("name").equals(name) && rs.getString("pwd").equals(pwd)){
							flag = true;
						}
					}
					DBconn.closeConn();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			return flag;
		}
	  //3.返回用户信息集合
		public List<Stu> getStuAll() {
			List<Stu> list = new ArrayList<Stu>();