Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package data;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import java.util.List;
- import domain.Hold;
- import domain.Kamp;
- public class HoldData {
- public List<Hold> holdSelect(Hold hold) {
- List<Hold> list = new ArrayList<>();
- try (Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mydb", "SA", "");
- PreparedStatement statement = connection.prepareStatement(
- "SELECT holdnavn, totalspil, totalemål, holdid from KAMP.HOLD");) {
- ResultSet rs = statement.executeQuery();
- while (rs.next()) {
- Hold e = new Hold();
- e.setHoldNavn(rs.getString("holdNavn"));
- e.setSpilledeKampe(rs.getInt("totalspil"));
- e.setSamletMål(rs.getInt("totalemål"));
- e.setHoldId(rs.getInt("holdId"));
- list.add(e);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return list;
- } public void holdSelectKampe(Kamp kamp) {
- try (Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mydb", "SA", "");
- PreparedStatement statement = connection.prepareStatement(
- "SELECT holdnavn, totalspil, totalemål, holdid from KAMP.HOLD where holdnavn=?");
- PreparedStatement statement1 = connection.prepareStatement(
- "UPDATE KAMP.HOLD SET totalspil = ?, totalemål = ? where holdnavn = ?");
- PreparedStatement statement2 = connection.prepareStatement(
- "SELECT holdnavn, totalspil, totalemål, holdid from KAMP.HOLD where holdnavn=?");
- PreparedStatement statement3 = connection.prepareStatement(
- "UPDATE KAMP.HOLD SET totalspil = ?, totalemål = ? where holdnavn = ?");) {
- // hjemme
- connection.setAutoCommit(false);
- System.out.println(kamp.getHjemmeHold());
- System.out.println(kamp.getUdeHold());
- System.out.println(kamp.getId());
- int spil = 0;
- int mål = 0;
- statement.setString(1, kamp.getHjemmeHold());
- ResultSet rs = statement.executeQuery();
- rs.next();
- spil = rs.getInt("totalspil");
- mål = rs.getInt("totalemål");
- spil++;
- System.out.println(spil+"hjemme");
- statement1.setInt(1, spil);
- statement1.setInt(2, mål);
- statement1.setString(3, kamp.getHjemmeHold());
- //ude
- int spilUde = 0;
- int målUde = 0;
- statement2.setString(1, kamp.getUdeHold());
- ResultSet rs1 = statement.executeQuery();
- rs1.next();
- spilUde = rs1.getInt("totalspil");
- målUde = rs1.getInt("totalemål");
- spilUde++;
- System.out.println(spilUde + "ude");
- statement3.setInt(1, spilUde);
- statement3.setInt(2, målUde);
- statement3.setString(3, kamp.getUdeHold());
- statement.execute();
- statement1.execute();
- statement2.execute();
- statement3.execute();
- connection.commit();
- spil=0;
- spilUde=0;
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public void holdInsert(Hold hold) {
- try (Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mydb", "SA", "");
- PreparedStatement statement = connection.prepareStatement(
- "INSERT INTO kamp.hold (holdnavn, totalspil, totalemål ) VALUES ( ?, ?, ?)");) {
- try {
- connection.setAutoCommit(false);
- statement.setString(1, hold.getHoldNavn());
- statement.setInt(2, hold.getSpilledeKampe());
- statement.setInt(3, hold.getSamletMål());
- int antal = statement.executeUpdate();
- System.out.println("Antal rækker berørt : " + antal);
- connection.commit();
- } catch (SQLException e) {
- System.out.println("ups..... Fejl ved indsættelse");
- connection.rollback();
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public void holdDelete (Hold hold) {
- try (Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mydb", "SA", "");
- PreparedStatement statement = connection.prepareStatement(
- "DELETE FROM kamp.hold WHERE holdnavn=? AND totalspil=? and totalemål=? holdid=?;");) {
- try {
- connection.setAutoCommit(false);
- statement.setString(1, hold.getHoldNavn());
- statement.setInt(2, hold.getSpilledeKampe());
- statement.setInt(3, hold.getSamletMål());
- statement.setInt(4, hold.getHoldId());
- int antal = statement.executeUpdate();
- System.out.println("Antal rækker berørt : " + antal);
- System.out.println("Hold slettet");
- connection.commit();
- } catch (SQLException e) {
- System.out.println(" Ups..... Fejl ved delete");
- connection.rollback();
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement