网站建设知识
jdbc连接mysql
2025-07-22 09:55  点击:0
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 blocke.printStackTrace();}}}
Main.java

public class Main {public static void main(String[] args) {// TODO Auto-generated method stubTest.insertdata();System.out.println("finish");}}

输出 : finish



记得要加载jar别忘了