Connect jdbc to mysql and jdbcmysql
Test.java
Import java. SQL. driverManager; import java. SQL. resultSet; import java. SQL. SQLException; import java. SQL. connection; import java. SQL. statement; public class Test {static Connection con; // declare the Connection object static Statement SQL; // declare the Statement object static ResultSet res; public Connection getConnection () {// database connection method try {Class. forName ("org. gjt. mm. mysql. driver "); con = DriverManager. getConnection ("jdbc: mysql: // 127.0.0.1: 3306/test", "root", "0000");} catch (Exception e) {e. printStackTrace ();} return con; // return the Connection object} // public static void insertdata () {Test c = new Test (); con = c. getConnection (); try {SQL = con.createstatement(;; SQL .exe cuteUpdate ("insert into stu values (12, 'shara');");} catch (SQLException e) {// TODO Auto-generated catch blocke. printStackTrace ();}}}
Main.java
public class Main {public static void main(String[] args) {// TODO Auto-generated method stubTest.insertdata();System.out.println("finish");}}
Output: finish
Remember to load the jar.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.