<dependency>
<groupId>org.fastsql</groupId>
<artifactId>fastsql</artifactId>
<version>1.0</version>
</dependency>
***范例***
public interface UserDao {
@Select("select *,age as 123age from user where auto_id=#{userId} and local=#{local}")
public User findOne(@Param("userId") Long userId, @Param("remark") String remark, @Param("local") int local);
@Select("select * from user")
public ArrayList selectAll();
}
使用UserDao进行查询
public class QueryTest {
public static void main(String[] args) throws NoSuchMethodException, SQLException {
//定义工厂
DefaultObjectFactory factory = new DefaultObjectFactory();
//设置数据源
factory.setDataSource(getDataSource());
//从工厂获取dao实例
UserDao userDao= factory.getBean(UserDao.class);
//执行查询，返回单个对象
User user= userDao.findOne( 1l, "222",1);
System.out.println(user);
//返回集合
List userList = userDao.selectAll();
System.out.println(userList);
}
public static DataSource getDataSource() throws SQLException {
//测试使用alibaba druid数据源
DruidDataSource dataSource = new DruidDataSource();
dataSource.setUrl("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC");
dataSource.setUsername("root");
dataSource.setPassword("123456");
dataSource.setInitialSize(10);
dataSource.setMaxActive(20);
dataSource.init();
return dataSource;
}
}
**返回类型支持**
8个基础、String、Set、List、Map
默认：
Set=HashSet
List=ArrayList
Map=LinkedHashMap
Set和List 不指定泛型，默认为Set