php mysql jdbc_jdbc连接mysql_MySQL

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; // 声明Connection对象

static Statement sql; // 声明Statement对象

static ResultSet res;

public Connection getConnection() { // 连接数据库方法

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; // 返回Connection对象

}

// ///

public static void insertdata() {

Test c = new Test();

con = c.getConnection();

try {

sql = con.createStatement();

sql.executeUpdate(" insert into stu values(12,'Shara' ) ;");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

Main.java

public class Main {

public static void main(String[] args) {

// TODO Auto-generated method stub

Test.insertdata();

System.out.println("finish");

}

}

输出 : finish

记得要加载jar别忘了

本文原创发布php中文网，转载请注明出处，感谢您的尊重！