I have a mysql database that I want to connect to my Java (Spring MVC) project (I'm using IntelliJ). As I learned, I defined the entities and repositories in IntelliJ equivalent to the database's tables. However, I wrote a short code that is able to connect to my datatbase, run sql queries and save/print the query's results:
public static void main(String args[]){ try{ Class.forName("com.mysql.jdbc.Driver"); // Connecting to mySql Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/theprocess?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","root","root"); // Connecting to our database Statement stmt = con.createStatement(); // Object that allows executing SQL queries ResultSet rs = stmt.executeQuery("select * from clients"); // Storing the query's result while(rs.next()) System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)); // Defines which columns to print con.close(); // Closing the connection; }catch(Exception e){ System.out.println(e);} } So my question is, do I even need the entities and repositories if I have that code? Thanks for your help :)
