Sample code for Java to connect to MySQL
This article mainly introduces the relevant code of java to connect to MySQL database in detail. It has certain reference value. Interested friends can refer to it.
The example of this article shares with everyone the java to connect to MySQL. The specific code of the database is for your reference. The specific content is as follows
package connect;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class Connect {
//驱动程序位置
public static final String DBDRIVER="com.mysql.jdbc.Driver";
//连接地址
public static final String DBURL="jdbc:mysql://localhost:3306/MySQL";
//用户名
public static final String DBUSER="root";
//密码
public static final String DBPASS="943310";
public static void main(String[] args)throws Exception {
// TODO Auto-generated method stub
String sql="INSERT INTO sakila.newtable(name)VALUES(13)";
try {
Class.forName(DBDRIVER);//使用Class类加载驱动驱动程序
} catch (Exception e) {
// TODO: handle exception
System.out.println("打开驱动失败");
}
try {
Connection conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);
Statement pstmt=null;
pstmt=conn.createStatement();
pstmt.executeUpdate(sql);
pstmt.close();
conn.close();
System.out.println("插入成功");
} catch (Exception e) {
// TODO: handle exception
System.out.println("数据库连接失败");
}
}
}It should be noted that the premise of the above code is that there is a table under the sakila data set in the MySQL database" newtable", and there is a name field in it, which was accidentally set to an integer!
Experience: MySQL57 is just the name of the default instance service, and the name of the database is MySQL; the default port number of MySQL is 3306; before writing the name of the table, you must add the name of the corresponding data set ; When installing MySQL, be sure to select the developer installation mode. The JDBC driver will be automatically installed. After installation, the path to the corresponding jar package must be added to the system library.
The above is the detailed content of Sample code for Java to connect to MySQL. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
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)
Hot Topics
PHP vs. Other Languages: A Comparison
Apr 13, 2025 am 12:19 AM
PHP is suitable for web development, especially in rapid development and processing dynamic content, but is not good at data science and enterprise-level applications. Compared with Python, PHP has more advantages in web development, but is not as good as Python in the field of data science; compared with Java, PHP performs worse in enterprise-level applications, but is more flexible in web development; compared with JavaScript, PHP is more concise in back-end development, but is not as good as JavaScript in front-end development.
How to connect to the database of apache
Apr 13, 2025 pm 01:03 PM
Apache connects to a database requires the following steps: Install the database driver. Configure the web.xml file to create a connection pool. Create a JDBC data source and specify the connection settings. Use the JDBC API to access the database from Java code, including getting connections, creating statements, binding parameters, executing queries or updates, and processing results.
MySQL's Role: Databases in Web Applications
Apr 17, 2025 am 12:23 AM
The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.
How to start mysql by docker
Apr 15, 2025 pm 12:09 PM
The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database
Laravel Introduction Example
Apr 18, 2025 pm 12:45 PM
Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
PHP vs. Python: Use Cases and Applications
Apr 17, 2025 am 12:23 AM
PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.
Solve database connection problem: a practical case of using minii/db library
Apr 18, 2025 am 07:09 AM
I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.
PHP's Impact: Web Development and Beyond
Apr 18, 2025 am 12:10 AM
PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip
