基于SSM框架的个人相册样例代码

 junitjunit4.11testorg.slf4jslf4j-api1.7.12ch.qos.logbacklogback-core1.1.1ch.qos.logbacklogback-classic1.1.1mysqlmysql-connector-java5.1.35runtimec3p0c3p00.9.1.1org.mybatismybatis3.3.0org.mybatismybatis-spring1.2.3taglibsstandard1.1.2jstljstl1.2com.fasterxml.jackson.corejackson-databind2.5.4javax.servletjavax.servlet-api3.1.0org.springframeworkspring-core4.1.7.RELEASEorg.springframeworkspring-beans4.1.7.RELEASEorg.springframeworkspring-context4.1.7.RELEASEorg.springframeworkspring-jdbc4.1.7.RELEASEorg.springframeworkspring-tx4.1.7.RELEASEorg.springframeworkspring-web4.1.7.RELEASEorg.springframeworkspring-webmvc4.1.7.RELEASEorg.springframeworkspring-test4.1.7.RELEASEredis.clientsjedis2.7.3com.dyuproject.protostuffprotostuff-core1.0.8com.dyuproject.protostuffprotostuff-runtime1.0.8commons-fileuploadcommons-fileupload1.3.1

public interface PictureDao {
  /**
   * @return 返回所有图片
   */
  List getAllPictures();

  /**上传图片，并且将图片名，图片描述信息插入数据库
   * @param picName
   * @param content
   * @return插入成功返回1，失败0
   */
  int InsertPicture(@Param("picName") String picName, @Param("content") String content);
}

public interface UserDao {
  /**如果查询到该用户就会返回1
   * @param username,pwd
   * @return数据库被修改的行数
   */
  User getUserByName(@Param("username") String username, @Param("pwd") String pwd);
}

  SELECT * FROM USER WHERE username=#{username} AND pwd=#{pwd}

    SELECT * FROM PICTURE
  
    INSERT INTO `picture` (`picname`,`content`) VALUES (#{picName},#{content})
  

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/picture?useUnicode=true&characterEncoding=utf-8
jdbc.username=Elric
jdbc.password=881010

public interface UserService {
  /**本次中我们只需要对用户身份做出判断然后给予url
   * @return 数据库查询到为1
   */
  User CheckUser(String username, String pwd);
}

public interface PictureService {
  /**查询所有照片
   * @return 所有照片
   */
  List getAllPicture();

  /**
   * 这个服务就是PictureDao中的InsertP
   * @param picName
   * @param content
   * @return 数据库成功返回1，失败返回0
   */
  int InsertPicture(String picName, String content);
}

@Service
public class PictureServiceImpl implements PictureService {
  @Autowired
  private PictureDao pictureDao;

  public List getAllPicture() {
    return pictureDao.getAllPictures();
  }
  public int InsertPicture(String picName, String content) {
    return pictureDao.InsertPicture(picName,content);
  }
}

@Service
public class UserServiceImpl implements com.koali.service.UserService {
  @Autowired
  private UserDao userDao;
  public User CheckUser(String username, String pwd) {
    return userDao.getUserByName(username,pwd);
  }
}

  seckill-dispatcherorg.springframework.web.servlet.DispatcherServletcontextConfigLocationclasspath:spring/spring-*.xmlseckill-dispatcher/characterEncodingFilterorg.springframework.web.filter.CharacterEncodingFilterencodingUTF-8forceEncodingtruecharacterEncodingFilter/*

@Controller
public class MainController {
  @Autowired
  private PictureService pictureService;
  @Autowired
  private UserService userService;
  @RequestMapping(value = "/")
  public String index(Model model){
    List pictures =pictureService.getAllPicture();
    System.out.println(pictures.size());
    model.addAttribute("pictures",pictures);
    return "index";
  }
  @RequestMapping(value = "login")
  public String login(){
    return "login";
  }
  @RequestMapping(value = "checkandRedict")
  public String checkAndRedict(@Param("username") String username,@Param("pwd") String pwd){
    User user = userService.CheckUser(username,pwd);
    System.out.println(user);
    if (user!=null){
      return "upload";
    }else {
      return "index";
    }
  }
  @RequestMapping(value = "upload",method = RequestMethod.POST)
  public String upload(@RequestParam("file") MultipartFile file,@Param("content") String content, HttpServletRequest request,Model model) throws IOException{
    //获取项目的根路径，将上传图片的路径与我们的资源路径在一起，才能显示
    HttpSession session= request.getSession();
    String path = session.getServletContext().getRealPath("/");
    System.out.println("getRealPath('/'):"+path);
    int end = path.indexOf("t",19);
    String prePath = path.substring(0,end);
    String realPath = prePath+"target\\demo\\WEB-INF\\jsp\\images";
    System.out.println("DEBUG:"+realPath);
    String picName = new Date().getTime()+".jpg";
    if (!file.isEmpty()){
      FileUtils.copyInputStreamToFile(file.getInputStream(),new File(realPath,new Date().getTime()+".jpg"));
    }else if(content==null){
      content = "";//如果输入为null数据库不允许插入
    }
    //图片类的名字保存为路径+名字方便后期前端提取
    //将图片名字用时间戳保存，反正上传图片为中文乱码等问题
    int code = pictureService.InsertPicture("images/"+picName,content);
    if (code==1) {
      List pictures = pictureService.getAllPicture();
      model.addAttribute("pictures", pictures);
      return "index";
    }else
      return "index";
  }
}