配置文件信息，完成学生管理页面(前后端全部代码)"/>
SSM(Spring SpringMVC MyBatis)配置文件信息，完成学生管理页面(前后端全部代码)
效果图（elementUI）
项目结构
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns=""xmlns:xsi=""xsi:schemaLocation=" .xsd"version="4.0"><servlet><servlet-name>DispatcherServlet</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:springmvc.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>DispatcherServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping><filter><filter-name>CharacterEncodingFilter</filter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class><init-param><param-name>encoding</param-name><param-value>utf-8</param-value></init-param></filter><filter-mapping><filter-name>CharacterEncodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><filter><filter-name>httpPutFormContentFilter</filter-name><filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class></filter><filter-mapping><filter-name>httpPutFormContentFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping>
</web-app>springMVC
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns=""xmlns:xsi=""xmlns:context=""xmlns:mvc=""xsi:schemaLocation="://www.springframework/schema/beans/spring-beans.xsd://www.springframework/schema/context/spring-context.xsd://www.springframework/schema/mvc/spring-mvc-3.2.xsd"><!--扫描包--><context:component-scan base-package="com.etime.controller"></context:component-scan><mvc:annotation-driven></mvc:annotation-driven><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/"></property><property name="suffix" value=".html"></property></bean>
</beans>spring
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns=""xmlns:xsi=""xmlns:context=""xmlns:aop=""xmlns:tx=""xsi:schemaLocation="://www.springframework/schema/beans/spring-beans.xsd://www.springframework/schema/context/spring-context.xsd://www.springframework/schema/aop/spring-aop.xsd://www.springframework/schema/tx/spring-tx.xsd"><!--扫描包--><context:component-scan base-package="com.etime.service"></context:component-scan><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.etime.dao"></property></bean><!--数据源--><context:property-placeholder location="classpath:db.properties"/><bean id="pool" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/></bean><!--mybatis的核心工厂对象--><bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!--注入数据源--><property name="dataSource" ref="pool"/><!--配置别名--><property name="typeAliasesPackage" value="com.etime.pojo"/><!--dao文件配置--><property name="mapperLocations" value="classpath:com/etime/dao/*.xml"/><!--分页插件--><property name="plugins"><array><bean class="com.github.pagehelper.PageInterceptor"></bean></array></property><property name="configLocation" value="classpath:mybatis.xml"></property></bean><!--事务--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="pool"/></bean><!--开启注解事务--><tx:annotation-driven transaction-manager="transactionManager"/>
</beans>myBatis
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configurationPUBLIC "-//mybatis//DTD Config 3.0//EN"".dtd">
<configuration><settings><!-- 打印查询语句 --><setting name="logImpl" value="STDOUT_LOGGING" /></settings>
</configuration>studentDao.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapperPUBLIC "-//mybatis//DTD Mapper 3.0//EN"".dtd">
<mapper namespace="com.etime.dao.StudentDao"><!--分页展示--><select id="getAllStudent" parameterType="Student" resultMap="getAllStudentMap">SELECT * FROM student s,class c where s.class_id = c.cid<if test="sname != ''">and sname like concat('%',#{sname},'%')</if><if test="gender != ''">and gender = #{gender}</if><if test="class_id != 0">and class_id = #{class_id}</if></select><resultMap id="getAllStudentMap" type="Student"><id property="sid" column="sid"></id><result property="gender" column="gender"></result><result property="sname" column="sname"></result><association property="clazz" javaType="Clazz"><id property="cid" column="cid"></id><result property="caption" column="caption"></result></association></resultMap><!--查询学生所有课程信息--><select id="getAllCourseBySid" parameterType="int" resultMap="getAllCourseBySidMap">select *from score s,course c,teacher twhere c.cid = s.course_idand c.teacher_id = t.tidand s.student_id = #{sid}</select><resultMap id="getAllCourseBySidMap" type="Score"><id property="sid" column="sid"></id><result property="student_id" column="student_id"></result><result property="course_id" column="course_id"></result><result property="num" column="num"></result><collection property="courses" ofType="Course"><id property="cid" column="cid"></id><result property="cname" column="cname"></result><result property="teacher_id" column="teacher_id"></result><association property="teacher" javaType="Teacher"><id property="tid" column="tid"></id><result property="tname" column="tname"></result></association></collection></resultMap><!--批量删除--><delete id="deleteStudents">delete from student where sid in<foreach collection="array" item="sid" separator="," open="(" close=")">#{sid}</foreach></delete>
</mapper>studentDao
@Repository
public interface StudentDao {List<Student> getAllStudent(Student student);@Select("select * from class")List<Clazz> getAllClass();List<Score> getAllCourseBySid(int sid);int deleteStudents(int[] sids);@Insert("insert into student(gender,class_id,sname) values(#{gender},#{class_id},#{sname})")int addStudent(Student student);@Update("update student set sname = #{sname},class_id=#{class_id},gender=#{gender} where sid = #{sid}")int editStudent(Student student);
}
studentService
@Service
public class StudentServiceImpl implements StudentService {@Autowiredprivate StudentDao studentDao;@Overridepublic PageInfo<Student> getAllStudent(int page,int rows,Student student) {PageHelper.startPage(page,rows);List<Student> list = studentDao.getAllStudent(student);PageInfo<Student> info = new PageInfo<>(list);System.out.println(info);return info;}@Overridepublic List<Score> getAllCourseBySid(int sid) {return studentDao.getAllCourseBySid(sid);}@Overridepublic List<Clazz> getAllClass() {return studentDao.getAllClass();}@Overridepublic boolean deleteStudents(int[] sids) {return studentDao.deleteStudents(sids)==0?false:true;}@Overridepublic boolean addStudent(Student student) {return studentDao.addStudent(student) == 0?false:true;}@Overridepublic boolean editStudent(Student student) {return studentDao.editStudent(student)==0?false:true;}}controller
@Controller
@RequestMapping("student")
@ResponseBody
@CrossOrigin
public class StudentController {@Autowiredprivate StudentService studentService;/*分页展示加搜索*/@GetMapping("getAllStudent")public PageInfo<Student> getAllStudent(int page, int rows, String sname, String gender, String cid) {int cids;if (cid == null || cid == "") {cids = 0;} else {cids = Integer.parseInt(cid);}System.out.println(sname + "," + gender);return studentService.getAllStudent(page, rows, new Student(gender, cids, sname));}/*查所有班级*/@GetMapping("getAllClass")public List<Clazz> getAllClass(){return studentService.getAllClass();}/*查询学生所有课程信息*/@GetMapping("getAllCourseBySid/{sid}")public List<Score> getAllCourseBySid(@PathVariable("sid")int sid) {return studentService.getAllCourseBySid(sid);}/*删除*/@DeleteMapping("deleteStudents")public boolean deleteStudents(@RequestBody int[] sids){return studentService.deleteStudents(sids);}/*添加*/@PostMapping("addStudent")public boolean addStudent(@RequestBody Student student){return studentService.addStudent(student);}/*修改*/@PutMapping("editStudent")public boolean editStudent(@RequestBody Student student){return studentService.editStudent(student);}index.html
<head><title></title><meta charset="UTF-8"><link rel="stylesheet" href="element-ui-2.13.0/lib/theme-chalk/index.css" /><script type="text/javascript" src="vue/vue-v2.6.10.js"></script><script type="text/javascript" src="element-ui-2.13.0/lib/index.js"></script><script type="text/javascript" src="vue/axios-0.18.0.js"></script>
</head><body><div id="app"><template><el-table :data="tableData" @selection-change="handleSelectionChange" size="medium"highlight-current-row="true" style="width: 100%"><el-table-column type="selection" width="55" prop="sid"></el-table-column><el-table-column width="100px" label="序号" type="index"></el-table-column><el-table-column label="姓名" prop="sname"></el-table-column><el-table-column label="性别" prop="gender"></el-table-column><el-table-column label="班级" prop="clazz.caption"></el-table-column><el-table-column><template slot="header" slot-scope="scope"><el-input v-model="search" placeholder="请输入姓名" /></template></el-table-column><el-table-column><template slot="header" slot-scope="scope"><el-select v-model="cid" placeholder="请选择班级"><el-option v-for="item in classes" :key="item.cid" :label="item.caption" :value="item.cid"></el-option></el-select></template></el-table-column><el-table-column><template slot="header" slot-scope="scope"><el-radio v-model="sex" label="男">男</el-radio><el-radio v-model="sex" label="女">女</el-radio></template><template slot-scope="scope"><el-button size="mini" @click="handleLook(scope.$index, scope.row)">查看课程信息</el-button></template></el-table-column><el-table-column><template slot="header" slot-scope="scope"><el-button type="success" @click="findAll()">搜索</el-button></template><template slot-scope="scope"><el-button size="mini" @click="handleEdit(scope.$index, scope.row)">修改</el-button></template></el-table-column></el-table></template><br /><el-row><el-button type="warning" @click="delAll()">删除选中</el-button><el-button type="primary" @click="add()">添加用户</el-button></el-row><template><div class="block" align="right"><el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange":current-page="currentPage" :page-sizes="[3, 4, 5, 6, 7, 8]" :page-size="pageSize"layout="total, sizes, prev, pager, next, jumper" :total="totalCount"></el-pagination></div></template><!-- 查看课程信息 --><el-dialog title="查看课程信息" :visible.sync="dialogFormVisible"><el-form ref="ruleForm" :model="ruleForm" label-width="80px"><el-form-item label="学生姓名"><el-input v-model="ruleForm.sname" style="width: 210px;" readonly></el-input></el-form-item></el-form><el-table :data="tableCourse" @selection-change="handleSelectionChange" size="medium"highlight-current-row="true" style="width: 100%"><el-table-column width="100px" label="序号" type="index"></el-table-column><el-table-column label="课程" prop="courses[0]ame"></el-table-column><el-table-column label="成绩" prop="num"></el-table-column><el-table-column label="老师" prop="courses[0].teacher.tname"></el-table-column></el-table></el-dialog><!--添加学生--><el-dialog title="添加学生信息" :visible.sync="diaAdd"><el-form :model="ruleForm" ref="ruleForm" label-width="100px"><el-form-item label="姓名" prop="sname"><el-input v-model="ruleForm.sname" style="width: 210px;"></el-input></el-form-item><el-form-item label="性別" prop="gender"><el-radio-group v-model="ruleForm.gender"><el-radio label="男">男</el-radio><el-radio label="女">女</el-radio></el-radio-group></el-form-item><el-form-item label="班级" prop="class_id"><el-select v-model="ruleForm.class_id" placeholder="请选择班级"><el-option v-for="item in classes" :key="item.cid" :label="item.caption" :value="item.cid"></el-option></el-select></el-form-item><el-form-item><el-button type="primary" @click="submitForm()">立即添加</el-button></el-form-item></el-form></el-dialog><!--修改--><el-dialog title="修改学生信息" :visible.sync="dialogVisible"><el-form :model="ruleForm" ref="ruleForm" label-width="100px"><el-form-item label="姓名" prop="sname"><el-input v-model="ruleForm.sname" style="width: 210px;"></el-input></el-form-item><el-form-item label="性別" prop="gender"><el-radio-group v-model="ruleForm.gender"><el-radio label="男">男</el-radio><el-radio label="女">女</el-radio></el-radio-group></el-form-item><el-form-item label="班级" prop="class_id"><el-select v-model="ruleForm.clazz.cid" placeholder="请选择班级"><el-option v-for="item in classes" :key="item.cid" :label="item.caption" :value="item.cid"></el-option></el-select></el-form-item><el-form-item><el-button type="primary" @click="submitFormEd()">立即修改</el-button></el-form-item></el-form></el-dialog></div>
</body>
<script>axios.defaults.withCredentials = falsenew Vue({el: "#app",data: {/*表格数据*/tableData: [],tableCourse: [],/*条件查询关键字*/search: '',sex: "",//批量删除存放选中的复选框multipleSelection: [],//存放删除的数据delarr: [],//当前页currentPage: 1,//每页显示条数pageSize: 5,//总条数totalCount: '',//总页数totalPage: '',// 是否展示课程信息对话框dialogFormVisible: false,diaAdd: false,dialogVisible: false,ruleForm: {sid: '',sname: '',gender: '',clazz: '',class_id: '',cid: '',},classes: '',cid: '',},methods: {findAll() {axios({method: "get",url: "http://localhost:8080/day11_war_exploded/student/getAllStudent",params: {page: this.currentPage,rows: this.pageSize,sname: this.search,gender: this.sex,cid: this.cid}}).then(obj => {console.log(obj)this.tableData = obj.data.list;this.totalCount = obj.data.total;});},getAllClass() {axios({method: "get",url: "http://localhost:8080/day11_war_exploded/student/getAllClass",}).then(obj => {this.classes = obj.data});},handleSizeChange: function (size) {this.pageSize = size;this.findAll();},handleCurrentChange: function (currentPage) {this.currentPage = currentPage;this.findAll();},// 详情handleLook(index, row) {this.dialogFormVisible = truethis.ruleForm = rowaxios({method: "get",url: "http://localhost:8080/day11_war_exploded/student/getAllCourseBySid/" + row.sid,}).then(obj => {this.tableCourse = obj.data});},delAll() {//获取删除的IDthis.delarr = [];for (let i = 0; i < this.multipleSelection.length; i++) {this.delarr.push(this.multipleSelection[i].sid);}//判断要删除的文件是否为空if (this.delarr.length == 0) {this.$message.warning("请选择要删除的数据！")} else {this.$confirm("是否确认删除？", "提示", { type: 'warning' }).then(() => {//点击确认删除axios({method: "delete",url: "http://localhost:8080/day11_war_exploded/student/deleteStudents",data: this.delarr}).then(obj => {if (obj.data) {this.$message.success("删除成功");} else {this.$message.console.error("删除失败");}this.findAll();});});}},handleSelectionChange(val) {this.multipleSelection = val;},// 添加add() {this.diaAdd = true;},submitForm() {axios({method: "post",url: "http://localhost:8080/day11_war_exploded/student/addStudent",data: {sname: this.ruleForm.sname,gender: this.ruleForm.gender,class_id: this.ruleForm.class_id}}).then(obj => {if (obj.data) {this.$message.success("添加成功");} else {this.$message.error("添加失败");}this.findAll();});},// 修改handleEdit(index, row) {this.dialogVisible = true;this.ruleForm = row;},submitFormEd() {axios({method: "put",url: "http://localhost:8080/day11_war_exploded/student/editStudent",data: {sname: this.ruleForm.sname,gender: this.ruleForm.gender,class_id: this.ruleForm.clazz.cid,sid:this.ruleForm.sid}}).then(obj => {if (obj.data) {this.$message.success("修改成功");} else {this.$message.error("修改失败");}this.findAll();});},},created() {this.findAll();this.getAllClass();}})
</script></html>更多推荐
SSM(Spring SpringMVC MyBatis)配置文件信息,完成学生管理页面(前后端全部代码)
发布评论