作者:凯锐斯_372 | 来源:互联网 | 2018-04-19 07:09
TestjavaimportjavasqlDriverManager;importjavasqlResultSet;importjavasqlSQLException;importjavasqlConnection;importjavasqlStatement;publicclassTest{staticCon
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别忘了