package com.hp.dao;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import com.hp.domain.Project;
import com.hp.domain.Task;
public interface TaskMapper {
//显示
public List<Task> findAll(Task task);
//组合查询
@Select("select * from project")
public List<Project> chaxun();
//删除
@Delete("delete from task where taskid=#{taskid}")
public void del(Integer taskid);
//修改
@Update("update task set taskstate=2,finishedtime=now()where taskid=#{taskid}")
public void upd(Integer taskid);
//添加
@Insert("insert task(projectid,taskpriority,content)values(#{projectid},#{taskpriority},#{content})")
public void add(Task task);
}
//登录
@Select("select * from User where username=#{username} and password=#{password}")
public User dl(User user);
@RequestMapping("/login")
public ModelAndView dl(User user)
{
ModelAndView mv=new ModelAndView();
User u=userService.dl(user);
if(u==null)
{
mv.setViewName("login");
}
else
{
mv.setViewName("redirect:/findAll");
}
return mv;
}
时间转换@DTF
web
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>SSM08</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>SSM08</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc-servlet.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>SSM08</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>
</web-app>