Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class DBSelectQuery extends DBConnection {
- public static void main(String[] args) {
- selectCourier();
- }
- public static String selectCourier() {
- queryStmt += "SELECT * FROM courier";
- System.out.println(queryStmt);
- return queryStmt;
- }
- }
- public class DBConnection {
- public static Connection con;
- public static String queryStmt;
- public static void main(String[] args) {
- // TODO Auto-generated method stub
- try {
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection("jdbc:mysql://localhost:3306/java_activity", "root", "root");
- System.out.println("Database Connected");
- Statement stmt = con.createStatement();
- ResultSet rs = stmt.executeQuery(queryStmt);
- while (rs.next())
- System.out.println(rs.getInt(1) + " " + rs.getString(2));
- con.close();
- }
- catch (Exception e) {
- System.out.println(e);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement