ssm实现增删改查加高级查询附带源码 eclipse版

Student.java

package cn.weiwei.domain;

import java.math.BigDecimal;
import java.util.Date;

import org.springframework.format.annotation.DateTimeFormat;

public class Student {
	//id
	private Long id;
	//姓名
	private String name;
	//年龄
	private Integer age;
	//性别
	private Boolean sex;
	//工资
	private BigDecimal wages;
	//生日
    //转换前台传过来的时间格式
	@DateTimeFormat(pattern="yyyy-MM-dd")
	private Date date;
	//当前日期
	private Date currentdate =new Date();
	public Student() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Student(Long id, String name, Integer age, Boolean sex, BigDecimal wages, Date date, Date currentdate) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
		this.sex = sex;
		this.wages = wages;
		this.date = date;
		this.currentdate = currentdate;
	}
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
	public Boolean getSex() {
		return sex;
	}
	public void setSex(Boolean sex) {
		this.sex = sex;
	}
	public BigDecimal getWages() {
		return wages;
	}
	public void setWages(BigDecimal wages) {
		this.wages = wages;
	}
	public Date getDate() {
		return date;
	}
	public void setDate(Date date) {
		this.date = date;
	}
	public Date getCurrentdate() {
		return currentdate;
	}
	public void setCurrentdate(Date currentdate) {
		this.currentdate = currentdate;
	}
	@Override
	public String toString() {
		return "Student [id=" + id + ", name=" + name + ", age=" + age + ", sex=" + sex + ", wages=" + wages + ", date="
				+ date + ", currentdate=" + currentdate + "]";
	}
	

}

StudentMapper.java

package cn.weiwei.mapper;

import java.util.List;

import cn.weiwei.domain.Student;
import cn.weiwei.quesy.QuesyStudent;

public interface StudentMapper {
	//查询使用
	List findAll();
	//根据id查询
	Student findOne(Long id);
	//修改
	void update(Student s);
	//删除
	void delete(Long id);
	//新增
	void add(Student s);
	
	//条件查询
	List QuesyStudentAll(QuesyStudent quesy);

}

StudentMapper.xml





	

		select * from student

		
			
				and name like concat('%',#{name},'%')
			
			
				
    =0 and age<18 ]]>
				
				
    =18 and age<50 ]]>
				
				
    =50 ]]>
				

			
			
			
			and sex=1
			
		  
			and sex=0
			
			
			

		

	

	
		delete from student where id= #{id}

	
	
	

		insert into student(name,age,sex,wages,date) values(
		#{name},
		#{age},
		#{sex},
		#{wages},
		#{date}

		)


	
	
	
	
	
		update student set
		name=#{name},age=#{age},sex=#{sex},wages=#{wages},date=#{date} where
		id=#{id}

ISttdentService.java

package cn.weiwei.service;

import java.util.List;

import cn.weiwei.domain.Student;
import cn.weiwei.quesy.QuesyStudent;

public interface IStudentService {
	//查询使用
		List findAll();
		//根据id查询
		Student findOne(Long id);
		//修改
		void update(Student s);
		//删除
		void delete(Long id);
		//新增
		void add(Student s);
		
		//条件查询
		List QuesyStudentAll(QuesyStudent quesy);

}

StudentServiceImpl.java

package cn.weiwei.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.weiwei.domain.Student;
import cn.weiwei.mapper.StudentMapper;
import cn.weiwei.quesy.QuesyStudent;
import cn.weiwei.service.IStudentService;

@Service
public class StudentServiceImpl implements IStudentService {
	
	@Autowired
	private StudentMapper studentMapper;

	@Override
	public List findAll() {
		// TODO Auto-generated method stub
		return studentMapper.findAll();
	}

	@Override
	public Student findOne(Long id) {
		// TODO Auto-generated method stub
		return studentMapper.findOne(id);
	}

	@Override
	public void update(Student s) {
		// TODO Auto-generated method stub
		studentMapper.update(s);

	}

	@Override
	public void delete(Long id) {
		// TODO Auto-generated method stub
		studentMapper.delete(id);

	}

	@Override
	public void add(Student s) {
		// TODO Auto-generated method stub
		studentMapper.add(s);

	}

	@Override
	public List QuesyStudentAll(QuesyStudent quesy) {
		// TODO Auto-generated method stub
		return studentMapper.QuesyStudentAll(quesy);
	}



}

StudentConyroller.java

package cn.weiwei.controller;

import java.util.List;

import org.omg.CosNaming.NamingContextExtPackage.StringNameHelper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import cn.weiwei.domain.Student;
import cn.weiwei.quesy.QuesyStudent;
import cn.weiwei.service.impl.StudentServiceImpl;

@Controller
@RequestMapping("/stu")
public class StudentController {
	
	@Autowired
	private StudentServiceImpl studentServiceImpl;
	
	//查询方法
	@RequestMapping("/list")
	public String list(Model model,QuesyStudent quesy){
//		List findAll = studentServiceImpl.findAll();
		List findAll = studentServiceImpl.QuesyStudentAll(quesy);
		System.out.println(quesy);
		model.addAttribute("student", findAll);
		model.addAttribute("quesy", quesy);
		
		return "student/list";
	}
	
	//删除方法
	@RequestMapping("/del")
	public String  del(Long id){
		studentServiceImpl.delete(id);
		return "redirect:/stu/list";
		
	}
	
	//新增跳转页面   新增和修改
	@RequestMapping("/jump")
	public String Jump(Long id,Model model){
	    if(id!=null){
	    	Student findOne = studentServiceImpl.findOne(id);
	    	model.addAttribute("one", findOne);
	    	System.out.println(findOne);
	    	return "student/update";
	    }
		return "student/add";
		
	}
	
	
	//新增
	@RequestMapping("/add")
	private String add(Student student) {
      
		studentServiceImpl.add(student);
		return "redirect:/stu/list";

		

	}
	//修改
	@RequestMapping("/update")
	public String update(Student student){
		studentServiceImpl.update(student);
		return "redirect:/stu/list";
	}

}

applicationContext-mvc.xml

applicationContext.xml

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///ssm
jdbc.username=root
jdbc.password=root

list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>




Insert title here






	<%-- ${student} --%>
		
	   查询   姓名： 
	
	
	年龄
	性别：
	
	

	
			
		
			序号
			姓名
			年龄
			性别
			工资
			出生年份
			当前日期
			操作
		
		
				${stu.count}
				${s.name}
				${s.age}
				${s.sex?"男":"女"}
				${s.wages}
				
					 
				
				
				修改/删除

序号	姓名	年龄	性别	工资	出生年份	当前日期	操作
${stu.count}	${s.name}	${s.age}	${s.sex?"男":"女"}	${s.wages}			修改/删除

add.jsp

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




Insert title here


    新增
    
      姓名：

        年龄：

     性别 男
      女

          工资：

            生日：

update.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>




Insert title here


    修改
    
    
    
      姓名：

        年龄：

     性别 checked="checked"  >男
      checked="checked" >女

          工资：

          
          
            生日：">

web.xml




	
	
		org.springframework.web.context.ContextLoaderListener

	

	
		contextConfigLocation
		classpath:applicationContext.xml
	
  
  
  
  springMvc
  org.springframework.web.servlet.DispatcherServlet 
     
     contextConfigLocation
     classpath:applicationContext-mvc.xml
     
     
     
     1
     
  
  
  
  
    springMvc
  /
  

    
        EncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
		
			
			encoding
			UTF-8
		
		
		
			forceEncoding
			true
		
    
    
    EncodingFilter
    /*

ssm实现增删改查加高级查询 附带源码 eclipse版

新增 姓名： 年龄： 性别 男 女 工资： 生日： 提交

修改 姓名： 年龄： 性别 checked="checked" >男 checked="checked" >女 工资： 生日："> 提交

Java相关栏目本月热门文章

ssm实现增删改查加高级查询附带源码 eclipse版

新增
姓名：
年龄：
性别男女
工资：
生日：

修改
姓名：
年龄：
性别 checked="checked" >男 checked="checked" >女
工资：
生日：">