Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mysqldataconnection;
- import java.sql.Connection;
- import java.sql.Date;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- public class MysqlDataConnection {
- public static void main(String[] args) {
- opgaver xd = new opgaver();
- System.out.println("Dette er det ældste lån der findes i databasen: "+xd.opg4());
- }
- }
- class opgaver {
- public String opg1() {
- String sql = "select * from bog order by udgivelsesår";
- String bog = "";
- try (Connection conn = connection.getConnection();
- PreparedStatement ps = conn.prepareStatement(sql)) {
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- int id = rs.getInt("BogID");
- String titel = rs.getString("Titel");
- String forfatter = rs.getString("Forfatternavn");
- String forlag = rs.getString("Forlag");
- int udgivelsesår = rs.getInt("Udgivelsesår");
- bog += id + " " + titel + " " + forfatter + " " + forlag + " " + udgivelsesår + "\n";
- //System.out.println(id + " " + titel + " " + forfatter + " " + forlag + " " + udgivelsesår);
- }
- } catch (SQLException e) {
- System.out.println("Fejl i connection til database");
- e.printStackTrace();
- }
- return bog;
- }
- public String opg4() {
- String sql = "select * from låner inner join udlån using (lånerid) order by dato limit 1";
- String ældsteLån = " ";
- try (Connection conn = connection.getConnection();
- PreparedStatement ps = conn.prepareStatement(sql)) {
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- int lånerID = rs.getInt("LånerID");
- String navn = rs.getString("Navn");
- String adresse = rs.getString("Adresse");
- int postnr = rs.getInt("Postnr");
- int bogID = rs.getInt("BogID");
- Date dato = rs.getDate("Dato");
- ældsteLån += lånerID + " " + navn + " " + adresse + " " + postnr + " " + bogID + " " + dato + "\n";
- }
- } catch (SQLException e) {
- System.out.println("Fejl i connection til database");
- e.printStackTrace();
- }
- return ældsteLån;
- }
- }
- class connection {
- public static Connection getConnection() throws SQLException {
- String url = "jdbc:mysql://root@localhost:3306/bibliotek";
- String user = "root";
- String password = "uqt42vqx";
- Connection conn = DriverManager.getConnection(url, user, password);
- return conn;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement