# [JavaSE实验] JDBC and MySQL ## 1 JDBC JDBC is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database database. JDBC is oriented towards relational databases. From a technical point of view, the API is as a set of classes in the java.sql package. To use JDBC with a particular database, we need a JDBC driver Libraries node and select Add Library option. From the list of options, select MySQL JDBC Driver. ## 4 Installation and Testing If you don't already have MySQL installed, we must install it. $sudo apt-get

## 1 Sharding-JDBC 概览 ### 1.1 认识ShardingSphere ## ShardingSphere ShardingSphere是一套开源的分布式数据库中间件解决方案组成的生态圈，它由Sharding-JDBC、Sharding-Proxy和Sharding-Sidecar（计划中）这3款相互独立的产品组成。他们均提供标准化的数据分片、分布式事务和数据库治理功能 认识Sharding-JDBC 定位为轻量级Java框架，在Java的JDBC层提供的额外服务。它使用客户端直连数据库，以jar包形式提供服务，无需额外部署和依赖，可理解为增强版的JDBC驱动，完全兼容DBC和各种ORM框架。 - 适用于任何基于Java的ORM框架，如：JPA, Hibernate, Mybatis, Spring JDBC Template或直接使用JDBC。 - 基于任何第三方的数据库连接池，如：DBCP 基于任何第三方的数据库连接池，如：DBCP, C3P0, BoneCP, Druid, HikariCP等。 - 支持任意实现JDBC规范的数据库。目前支持MySQL，Oracle，SQLServer和PostgreSQL。  ### 1.3 认识Sharding-Proxy

## +23 ## Back To Basics Testing ## PHIL NASH ## 20 23 October 01 - 06 ## What is a test? ## What is a test? ## operation ## What is a test? ## operation input values ## What is a test? ## operation colspan="2">Code-drivenDecision CoverageOrthogonal arrayPathManual-SupportUser AcceptanceUser Acceptancetesting pyramid System Tests Integration Tests Unit Tests ## What is a Unit Test? ## What is a Unit Test

## Scientific Unit Testing Dave Steffen, Ph.D. Software Lead dsteffen@scitec.com — in Physics which is relevant SCiTEC Science & Technology Innovation www.scitec.com If I have seen further bad tests are almost always better than no tests! ## Unit Testing OO Code ## Test using only the public interface ("Black Box" testing) • Forces better design ("design for testability") coupling to implementation • Unit tests are also examples and documentation ## Object Oriented testing ## Let's unit test this class 1 // Cup.h // creates an empty cup bool IsEmpty(); bool Fill();

## +21 ## Testing Compile-time Constructs Within a Runtime Unit Testing Framework ## I GOR BOGOSLAVSKYI 20 21 October 24-29 ## We use C++ (14) for safety-critical applications that we deliver to our ments/4/8/e/9/48e97f15addfced313a9cb60758e45d2/p2_1.jpg) Errors have a high cost, so rigorous testing is a must We use increasingly more compile-time polymorphism and checks Question: how to test if get_half_of(T smth) { return smth / T{2}; } ## Write a rigorous testing suite #include TEST(TestMyApi, Halving) { EXPECT_FLOAT_EQ(21.0F, get_half_of(42

Testing Version 5.3.36-SNAPSHOT ## Table of Contents 1. Introduction to Spring Testing 2 2. Unit Testing 3 2.1. Mock Objects 3 2.1.1. Environment 3 2.1.2. JNDI 3 2.1.3. Servlet API 4 2.1 2. Unit Testing Support Classes 4 2.2.1. General Testing Utilities 4 2.2.2. Spring MVC Testing Utilities 5 3. Integration Testing 6 3.1. Overview 6 3.2. Goals of Integration Testing 6 3.2.1 3.2.3. Transaction Management 8 3.2.4. Support Classes for Integration Testing 8 3.3. JDBC Testing Support 8 3.4. Annotations 9 3.4.1. Spring Testing Annotations 9 @BootstrapWith 10 @ContextConfiguration

## +24 ## Back To Basics Debugging and Testing ## GREG LAW & MIKE SHAH ### Writing software is really hard. If it’s not tested, it doesn’t work Or at least it will soon stop working. ## WHAT'S 4/p5_1.jpg) BUT WHEN I DO, DO IT IN PRODUCTION Software development done right is basically testing and debugging. ## GOOD TESTS ARE • Independent • Repeatable Fast ## DIFFERENT TESTS — ALL ARE generally shallow / easy-to-fix. Tests run fast – tight feedback loop. But... Assumptions! ## UNIT TESTING FRAMEWORKS Google Gest Catch2 Boost.Test • CppUTest • doctest ![Image](/uploads/documents/

## +24 ## Back To Basics Unit Testing ## DAVE STEFFEN ## 20 24 September 15 - 20 ## Unit Testing is a Big Topic How many youtube videos about C++ unit testing ## ✗ 🔍 🔍 ✗  Testing Compile-time Constructs in a Runtime Unit Testing ... YouTube · CppCon Feb 15, 2022 It's A Bug Hu Armor Plate You 2023 ## Unit Testing is a Big Topic • Jody Hagins (today): The Most Important Design Guideline is Testability • Greg Law and Mike Shah (tomorrow): Back To Basics, Debugging and Testing • Chip Hogg (Wednesday)

## DBeaver CLICKHOUSE И ДВЕАVER, ИЛИ КОМУ НУЖЕН JDBC? dbeaver.com ## 1  ## DBeaver Универсальный интерфейс для работы ЮДС-ДРАЙВЕРЕ В ДВУХ СЛОВАХ √ JDBC-драйвер для Clickhouse есть и даже не один Х Никто не идеален, и JDBC-драйвер тоже ## СЛОЖНОСТИ ## ! 1. Соответствие спецификации JDBC 2. Новая версия драйвера не не всегда работает 3. Существование разных JDBC-драйверов 4. Нехватка аналитических функций ## COOTBETCTBIE JDBC API ## ВОПРОСЫ • Нестандартно возвращаются значения массивов • Метаданные о числовых

## 2 Sharding-JDBC入门使用 ### 2.1 不使用 Spring ## 引入Maven依赖 org.apache.shardingsphere sharding-jdbc-core ${sharding-sphere.version} version} ## 基于Java编码的规则配置 Sharding-JDBC的分库分表通过规则配置描述，以下例子是根据user_id取模分库，且根据order_id取模分表的两库两表的配置。 // 配置真实数据源 Map dataSourceMap = new HashMap<>(); // dataSource1 = new BasicDataSource(); dataSource1.setDriverClassName("com.mysql.jdbc.Driver"); dataSource1.setUrl("jdbc:mysql://localhost:3306/ds0"); dataSource1.setUsername("root"); dataSource1