Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.so37101534;
- import java.sql.*;
- public class So37101534Main {
- public static void main(String[] args) {
- try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3307/mydb", "root", "toot")) {
- try (Statement s = conn.createStatement()) {
- s.execute("CREATE TEMPORARY TABLE Fruit (FruitName VARCHAR(20) PRIMARY KEY)");
- s.execute("INSERT INTO Fruit (FruitName) VALUES ('apple'), ('orange')");
- s.execute("CREATE TEMPORARY TABLE Cheese (CheeseName VARCHAR(20) PRIMARY KEY)");
- s.execute("INSERT INTO Cheese (CheeseName) VALUES ('Cheddar'), ('Gouda')");
- }
- try (
- Statement stmt = conn.createStatement();
- Statement stmt2 = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Fruit");
- ResultSet rs2 = stmt2.executeQuery("SELECT * FROM Cheese")) {
- rs.next();
- System.out.println(rs.getString("FruitName"));
- rs2.next();
- System.out.println(rs2.getString("CheeseName"));
- rs.next();
- System.out.println(rs.getString("FruitName"));
- rs2.next();
- System.out.println(rs2.getString("CheeseName"));
- }
- } catch (Exception e) {
- e.printStackTrace(System.err);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement