在连接数据库之前我们需要下载编译工具,数据库,以及在编译器中导入相应的jar包,在这里使用idea编译器,mysql数据库
public class Main {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
stmt = conn.createStatement();
String sql = "insert into c(name) values(4564564) ";
stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}