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