开源软件名称：

开源软件地址：

开源软件介绍：

fastsql

fastsql 是一个数据库访问框架

Maven依赖

        <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=HashSetList=ArrayListMap=LinkedHashMap

Set和List 不指定泛型，默认为Set<Map<String,Object>>和List<Map<String,Object>>