I am working on Spring CLI shell code in IntelliJ. I run it and set some parameters. But when I type insert and press enter, the console does not accept it, and it seems that nothing happened!
My code is:
@Component public class HelloWorldCommands implements CommandMarker { @CliCommand(value = "insert", help = "insert data to ParsEMS DB") public void insert() { try { Class.forName("org.postgresql.Driver"); Connection con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/ParsEMS", "xxxxxx", "xxxxxxx"); Statement st = con.createStatement(); st.executeUpdate("INSERT INTO node (name, destination) VALUES ('b', 200)"); } catch (Exception e) { e.printStackTrace(); } System.out.println("insert to ParsEMS DB"); } } public class Main { public static void main(String[] args) throws Exception { Bootstrap.main(args); } }
Below I see the result when I run it;
1.1.0.RELEASE
Welcome to Spring Shell. For help, press or enter βhintβ, then press ENTER.
spring shell>
source share