微信小程序——个人相册（后端）

微信小程序——个人相册（后端）

1. 项目创建

1. 新建Maven项目，其中Archettype选择“webapp”，以下是项目结构
   

2. 添加项目所需依赖，在pom.xml添加以下内容：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"><modelVersion>4.0.0</modelVersion><groupId>org.hniu</groupId><artifactId>myhome</artifactId><packaging>war</packaging><version>1.0-SNAPSHOT</version><name>myhome Maven Webapp</name><url>http://maven.apache.org</url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><maven.compiler.source>1.8</maven.compiler.source><maven.compiler.target>1.8</maven.compiler.target><java.version>1.8</java.version><spring.version>5.3.16</spring.version><mysql.version>8.0.28</mysql.version><mybatis.version>3.5.2</mybatis.version><mybatis.spring.version>2.1.1</mybatis.spring.version><servlet.version>3.1.0</servlet.version></properties><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis.version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>${mybatis.spring.version}</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.1.0</version><scope>provided</scope></dependency><dependency><groupId>org.apache.httpcomponents</groupId><artifactId>httpclient</artifactId><version>4.5.14</version></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>3.8.1</version><scope>test</scope></dependency><!--jackson依赖--><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-core</artifactId><version>2.11.0</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.11.0</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-annotations</artifactId><version>2.11.0</version></dependency><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.4</version></dependency><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.3.2</version></dependency></dependencies><build><plugins><plugin><!--以下是插件版tomcat7-->
<!--        <groupId>org.apache.tomcat.maven</groupId>-->
<!--        <artifactId>tomcat7-maven-plugin</artifactId>-->
<!--        <version>2.2</version>-->
<!--        <configuration>-->
<!--          <charset>utf-8</charset>-->
<!--          <port>8089</port>-->
<!--          <path>/myhome</path>-->
<!--        </configuration>--><groupId>org.apache.maven.plugins</groupId><artifactId>maven-war-plugin</artifactId><version>3.3.1</version><!--要在下面添加以下配置--><configuration><failOnMissingWebXml>false</failOnMissingWebXml></configuration></plugin></plugins></build>
</project>

3. 建议使用tomcat8~9版本，版本太高或低容易报错，以下配置tomcat
   ①：选择正确路径的Tomcat
   ②：选择对应项目JDK的JRE版本
   ③：选择没有被其他程序占用的端口，默认是8080

4. 配置application.properties，以下代码：
   附：
   获取小程序的appid和appsecret
   进入到小程序的管理控制台（公众平台），选择“开发”——“开发管理”，切换到“开发设置”

db.driver=com.mysql.cj.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/myphoto
db.username=root
#修改为你的MySQL密码
db.password=123456#添加小程序的appid和appsecret
wx.appid=
wx.secret=#file.savePath修改为本机实际保存路径
file.savePath=D:\\myhome\\photo\\
#file.accessUrl：访问路径
file.accessUrl=/photo/

2. 项目代码

1. 创建package com.hniu.myphone.comm.config，config包下创建以下配置类：GlobalConfiguration和Properties

package com.hniu.myphone.comm.config;import com.github.pagehelper.PageInterceptor;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.http.converter.HttpMessageConverter;
import org.springframework.http.converter.StringHttpMessageConverter;
import org.springframework.http.converter.json.MappingJackson2HttpMessageConverter;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.web.multipart.commons.CommonsMultipartResolver;
import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport;import javax.sql.DataSource;
import java.io.IOException;
import java.util.List;
import java.util.Objects;/*** 全局配置文件*/
@Configurationpublic class GlobalConfiguration extends WebMvcConfigurationSupport {@Autowiredprivate Properties props; //全局配置参数/*** 注册数据源* @return*/@Beanpublic DataSource dataSource(){DriverManagerDataSource ds = new DriverManagerDataSource();ds.setDriverClassName(props.getDbDrivce());ds.setUrl(props.getDbUrl());ds.setUsername(props.getDbUsername());ds.setPassword(props.getDbPasswrod());return ds;}/*** 注册mybatis会话工厂* @return* @throws IOException*/@Beanpublic SqlSessionFactoryBean sessionFactory() throws IOException {SqlSessionFactoryBean sessionBean = new SqlSessionFactoryBean();sessionBean.setDataSource(dataSource());  //数据源sessionBean.setTypeAliasesPackage("com.hniu.myphone.mapper"); //实体别名PathMatchingResourcePatternResolver sourceResolver = new PathMatchingResourcePatternResolver();//Mapper.xmlResource[] rs = sourceResolver.getResources("classpath:mapper/*Mapper.xml");sessionBean.setMapperLocations(rs);PageInterceptor interceptor =new PageInterceptor();sessionBean.setPlugins(interceptor);return sessionBean;}/*** 注册mybatis操作模板* @return* @throws Exception*/@Beanpublic SqlSessionTemplate sessionTemplate() throws Exception {SqlSessionTemplate template = new SqlSessionTemplate(Objects.requireNonNull(sessionFactory().getObject()));return template;}/*** 注册消息转换器，把返回的对象转换成JSON* @param converters*/protected void configureMessageConverters(List<HttpMessageConverter<?>> converters) {// put the jackson converter to the front of the list so that application/json content-type strings will be treated as JSONconverters.add(new MappingJackson2HttpMessageConverter());// and probably needs a string converter too for text/plain content-type strings to be properly handledconverters.add(new StringHttpMessageConverter());}@Overrideprotected  void addResourceHandlers(ResourceHandlerRegistry registry){registry.addResourceHandler(props.getAccessUrl()+"**").addResourceLocations("file:"+props.getSavePath());}@Beanpublic CommonsMultipartResolver multipartResolver(){CommonsMultipartResolver resolver=new CommonsMultipartResolver();return resolver;}
}

package com.hniu.myphone.comm.config;import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.PropertySource;
import org.springframework.stereotype.Component;@Component
@PropertySource("classpath:application.properties")
public class Properties {@Value("${db.driver}")private String dbDrivce;@Value("${db.url}")private String dbUrl;@Value("${db.username}")private String dbUsername;@Value("${db.password}")private String dbPasswrod;@Value("${wx.appid}")private String appid;@Value("${wx.secret}")private String secret;@Value("${file.savePath}")private String savePath;@Value("${file.accessUrl}")private String accessUrl;//	此处忽略了getter和setter}

2. 在package com.hniu.myphone下创建mapper包，mapper包下创建实体类：Account、Cover、Photo

package com.hniu.myphone.mapper;public class Account {private String accId;private String openid;private String nickName;private String avatarUrl;//	此处忽略了getter和setter
}

package com.hniu.myphone.mapper;public class Cover {private String coverId;private String accId;private String accessUrl;private String photoId;//	此处忽略了getter和setter
}

package com.hniu.myphone.mapper;import java.util.Date;public class Photo {private String photoId;private Long photoSize;private Date uploadTimestamp;private String photoSavePath;private String photoAccessUrl;private Account account;//	此处忽略了getter和setter
}

3. 在package com.hniu.myphone.comm下创建WXUtils，WXUtils包下创建以下微信工具类：

package com.hniu.myphone.comm.WXUtils;import com.fasterxml.jackson.databind.ObjectMapper;
import com.hniu.myphone.comm.config.Properties;
import org.apache.http.HttpResponse;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.HttpClientBuilder;
import org.apache.http.util.EntityUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;import java.io.IOException;
import java.util.Map;
@Component
public class WXUtils {private static final String WX_LOGIN_SERVICE = "https://api.weixin.qq.com/sns/jscode2session";@Autowiredprivate Properties props;public String getOpenId(String code) throws IOException {String url = String.format(WX_LOGIN_SERVICE + "?appid=%s&secret=%s&js_code=%s&grant_type=authorization_code", props.getAppid(), props.getSecret(), code);HttpClient client = HttpClientBuilder.create().build();HttpGet get=new HttpGet(url);HttpResponse res=client.execute(get);String result= EntityUtils.toString(res.getEntity());ObjectMapper om=new ObjectMapper();Map<String,Object> map=om.readValue(result,Map.class);String openId= (String)map.get("openid");return openId;}
}

4. 在package com.hniu.myphone下创建controller包，controller包下创建控制器类：AccountController、CoverController、PhotoController

package com.hniu.myphone.controller;import com.hniu.myphone.comm.WXUtils.WXUtils;
import com.hniu.myphone.comm.config.Properties;
import com.hniu.myphone.mapper.Account;
import com.hniu.myphone.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;import java.io.File;
import java.io.IOException;
import java.util.UUID;@RestController
@RequestMapping("/account")
public class AccountController {@Autowiredprivate AccountService accountService;@Autowiredprivate WXUtils wxUtils;@Autowiredprivate Properties pros;@GetMapping("/getUserInfo")public Account getUserInfo(String code){try{String openId=wxUtils.getOpenId(code);Account account=accountService.selectByOpenId(openId);return account;} catch (IOException e) {throw new RuntimeException(e);}
//        return null;}@PostMapping("/save")public String save(Account account, String code){try{String openId=wxUtils.getOpenId(code);account.setOpenid(openId);accountService.saveAccount(account);} catch (IOException e) {throw new RuntimeException(e);}return account.getAccId();}@PostMapping("/modifyNickName")public String modifyNickName(Account account){accountService.uploadAccount(account);return "1";}@PostMapping("/uploadAvatar")public String uploadAvatar(@RequestPart MultipartFile avatar,Account account){String uploadRoot=pros.getSavePath()+account.getAccId()+ File.separator;File root=new File(uploadRoot);if (!root.exists()){root.mkdirs();}String oldFileName=avatar.getOriginalFilename();String suffx=oldFileName.substring(oldFileName.lastIndexOf("."));String newFileName= UUID.randomUUID().toString()+suffx;try{avatar.transferTo(new File(uploadRoot+newFileName));String accessUrl=pros.getAccessUrl()+account.getAccId()+"/"+newFileName;account.setAvatarUrl(accessUrl);accountService.uploadAccount(account);return accessUrl;} catch (IOException e) {throw new RuntimeException(e);}}
}

package com.hniu.myphone.controller;import com.hniu.myphone.mapper.Cover;
import com.hniu.myphone.service.CoverService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;
import java.util.UUID;@RestController
@RequestMapping("/cover")
public class CoverController {@Autowiredprivate CoverService coverService;@GetMapping("/list")public List<Cover> list(String accId){return coverService.list(accId);}@GetMapping("/getOne")public Cover selectOne(String accId,String photoId){return coverService.selectOne(accId, photoId);}@GetMapping("/delete")public void delete(String coverId){coverService.delete(coverId);}@PostMapping("/save")public String save(Cover cover){String coverId = UUID.randomUUID().toString().replaceAll("-","");cover.setCoverId(coverId);return coverService.save(cover);}}

import com.hniu.myphone.comm.config.Properties;
import com.hniu.myphone.mapper.Account;
import com.hniu.myphone.mapper.Photo;
import com.hniu.myphone.service.PhotoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.IOException;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import java.util.UUID;@RestController
@RequestMapping("/photo")
public class PhotoController {@Autowiredprivate final PhotoService photoService;@Autowiredprivate Properties pros;public PhotoController(PhotoService photoService) {this.photoService = photoService;}@PostMapping("/upload")public String uploadPhoto(@RequestPart MultipartFile file,String accId) {Photo photo = new Photo();Account account = new Account();account.setAccId(accId);photo.setAccount(account);long size = file.getSize();String oldFileName = file.getOriginalFilename();String suffx = oldFileName.substring(oldFileName.lastIndexOf("."));String newFileName = UUID.randomUUID().toString()+suffx;photo.setPhotoSize(size);try {String uploadRoot = pros.getSavePath()+"\\"+accId+ File.separator;File root = new File(uploadRoot);if(!root.exists()){root.mkdirs();}photo.setPhotoSavePath(uploadRoot);file.transferTo(new File(uploadRoot+newFileName));String accessUrl = pros.getAccessUrl()+accId+"/"+newFileName;photo.setPhotoAccessUrl(accessUrl);photoService.savePhoto(photo);} catch (IOException e) {e.printStackTrace();return "";}return "1";}@GetMapping("/list")public List<Photo> list(String accId,Integer pageNum){if (pageNum==null){pageNum=1;}return photoService.selectList(accId,pageNum,5);}@GetMapping("/delete")public void deletePhoto(String[] photoIds){System.out.println(Arrays.toString(photoIds));photoService.deletePhoto(photoIds);}
}

5. 在package com.hniu.myphone下创建dao包，dao包下创建接口：AccountMapper、CoverMapper、PhotoMapper

package com.hniu.myphone.dao;import com.hniu.myphone.mapper.Account;import java.util.List;
import java.util.Map;/****/
public interface AccountMapper {public List<Map<String,Object>> selectAll();//    public Map<String,Object>  selectByOpenId(String openId);public Account selectByOpenId(String openId);void saveAccount(Account account);void uploadAccount(Account account);
}

package com.hniu.myphone.dao;import com.hniu.myphone.mapper.Cover;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;import java.util.List;@Repository
public interface CoverMapper {public List<Cover> selectCover(String accId);public void deleteByCoverId(String coverId);public Cover selectAccIdAndPhotoId(@Param("accId") String accId, @Param("photoId") String photoId);public int insertCover(Cover cover);}

package com.hniu.myphone.dao;import com.hniu.myphone.mapper.Account;
import com.hniu.myphone.mapper.Photo;import java.util.List;public interface PhotoMapper {public void savePhoto(Photo photo);public void deleteByPhotoIds(String[] photoIds);List<Photo> selectList(String accId,int startNum,int endNum);
}

6. 在package com.hniu.myphone下创建service包，service包下创建服务类： AccountService、CoverService、PhotoService

package com.hniu.myphone.service;import com.hniu.myphone.dao.AccountMapper;
import com.hniu.myphone.mapper.Account;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.stereotype.Service;import java.util.UUID;
@Controller
@Service
public class AccountService {@Autowiredprivate AccountMapper accountMapper;//    public List<Map<String,Object>> selectAll(){
//        return accountMapper.selectAll();
//    }//    public Map<String,Object>  selectByOpenId(String openId){
//        return accountMapper.selectByOpenId(openId);
//    }public Account selectByOpenId(String openId){return accountMapper.selectByOpenId(openId);}public void saveAccount(Account account){String accId= UUID.randomUUID().toString().replaceAll("-","");account.setAccId(accId);accountMapper.saveAccount(account);}public void uploadAccount(Account account){accountMapper.uploadAccount(account);}
}

package com.hniu.myphone.service;import com.hniu.myphone.dao.CoverMapper;
import com.hniu.myphone.mapper.Cover;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class CoverService {@Autowiredprivate CoverMapper coverMapper;public List<Cover> list(String accId){return coverMapper.selectCover(accId);}public Cover selectOne(String accId,String photoId){Cover cover = coverMapper.selectAccIdAndPhotoId(accId, photoId);if (cover == null){return null;}else {return cover;}}public void delete(String coverId){coverMapper.deleteByCoverId(coverId);}public String save(Cover cover){int i = coverMapper.insertCover(cover);if (i>0){return "1";}else {return null;}}}

package com.hniu.myphone.service;import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.hniu.myphone.dao.PhotoMapper;
import com.hniu.myphone.mapper.Photo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.sql.Timestamp;
import java.util.Date;
import java.util.List;
import java.util.UUID;@Service
public class PhotoService {@Autowiredprivate PhotoMapper photoMapper;public void savePhoto(Photo photo){
//        //使用UUID生成主键，并赋值给photoID
//        String photoID= UUID.randomUUID().toString();
//        photo.setPhotoId(photoID);
//        //获取当前时间，赋值给uploadTimestamp
//        Timestamp uploadTimestamp=new Timestamp(System.currentTimeMillis());
//        photo.setUploadTimestamp(uploadTimestamp);
//        //调用PhotoMapper接口中的方法实现照片信息的保存
//        photoMapper.savePhoto(photo);String uuid = UUID.randomUUID().toString().replaceAll("-","");Date date = new Date();photo.setPhotoId(uuid);photo.setUploadTimestamp(date);photoMapper.savePhoto(photo);}public List<Photo> selectList(String accId,int pageNum,int pageSize){return photoMapper.selectList(accId,(pageNum-1)*pageSize,pageNum*pageSize);}public void deletePhoto(String[] photoIds){photoMapper.deleteByPhotoIds(photoIds);}
}

7. 在package com.hniu.myphone下创建Application类

package com.hniu.myphone;
import org.mybatis.spring.annotation.MapperScan;
import org.mybatis.spring.annotation.MapperScans;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.web.WebApplicationInitializer;
import org.springframework.web.context.support.AnnotationConfigWebApplicationContext;
import org.springframework.web.filter.CharacterEncodingFilter;
import org.springframework.web.servlet.DispatcherServlet;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import javax.servlet.DispatcherType;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import java.util.EnumSet;
@EnableWebMvc
@ComponentScan
@MapperScans(@MapperScan("com.hniu.myphone.dao"))
public class Application implements WebApplicationInitializer {//    filter.setEncoding("utf-8");public void onStartup(ServletContext servletContext) throws ServletException {AnnotationConfigWebApplicationContext context = new AnnotationConfigWebApplicationContext();DispatcherServlet servlet = new DispatcherServlet();servlet.setApplicationContext(context);servletContext.addServlet("ds",servlet).addMapping("/");context.setServletContext(servletContext);context.register(Application.class);context.refresh();context.start();CharacterEncodingFilter filter=new CharacterEncodingFilter();filter.setEncoding("UTF-8");servletContext.addFilter("cef",filter).addMappingForUrlPatterns(EnumSet.of(DispatcherType.REQUEST),true,"/*");}}

8. 在resources下创建mapper目录，在mapper目录下新建以下xml文件：AccountMapper.xml、CoverMapper.xml、PhotoMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.6//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hniu.myphone.dao.AccountMapper"><resultMap id="accountMap" type="Account"><id column="acc_id" property="accId"></id><result column="openid" property="openid"></result><result column="nickName" property="nickName"></result><result column="avatarUrl" property="avatarUrl"></result></resultMap><select id="selectByOpenId" parameterType="string" resultMap="accountMap">SELECT * FROM t_account WHERE openid = #{openid};</select><insert id="saveAccount" parameterType="Account">INSERT INTO t_account (acc_id, openid, nickName, avatarUrl) VALUES (#{accId},#{openid}, #{nickName}, #{avatarUrl})</insert><update id="uploadAccount" parameterType="Account">update t_account<set><if test="nickName != null and nickName.trim() != ''">nickname=#{nickName}</if><if test="avatarUrl != null and avatarUrl.trim() != ''">avatarUrl = #{avatarUrl}</if></set>where acc_id=#{accId};</update>
</mapper>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hniu.myphone.dao.CoverMapper"><resultMap id="result" type="com.hniu.myphone.mapper.Cover"><id column="cover_id" property="coverId"/><result column="acc_id" property="accId"/><result column="photo_accessUrl" property="accessUrl"/><result column="photo_id" property="photoId"/></resultMap><insert id="insertCover">insert into t_cover(cover_id, acc_id, photo_accessUrl, photo_id) values (#{coverId},#{accId},#{accessUrl},#{photoId})</insert><delete id="deleteByCoverId">delete from t_cover where cover_id = #{coverId}</delete><select id="selectCover" resultMap="result">select * from t_cover where acc_id = #{accId}</select><select id="selectAccIdAndPhotoId" resultMap="result">select * from t_cover where acc_id = #{accId} and photo_id = #{photoId}</select>
</mapper>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.6//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hniu.myphone.dao.PhotoMapper"><resultMap id="result" type="com.hniu.myphone.mapper.Photo"><id property="photoId" column="photo_id"/><result property="photoSize" column="photo_size"/><result property="uploadTimestamp" column="upload_timestamp"/><result property="photoSavePath" column="photo_savePath"/><result property="photoAccessUrl" column="photo_accesUrl"/><association property="account"><id property="accId" column="acc_id"/><!-- Add other account properties here --></association></resultMap><insert id="savePhoto" parameterType="com.hniu.myphone.mapper.Photo">INSERT INTO t_photo(photo_id, photo_size, upload_timestamp, photo_savePath, photo_accesUrl, acc_id)VALUES(#{photoId}, #{photoSize}, #{uploadTimestamp}, #{photoSavePath}, #{photoAccessUrl}, #{account.accId});</insert><delete id="deleteByPhotoIds">delete from t_photo where photo_id in<foreach collection="array" index="index" open="(" close=")" item="item" separator=",">#{item}</foreach></delete><!--    <select id="selectList" resultMap="result" parameterType="string">-->
<!--        SELECT * FROM t_photo WHERE acc_id = #{account.accId} ORDER BY upload_timestamp DESC;-->
<!--    </select>--><select id="selectList" resultMap="result">select * from t_photo where acc_id = #{arg0} order by upload_timestamp desc limit #{arg1},#{arg2}</select>
</mapper>

源码：个人相册后端