public class file {
public static final String url = "jdbc:mysql://localhost:3306/carinfo";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "root";
public static final String password = "";
public Connection conn = null;
public void DBHelper(){
try {
Class.forName(name);
conn = DriverManager.getConnection(url, user, password);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM msg2 WHERE VINID LIKE '-%'");
while (rs.next()){
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void close(){
try {
this.conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}