pom.xml
<dependencies>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.6</version>
</dependency>
</dependencies>
App.java
public class App {
public static void main(String[] args) throws Exception{
Class.forName("com.mysql.cj.jdbc.Driver");
String url="jdbc:mysql://118.31.103.39:3306/yao";
String username="user001";
String password="123456";
Connection connection=DriverManager.getConnection(url,username,password);
String sql="insert into one(name,sex,age) values (?,?,?)";
PreparedStatement god=connection.prepareStatement(sql);
god.setString(1,"Aabbye");
god.setString(2,"women");
god.setInt(3,12);
god.execute();
fin.close();
god.close();
connection.close();
System.out.println(connection);
}
}
成品
