Maven连接数据库

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);
    }
}

成品