Skip to content
No description or website provided.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
README.md
pom.xml

README.md

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=HashSet List=ArrayList Map=LinkedHashMap

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

You can’t perform that action at this time.