mysql:
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/spring_mybatis";
String user="root";
String password="root";
Connection conn= DriverManager.getConnection(url, user, password);
Statement statement =conn.createStatement();
ResultSet rs=statement.executeQuery("select * from items");
orcale:
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:test";
String user="root";
String password="root";
Connection conn= DriverManager.getConnection(url, user, password);
Statement statement =conn.createStatement();
ResultSet rs=statement.executeQuery("select * from items");