import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
//在项目中, 新建了一个lib文件,用来放jar包
public class DBHelper {
public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3307/fuqiming"; // 端口号 我的是 3307. 默认的是3306.
String sql = "insert into test(name,job) values('影魔','中单')";
String name = "com.mysql.jdbc.Driver";
String user = "fqm";
String password = "fqm";
Class.forName(name); // 指定连接类型
Connection conn = DriverManager.getConnection(url, user, password);// 获取连接
PreparedStatement pst = conn.prepareStatement(sql);// 准备执行语句
pst.executeUpdate();// 执行 UPDATE;
System.out.println("执行" + sql + "语句成功");}}
=====================================