sqlSessionFactory.openSession(); // 查询单个记录，根据用户id查询用户信息 List list = sqlSession.selectList("test.findUserByUsername", "张"); System.out.println(list.size()); } catch (Exception e) { e.printStackTrace(); interface UserMapper { //根据用户id查询用户信息 public User findUserById(int id) throws Exception; //查询用户列表 public List findUserByUsername(String username) throws Exception; //添加用户信息 public void insertUser(User UserMapper userMapper = sqlSession.getMapper(UserMapper.class); List list = userMapper.findUserByUsername("张"); System.out.println(list.size()); } Public void testInsertUser() throws Exception {

. . . . . . . . . . . . . . . . . . . . . . . . 65 Column shadow algorithm DML statement support list . . . . . . . . . . . . . . 65 5 User Manual 67 5.1 ShardingSphere‐JDBC . . . . . . . . . . . . Apache Top‐Level Project on April 16, 2020. Welcome to interact with community via the official mail list and the ShardingSphere Slack. 1.1 Introduction Apache ShardingSphere including 3 independent products: We will try best to support the unavailable SQLs in future versions. MySQL The unsupported SQL list for MySQL are as follows: SQL FLUSH PRIVILEGES CLONE LOCAL DATA DIRECTORY = ‘clone_dir’ INSTALL

Apache Top‐Level Project on April 16, 2020. Welcome to interact with community via the official mail list and the ShardingSphere Slack. 1.1 Introduction Apache ShardingSphere including 3 independent products: We will try best to support the unavailable SQLs in future versions. MySQL The unsupported SQL list for MySQL are as follows: SQL CLONE LOCAL DATA DIRECTORY = ‘clone_dir’ INSTALL COMPONENT ‘file://component1’ GROUP group_name TYPE = SYSTEM ALTER RESOURCE GROUP rg1 VCPU = 0‐63 openGauss The unsupported SQL list for openGauss are as follows: 4.1. DB Compatibility 19 Apache ShardingSphere document, v5.1.1 SQL

Apache Top‐Level Project on April 16, 2020. Welcome to interact with community via the official mail list and the ShardingSphere Slack. 1.1 Introduction Apache ShardingSphere including 3 independent products: https://github.com/apache/shardingsphere/tree/master/shardingsphere‐sql‐parser MySQL The unsupported SQL list for MySQL are as follows: SQL CLONE LOCAL DATA DIRECTORY = ‘clone_dir’ INSTALL COMPONENT ‘file://component1’ 4.1. DB Compatibility 19 Apache ShardingSphere document, v5.1.2 openGauss The unsupported SQL list for openGauss are as follows: SQL CREATE type avg_state AS (total bigint, count bigint); CREATE

. . . . . . . . . . . . . . . . . . . . . . . . . . . 474 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 477 11.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides users with a simplest table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] Sub-query Stable support is provided

. . . . . . . . . . . . . . . . . . . . . . . . . 503 ix BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 506 11.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides users with a simplest table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] Sub-query Stable support is provided

became an Apache Top Level Project on April 16, 2020. Welcome communicate with community via mail list. 1.1 Introduction 1.1.1 ShardingSphere-JDBC ShardingSphere‐JDBC defines itself as a lightweight Sharding 14 Apache ShardingSphere document, v5.0.0-beta Data Sources Configuration Real data sources list. Tables Configuration Configurations of logic table names, data node and table sharding rules. auto‐increment key derives column, if the user writes SQL with placeholder, he only needs to rewrite parameter list but not SQL itself. 3.1. Sharding 36 Apache ShardingSphere document, v5.0.0-beta Pagination Revision

. . . . . . . . . . . . . . . . . . . . . . . . . . . 337 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 340 6.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.2 Design Philosophy ShardingSphere adopts the database plus design philosophy table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] 3.1. Sharding 25 Apache ShardingSphere

. . . . . . . . . . . . . . . . . . . . . . . . . . . 364 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 367 6.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.5. Roadmap 9 2 Quick Start In shortest time, this chapter provides users table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] 3.1. Sharding 24 Apache ShardingSphere

2.5 用户模糊查询 2.5.1 在持久层接口中添加模糊查询方法 /** * 根据名称模糊查询 * @param username * @return */ List findByName(String username); 2.5.2 在用户的映射配置文件中配置 List users = userDao.findByName("%王%"); for(User user : users){ System.out 第二步：测试，如下： /** * 测试模糊查询操作 */ @Test public void testFindByName(){ //5.执行查询一个方法 List users = userDao.findByName("王"); for(User user : users){ System.out.println(user);

0 码力 | 27 页 | 1.21 MB | 1 年前

3

共 26 条

• 1
• 2
• 3

前往