Home Java javaTutorial How to query the database in java

How to query the database in java

Aug 17, 2020 pm 01:38 PM
java Query database

How to query the database in java: first create the user and teacher databases; then establish a one-to-many connection between the [user_id] column of the teacher table and the id column of the user table; then add data to the user data table, and Query the user database data according to the conditions; finally query the slave table data according to the main table.

How to query the database in java

[Related learning recommendations: java basic tutorial]

How to query the database in java:

1. Create database

Create user database

How to query the database in java

Create teacher database

How to query the database in java

The user_id column of the teacher table establishes a one-to-many connection with the id column of the user table, using user_id as a foreign key.

How to query the database in java

2. Java programming to query the database

Add data to the user data table

    /**
     * 添加数据
     */
    @Test
    public void addData() {
        Connection connection = null;
        PreparedStatement pstmt =null;
        try {
            connection = JDBCUtils_V3.getConnection();
            String sql = "insert into user values(null,?,?)";
            pstmt = connection.prepareStatement(sql);
            pstmt.setString(1, "wangxuan");
            pstmt.setString(2, "741852");
            int row = pstmt.executeUpdate();
            if (row>0) {
                System.out.println("数据添加成功!");
            }else {
                System.out.println("数据添加失败!");
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            JDBCUtils_V3.release(connection, pstmt, null);
        }
    }
Copy after login

Query according to conditions user database data

    /**
     * 按照条件查询数据
     */
    @Test
    public void selectTest() {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs =null;
        try {
            conn = JDBCUtils_V3.getConnection();
            String sql = "select * from user where password = ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "123456");
            rs = pstmt.executeQuery();
            while (rs.next()) {
                System.out.println(rs.getString(1)+"----"+rs.getString(2)+"---"+rs.getString(3));
            }
//            System.out.println(rs);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            JDBCUtils_V3.release(conn, pstmt, rs);
        }
    }
Copy after login

One-to-many query/Query the slave table teacher data based on the main table user

    /**
     * 一对多查询
     * 根据主表查询从表
     */
    @Test
    public void selectOnetoMore() {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            conn = JDBCUtils_V3.getConnection();
//            String sql = "select * from teacher where user_id = (select id from user where username =?) ";
            String sql = "select * from user,teacher where user.id = teacher.user_id ";
            pstmt = conn.prepareStatement(sql);
//            pstmt.setString(1, "wangxuan");
            rs = pstmt.executeQuery();
            while (rs.next()) {
//                System.out.println(rs.getString(1)+"----"+rs.getString(2)+"---"+rs.getString(3)+"---"+rs.getString(4));
                System.out.println(rs.getString(1)+"----"+rs.getString(2)+"---"+rs.getString(3)+"---"+rs.getString(4)+"----"+rs.getString(5)+"----"+rs.getString(6)+"----"+rs.getString(7));
            }
            System.out.println("查询完成");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            JDBCUtils_V3.release(conn, pstmt, rs);
        }
    }
Copy after login

One-to-many query/Query the main table based on the slave table

    /**
     * 一对多查询
     * 根据从表查询主表数据
     */
    @Test
    public void selectMoretoOne() {
        Connection connection = null;
        PreparedStatement pstmtPreparedStatement = null;
        ResultSet rSet =null;
        try {
            connection = JDBCUtils_V3.getConnection();
            String sql = "select * from user where id = (select user_id from teacher where teacher=?)";
            pstmtPreparedStatement = connection.prepareStatement(sql);
            pstmtPreparedStatement.setString(1, "钱田");
            rSet = pstmtPreparedStatement.executeQuery();
            while (rSet.next()) {
                System.out.println(rSet.getString(1)+"----"+rSet.getString(2)+"---"+rSet.getString(3));
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            JDBCUtils_V3.release(connection, pstmtPreparedStatement, rSet);
        }
    }
}
Copy after login

Related recommendations: Programming video course

The above is the detailed content of How to query the database in java. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Java Spring Interview Questions Java Spring Interview Questions Aug 30, 2024 pm 04:29 PM

In this article, we have kept the most asked Java Spring Interview Questions with their detailed answers. So that you can crack the interview.

Break or return from Java 8 stream forEach? Break or return from Java 8 stream forEach? Feb 07, 2025 pm 12:09 PM

Java 8 introduces the Stream API, providing a powerful and expressive way to process data collections. However, a common question when using Stream is: How to break or return from a forEach operation? Traditional loops allow for early interruption or return, but Stream's forEach method does not directly support this method. This article will explain the reasons and explore alternative methods for implementing premature termination in Stream processing systems. Further reading: Java Stream API improvements Understand Stream forEach The forEach method is a terminal operation that performs one operation on each element in the Stream. Its design intention is

TimeStamp to Date in Java TimeStamp to Date in Java Aug 30, 2024 pm 04:28 PM

Guide to TimeStamp to Date in Java. Here we also discuss the introduction and how to convert timestamp to date in java along with examples.

PHP: A Key Language for Web Development PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

Java Program to Find the Volume of Capsule Java Program to Find the Volume of Capsule Feb 07, 2025 am 11:37 AM

Capsules are three-dimensional geometric figures, composed of a cylinder and a hemisphere at both ends. The volume of the capsule can be calculated by adding the volume of the cylinder and the volume of the hemisphere at both ends. This tutorial will discuss how to calculate the volume of a given capsule in Java using different methods. Capsule volume formula The formula for capsule volume is as follows: Capsule volume = Cylindrical volume Volume Two hemisphere volume in, r: The radius of the hemisphere. h: The height of the cylinder (excluding the hemisphere). Example 1 enter Radius = 5 units Height = 10 units Output Volume = 1570.8 cubic units explain Calculate volume using formula: Volume = π × r2 × h (4

PHP vs. Python: Understanding the Differences PHP vs. Python: Understanding the Differences Apr 11, 2025 am 12:15 AM

PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.

Create the Future: Java Programming for Absolute Beginners Create the Future: Java Programming for Absolute Beginners Oct 13, 2024 pm 01:32 PM

Java is a popular programming language that can be learned by both beginners and experienced developers. This tutorial starts with basic concepts and progresses through advanced topics. After installing the Java Development Kit, you can practice programming by creating a simple "Hello, World!" program. After you understand the code, use the command prompt to compile and run the program, and "Hello, World!" will be output on the console. Learning Java starts your programming journey, and as your mastery deepens, you can create more complex applications.

How to Run Your First Spring Boot Application in Spring Tool Suite? How to Run Your First Spring Boot Application in Spring Tool Suite? Feb 07, 2025 pm 12:11 PM

Spring Boot simplifies the creation of robust, scalable, and production-ready Java applications, revolutionizing Java development. Its "convention over configuration" approach, inherent to the Spring ecosystem, minimizes manual setup, allo

See all articles