MySQL learning Java graphic code example to connect to MySQL database
Sep 08, 2017 pm 02:24 PM1. 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!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

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.

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

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

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

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

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

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

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.
