public void insert(){
Connection connection = null;
Statement statement =null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/xinzhi", "root", "root");
statement = connection.createStatement();
int i = statement.executeUpdate("insert into user values (0,'高震',20,'男',258741,'下庄岭')");
System.out.println("受影响行数"+i);
if (i != 0){
System.out.println("新增成功");
}else {
System.out.println("新增失败");
}
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}finally {
try{
if (statement !=null)
statement.cancel();
if (connection !=null){
connection.close();
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}