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!