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