首先要导入mysql jar包
mysql-connector-java-5.1.30.jar
代码:
package testJDBC; import java.sql.*; public class MainTest { private static String driver = "com.mysql.jdbc.Driver"; private static String url = "jdbc:mysql://localhost:3306/paygateway?useUnicode=true&characterEncoding=UTF-8"; private static String username = "root"; private static String password = "123456"; public static void main(String[] args) { try { Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); Statement statement = conn.createStatement(); //组装sql String sql = "insert into tableName(fieldName) values (value)"; statement.executeUpdate(sql); //查询 //statement.executeQuery(sql); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }