Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package sk.tuke.tssu;
- import java.sql.*;
- public class MySQLAccess {
- private Connection connect = null;
- private Statement statement = null;
- private PreparedStatement preparedStatement = null;
- private ResultSet resultSet = null;
- public void writeClen(String meno, String priezvisko, String titulPred, String titulZa, String rola, String ulica, String cd, String psc, String mesto, java.sql.Date priradenie, java.sql.Date ukoncenie, int idpreds) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.clen values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
- preparedStatement.setString(1, meno);
- preparedStatement.setString(2, priezvisko);
- preparedStatement.setString(3, titulPred);
- preparedStatement.setString(4, titulZa);
- preparedStatement.setString(5, rola);
- preparedStatement.setString(6, ulica);
- preparedStatement.setString(7, cd);
- preparedStatement.setString(8, psc);
- preparedStatement.setString(9, mesto);
- preparedStatement.setDate(10, priradenie);
- preparedStatement.setDate(11, ukoncenie);
- preparedStatement.setInt(12, idpreds);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writeZivnostnik(String meno, String priezvisko, String titulPred, String titulZa, String ulica, String psc, String cd, String mesto, java.sql.Date priradenie, java.sql.Date ukoncenie, int idStatutOrganu) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.zivnostnik values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
- preparedStatement.setString(1, meno);
- preparedStatement.setString(2, priezvisko);
- preparedStatement.setString(3, titulPred);
- preparedStatement.setString(4, titulZa);
- preparedStatement.setString(5, ulica);
- preparedStatement.setString(6, cd);
- preparedStatement.setString(7, psc);
- preparedStatement.setString(8, mesto);
- preparedStatement.setDate(9, priradenie);
- preparedStatement.setDate(10, ukoncenie);
- preparedStatement.setInt(11, idStatutOrganu);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writeKonatel(String meno, String priezvisko, String titulPred, String titulZa, String ulica, String cd, String psc, String mesto, java.sql.Date priradenie, java.sql.Date ukoncenie, int idStatutOrganu) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.konatel values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?)");
- preparedStatement.setString(1, meno);
- preparedStatement.setString(2, priezvisko);
- preparedStatement.setString(3, titulPred);
- preparedStatement.setString(4, titulZa);
- preparedStatement.setString(5, ulica);
- preparedStatement.setString(6, cd);
- preparedStatement.setString(7, psc);
- preparedStatement.setString(8, mesto);
- preparedStatement.setDate(9, priradenie);
- preparedStatement.setDate(10, ukoncenie);
- preparedStatement.setInt(11, idStatutOrganu);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writeZahranicnaOsoba(String meno, String priezvisko, String titulPred, String titulZa, String ulica, String cd, String psc, String mesto, java.sql.Date priradenie, java.sql.Date ukoncenie, int idStatutOrganu) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.zahraicna_osoba values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?)");
- preparedStatement.setString(1, meno);
- preparedStatement.setString(2, priezvisko);
- preparedStatement.setString(3, titulPred);
- preparedStatement.setString(4, titulZa);
- preparedStatement.setString(5, ulica);
- preparedStatement.setString(6, cd);
- preparedStatement.setString(7, psc);
- preparedStatement.setString(8, mesto);
- preparedStatement.setDate(9, priradenie);
- preparedStatement.setDate(10, ukoncenie);
- preparedStatement.setInt(11, idStatutOrganu);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writeKonecniUzVyhod(String meno, String priezvisko, String titulPred, String titulZa, String ulica, String cd, String psc, String mesto, String verejnyFunkcionar, String ico) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.konečni_uzivatelia_vyhod values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?,?)");
- preparedStatement.setString(1, meno);
- preparedStatement.setString(2, priezvisko);
- preparedStatement.setString(3, titulPred);
- preparedStatement.setString(4, titulZa);
- preparedStatement.setString(5, ulica);
- preparedStatement.setString(6, cd);
- preparedStatement.setString(7, psc);
- preparedStatement.setString(8, mesto);
- preparedStatement.setString(9, verejnyFunkcionar);
- preparedStatement.setString(10, ico);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writeDodavatel(String obchMeno, String ico, java.sql.Date zapis, java.sql.Date vymazanie, String pravnaForma, String Ulica, String psc, String cd, String Mesto) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.dodavatel values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
- preparedStatement.setString(1, obchMeno);
- preparedStatement.setString(2, ico);
- preparedStatement.setDate(3, zapis);
- preparedStatement.setDate(4, vymazanie);
- preparedStatement.setString(5, pravnaForma);
- preparedStatement.setString(6, Ulica);
- preparedStatement.setString(7, psc);
- preparedStatement.setString(8, cd);
- preparedStatement.setString(9, Mesto);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writeStatutarnyOrgan(String typ, int id_dodavatel) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.statutarny_organ values (default, ?, ?)");
- preparedStatement.setString(1, typ);
- preparedStatement.setInt(2, id_dodavatel);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void writPredstavenstvo(String predseda, String podpredseda, int id_statutOrganu) throws Exception {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.predstavenstvo values (default, ?, ?, ?)");
- preparedStatement.setString(1, predseda);
- preparedStatement.setString(2, podpredseda);
- preparedStatement.setInt(3, id_statutOrganu);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- public void readDataBase(String dodavatel, long ico, String cislo, String mena, Double cena, java.sql.Date vystavenie, java.sql.Date splatnost, java.sql.Date uhradenie, String odoberatel) throws Exception {
- try {
- // toto načíta MySQL ovládač, každá DB má vlastný ovládač
- Class.forName("com.mysql.jdbc.Driver");
- // Nastavenie spojenia s DB
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- // pre vyobrazenie
- // resultSet = statement.executeQuery("select * from tssu.faktura");
- // writeResultSet(resultSet);
- preparedStatement = connect.prepareStatement("insert into tssu.faktura values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
- // ALTER TABLE tablename AUTO_INCREMENT = 1
- // Parameters start with 1
- preparedStatement.setString(1, dodavatel);
- preparedStatement.setString(2, cislo);
- preparedStatement.setLong(3, ico);
- preparedStatement.setDouble(4, cena);
- preparedStatement.setString(5, mena);
- preparedStatement.setDate(6, vystavenie);
- preparedStatement.setDate(7, splatnost);
- preparedStatement.setDate(8, uhradenie);
- preparedStatement.setString(9, odoberatel);
- preparedStatement.executeUpdate();
- // preparedStatement = connect.prepareStatement("SELECT dodavatel, cislo, ico, predmet, cena from tssu.faktura");
- // resultSet = preparedStatement.executeQuery();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- // You need to close the resultSet
- private void close() {
- try {
- if (resultSet != null) {
- resultSet.close();
- }
- if (statement != null) {
- statement.close();
- }
- if (connect != null) {
- connect.close();
- }
- } catch (Exception e) {
- }
- }
- public int readId() throws Exception {
- int id = 0;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- String preparedStatement = "select count(dodavatel.id) from dodavatel;";
- ResultSet rs = statement.executeQuery(preparedStatement);
- while (rs.next()) {
- id = rs.getInt(1);
- break;
- }
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- return id;
- }
- public int readIdStatu() throws Exception {
- int id = 0;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- String preparedStatement = "select count(statutarny_organ.ID_Statut_Orgánu) from statutarny_organ;";
- ResultSet rs = statement.executeQuery(preparedStatement);
- while (rs.next()) {
- id = rs.getInt(1);
- break;
- }
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- return id;
- }
- public int readIdPredstaven() throws Exception {
- int id = 0;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- String preparedStatement = "select count(predstavenstvo.ID_Predstavenstva) from predstavenstvo;";
- ResultSet rs = statement.executeQuery(preparedStatement);
- while (rs.next()) {
- id = rs.getInt(1);
- break;
- }
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- return id;
- }
- public void writeDataBase(Long ico) throws Exception {
- try {
- // toto načíta MySQL ovládač, každá DB má vlastný ovládač
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/tssu?user=tssuuser&password=tssuuserPW&autoReconnect=true&useSSL=false");
- statement = connect.createStatement();
- preparedStatement = connect.prepareStatement("insert into tssu.rpvs values (?)");
- // Parameters start with 1
- preparedStatement.setLong(1, ico);
- preparedStatement.executeUpdate();
- } catch (Exception e) {
- throw e;
- } finally {
- close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement