国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home Database Mysql Tutorial MySQL learning Java graphic code example to connect to MySQL database

MySQL learning Java graphic code example to connect to MySQL database

Sep 08, 2017 pm 02:24 PM
java mysql connect

1. What is JDBC?

JDBC (Java DataBase Connectivity) is Java database connection. To put it bluntly, it uses Java language to operate the database. It turns out that when we operate the database, we use SQL statements on the console to operate the database. JDBC uses Java language to send SQL statements to the database.

2. JDBC principle

SUN provides access to the database specification called JDBC, and the implementation class provided by the manufacturer is called a driver.

JDBC is the interface, and the JDBC driver is the implementation of the interface. The database connection cannot be completed without the driver!

Each database manufacturer has its own driver for connecting to its own company's database.

3. JDBC development steps

1) Register driver

2) Obtain connection

3) Obtain statement executor

4 ) Execute sql statement

5) Process the result

6) Release resources

3. Import the driver jar package

1) Create a new project and name it WEB08_JDBC ,

2) Create the lib directory, right-click New->Folder, name it lib, which is used to store all jar packages required by the current project,

Copy the jar package to Under the lib folder of the current project,

3) Select the jar package, right-click and execute Build Path until a small milk bottle logo appears in the current directory

4 , Test the sql injection problem (apply to the content of JUnit unit test)

There are two pieces of data in the tbl_user table in the web08 database under mysql, and log in according to the user information.

The specific code implementation is as follows:

package cn.itheima.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;

public class TestLogin {
        @Test
        public void testLogin(){
            try {
                login1("zhangsan","999");
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        public void login1(String username,String password) throws ClassNotFoundException, SQLException{
            /*
             * 用戶登錄方法
             */
            //1.注冊驅(qū)動
            Class.forName("com.mysql.jdbc.Driver");
            //2.獲取連接
            Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/web08","root","12345");
            //3.編寫sql語句
            String sql="select * from tbl_user where uname=? and upassword=?";
            //4.創(chuàng)建預(yù)處理對象
            PreparedStatement pstmt=conn.prepareStatement(sql);
            //5.設(shè)置參數(shù)(給占位符)
            pstmt.setString(1, username);
            pstmt.setString(2, password);
            //6.執(zhí)行查詢操作
            ResultSet rs=pstmt.executeQuery();
            //7.對結(jié)果集進行處理
            if(rs.next()){
                System.out.println("恭喜您,"+username+"登錄成功!");
            }else{
                System.out.println("賬號或密碼錯誤!");
            }
            if(rs!=null) rs.close();
            if(pstmt!=null) pstmt.close();
            if(conn!=null) conn.close();            
        }
    }

Right-click Run As->JUnit Test, the execution result is: Congratulations, zhangsan logged in successfully!

The above is the detailed content of MySQL learning Java graphic code example to connect to MySQL database. 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

Undress AI Tool

Undress AI Tool

Undress images for free

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.

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)

Hot Topics

PHP Tutorial
1502
276
How to handle transactions in Java with JDBC? How to handle transactions in Java with JDBC? Aug 02, 2025 pm 12:29 PM

To correctly handle JDBC transactions, you must first turn off the automatic commit mode, then perform multiple operations, and finally commit or rollback according to the results; 1. Call conn.setAutoCommit(false) to start the transaction; 2. Execute multiple SQL operations, such as INSERT and UPDATE; 3. Call conn.commit() if all operations are successful, and call conn.rollback() if an exception occurs to ensure data consistency; at the same time, try-with-resources should be used to manage resources, properly handle exceptions and close connections to avoid connection leakage; in addition, it is recommended to use connection pools and set save points to achieve partial rollback, and keep transactions as short as possible to improve performance.

Comparing Java Frameworks: Spring Boot vs Quarkus vs Micronaut Comparing Java Frameworks: Spring Boot vs Quarkus vs Micronaut Aug 04, 2025 pm 12:48 PM

Pre-formanceTartuptimeMoryusage, Quarkusandmicronautleadduetocompile-Timeprocessingandgraalvsupport, Withquarkusoftenperforminglightbetterine ServerLess scenarios.2.Thyvelopecosyste,

How does garbage collection work in Java? How does garbage collection work in Java? Aug 02, 2025 pm 01:55 PM

Java's garbage collection (GC) is a mechanism that automatically manages memory, which reduces the risk of memory leakage by reclaiming unreachable objects. 1.GC judges the accessibility of the object from the root object (such as stack variables, active threads, static fields, etc.), and unreachable objects are marked as garbage. 2. Based on the mark-clearing algorithm, mark all reachable objects and clear unmarked objects. 3. Adopt a generational collection strategy: the new generation (Eden, S0, S1) frequently executes MinorGC; the elderly performs less but takes longer to perform MajorGC; Metaspace stores class metadata. 4. JVM provides a variety of GC devices: SerialGC is suitable for small applications; ParallelGC improves throughput; CMS reduces

Comparing Java Build Tools: Maven vs. Gradle Comparing Java Build Tools: Maven vs. Gradle Aug 03, 2025 pm 01:36 PM

Gradleisthebetterchoiceformostnewprojectsduetoitssuperiorflexibility,performance,andmoderntoolingsupport.1.Gradle’sGroovy/KotlinDSLismoreconciseandexpressivethanMaven’sverboseXML.2.GradleoutperformsMaveninbuildspeedwithincrementalcompilation,buildcac

Java Concurrency Utilities: ExecutorService and Fork/Join Java Concurrency Utilities: ExecutorService and Fork/Join Aug 03, 2025 am 01:54 AM

ExecutorService is suitable for asynchronous execution of independent tasks, such as I/O operations or timing tasks, using thread pool to manage concurrency, submit Runnable or Callable tasks through submit, and obtain results with Future. Pay attention to the risk of unbounded queues and explicitly close the thread pool; 2. The Fork/Join framework is designed for split-and-governance CPU-intensive tasks, based on partitioning and controversy methods and work-stealing algorithms, and realizes recursive splitting of tasks through RecursiveTask or RecursiveAction, which is scheduled and executed by ForkJoinPool. It is suitable for large array summation and sorting scenarios. The split threshold should be set reasonably to avoid overhead; 3. Selection basis: Independent

How to upgrade a MySQL server to a newer version? How to upgrade a MySQL server to a newer version? Aug 03, 2025 am 09:04 AM

CheckcompatibilitywithOS,applications,andfeatures;2.Backupalldata,configs,andlogs;3.Chooseupgrademethod(packagemanager,MySQLInstaller,ormanual);4.Runpost-upgradechecksandtests;5.Resolveissueslikeauthenticationpluginsordeprecatedoptions.Alwaysbackup,t

How to use the observer pattern in Java? How to use the observer pattern in Java? Aug 02, 2025 am 11:52 AM

The clear answer to this question is the recommendation to implement the observer pattern using a custom observer interface. 1. Although Java provides Observable and Observer, the former is a class and has been deprecated and lacks flexibility; 2. The modern recommended practice is to define a functional Observer interface, and the Subject maintains the Observer list and notify all observers when the state changes; 3. It can be used in combination with Lambda expressions to improve the simplicity and maintainability of the code; 4. For GUI or JavaBean scenarios, PropertyChangeListener can be used. Therefore, new projects should adopt a custom observer interface scheme, which is type-safe, easy to test and specializes in modern Java

Implementing MySQL Data Lineage Tracking Implementing MySQL Data Lineage Tracking Aug 02, 2025 pm 12:37 PM

The core methods for realizing MySQL data blood ties tracking include: 1. Use Binlog to record the data change source, enable and analyze binlog, and trace specific business actions in combination with the application layer context; 2. Inject blood ties tags into the ETL process, and record the mapping relationship between the source and the target when synchronizing the tool; 3. Add comments and metadata tags to the data, explain the field source when building the table, and connect to the metadata management system to form a visual map; 4. Pay attention to primary key consistency, avoid excessive dependence on SQL analysis, version control data model changes, and regularly check blood ties data to ensure accurate and reliable blood ties tracking.

See all articles