Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT pupil.name, pupil.surname, mark_value.values
- FROM pupil, mark_value, mark
- WHERE pupil.id = mark.pupil_id AND mark.mark_id = mark_value.id
- package sqltest;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class SQLtest {
- private static final String url = "jdbc:mysql://localhost:3306/school_db?useTimezone=true&serverTimezone=GMT";
- private static final String user = "root";
- private static final String password = "123456";
- private static Connection con;
- private static PreparedStatement stmtGetStudent;
- private static PreparedStatement stmtGetMarks;
- private static ResultSet rs;
- public static void main(String args[]) {
- String query = "SELECT student.id, student.name ,student.surname from student";
- String query1 = "";
- try {
- con = DriverManager.getConnection(url, user, password);
- stmtGetStudent = con.prepareStatement(query);
- stmtGetMarks = con.prepareStatement(query1);
- //stmtGetMarks.setString(1, "Vasya");
- //stmtGetMarks.setInt(2, 1234);
- // rs = stmtGetMarks.executeQuery();
- rs = stmtGetStudent.executeQuery();
- while (rs.next()) {
- int id = rs.getInt(1);
- String firstName = rs.getString(2);
- String lastName = rs.getString(3);
- System.out.println("Students : " + firstName + " " + lastName);
- }
- } catch (SQLException sqlEx) {
- sqlEx.printStackTrace();
- } finally {
- try { con.close(); } catch(SQLException se) { }
- try { stmt.close(); } catch(SQLException se) { }
- try { rs.close(); } catch(SQLException se) { }
- }
- }
- }
Add Comment
Please, Sign In to add comment