【基于SSM+MySQL+Jsp的高校学生成绩信息管理系统的设计与实现 ---（效果+源代码

最后

我还通过一些渠道整理了一些大厂真实面试主要有：蚂蚁金服、拼多多、阿里云、百度、唯品会、携程、丰巢科技、乐信、软通动力、OPPO、银盛支付、中国平安等初，中级，高级Java面试题集合，附带超详细答案，希望能帮助到大家。

还有专门针对JVM、SPringBoot、SpringCloud、数据库、Linux、缓存、消息中间件、源码等相关面试题。

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

}

public void setClazzId(int clazzId) {

this.clazzId = clazzId;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public String getSex() {

return sex;

}

public void setSex(String sex) {

this.sex = sex;

}

public String getMobile() {

return mobile;

}

public void setMobile(String mobile) {

this.mobile = mobile;

}

public String getQq() {

return qq;

}

public void setQq(String qq) {

this.qq = qq;

}

public InputStream getPhoto() {

return photo;

}

public void setPhoto(InputStream photo) {

this.photo = photo;

}

}

TeacherDao.java

package com.ischoolbar.programmer.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.ischoolbar.programmer.model.Page;

import com.ischoolbar.programmer.model.Student;

import com.ischoolbar.programmer.model.Teacher;

import com.ischoolbar.programmer.util.StringUtil;

public class TeacherDao extends BaseDao {

public boolean addTeacher(Teacher teacher){

String sql = “insert into s_teacher values(null,'”+teacher.getSn()+“‘,’”+teacher.getName()+“'”;

sql += “,'” + teacher.getPassword() + “',” + teacher.getClazzId();

sql += “,'” + teacher.getSex() + “‘,’” + teacher.getMobile() + “'”;

sql += “,'” + teacher.getQq() + “',null)”;

return update(sql);

}

public boolean editTeacher(Teacher teacher) {

// TODO Auto-generated method stub

String sql = “update s_teacher set name = '”+teacher.getName()+“'”;

sql += “,sex = '” + teacher.getSex() + “'”;

sql += “,mobile = '” + teacher.getMobile() + “'”;

sql += “,qq = '” + teacher.getQq() + “'”;

sql += ",clazz_id = " + teacher.getClazzId();

sql += " where id = " + teacher.getId();

return update(sql);

}

public boolean setTeacherPhoto(Teacher teacher) {

// TODO Auto-generated method stub

String sql = “update s_teacher set photo = ? where id = ?”;

Connection connection = getConnection();

try {

PreparedStatement prepareStatement = connection.prepareStatement(sql);

prepareStatement.setBinaryStream(1, teacher.getPhoto());

prepareStatement.setInt(2, teacher.getId());

return prepareStatement.executeUpdate() > 0;

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return update(sql);

}

public boolean deleteTeacher(String ids) {

// TODO Auto-generated method stub

String sql = “delete from s_teacher where id in(”+ids+“)”;

return update(sql);

}

public Teacher getTeacher(int id){

String sql = "select * from s_teacher where id = " + id;

Teacher teacher = null;

ResultSet resultSet = query(sql);

try {

if(resultSet.next()){

teacher = new Teacher();

teacher.setId(resultSet.getInt(“id”));

teacher.setClazzId(resultSet.getInt(“clazz_id”));

teacher.setMobile(resultSet.getString(“mobile”));

teacher.setName(resultSet.getString(“name”));

teacher.setPassword(resultSet.getString(“password”));

teacher.setPhoto(resultSet.getBinaryStream(“photo”));

teacher.setQq(resultSet.getString(“qq”));

teacher.setSex(resultSet.getString(“sex”));

teacher.setSn(resultSet.getString(“sn”));

return teacher;

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return teacher;

}

public List getTeacherList(Teacher teacher,Page page){

List ret = new ArrayList();

String sql = "select * from s_teacher ";

if(!StringUtil.isEmpty(teacher.getName())){

sql += “and name like '%” + teacher.getName() + “%'”;

}

if(teacher.getClazzId() != 0){

sql += " and clazz_id = " + teacher.getClazzId();

}

if(teacher.getId() !=0 ){

sql += " and id = " + teacher.getId();

}

sql += " limit " + page.getStart() + “,” + page.getPageSize();

ResultSet resultSet = query(sql.replaceFirst(“and”, “where”));

try {

while(resultSet.next()){

Teacher t = new Teacher();

t.setId(resultSet.getInt(“id”));

t.setClazzId(resultSet.getInt(“clazz_id”));

t.setMobile(resultSet.getString(“mobile”));

t.setName(resultSet.getString(“name”));

t.setPassword(resultSet.getString(“password”));

t.setPhoto(resultSet.getBinaryStream(“photo”));

t.setQq(resultSet.getString(“qq”));

t.setSex(resultSet.getString(“sex”));

t.setSn(resultSet.getString(“sn”));

ret.add(t);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return ret;

}

public int getTeacherListTotal(Teacher teacher){

int total = 0;

String sql = "select count(*)as total from s_teacher ";

if(!StringUtil.isEmpty(teacher.getName())){

sql += “and name like '%” + teacher.getName() + “%'”;

}

if(teacher.getClazzId() != 0){

sql += " and clazz_id = " + teacher.getClazzId();

}

if(teacher.getId() !=0 ){

sql += " and id = " + teacher.getId();

}

ResultSet resultSet = query(sql.replaceFirst(“and”, “where”));

try {

while(resultSet.next()){

total = resultSet.getInt(“total”);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return total;

}

public Teacher login(String name ,String password){

String sql = “select * from s_teacher where name = '” + name + “’ and password = '” + password + “'”;

ResultSet resultSet = query(sql);

try {

if(resultSet.next()){

Teacher teacher = new Teacher();

teacher.setId(resultSet.getInt(“id”));

teacher.setName(resultSet.getString(“name”));

写在最后

为了这次面试，也收集了很多的面试题！

以下是部分面试题截图

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

setId(resultSet.getInt(“id”));

teacher.setName(resultSet.getString(“name”));

写在最后

为了这次面试，也收集了很多的面试题！

以下是部分面试题截图

[外链图片转存中…(img-3gAuBtN6-1715483454789)]

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取