需要的请根据自己的需求调整,代码简陋,但是搬砖还是可以的,对于mysql的插入时候可以修改引擎myisam这样可以快点。
import java.sql.*; /** * Created by admin on 17/10/19. */ public class MOConnect { public Connection conn = null;// 创建一个数据库连接 public ResultSet res = null;// 创建一个结果集对象 public PreparedStatement stmt = null; public Statement Connect(String sql, String url, String driver, String userName, String password) { try { Class.forName(driver); conn = DriverManager.getConnection(url, userName, password); stmt = conn.prepareStatement(sql); return stmt; } catch (ClassNotFoundException e) {