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别忘了