private Connection getConnection() throws SQLException{
String url = "jdbc:mysql://localhost:3306/shop";
String user = "root";
String password = "123";
try {
Class.forName("com.mysql.jdbc.Driver");
return DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return null;
}