2 * To change this license header, choose License Headers in Project Properties.
3 * To change this template file, choose Tools | Templates
4 * and open the template in the editor.
8 import java
.util
.ArrayList
;
9 import java
.util
.prefs
.Preferences
;
11 import java
.util
.Dictionary
;
12 import java
.util
.HashMap
;
13 import java
.util
.logging
.Level
;
14 import java
.util
.logging
.Logger
;
15 import javax
.swing
.JOptionPane
;
21 public class Utility
{
23 static void setConnectionURL(String text
) {
25 Preferences
.userRoot().put("ConnectionURL", text
);
28 static ArrayList
<Object
> getClientDetails(int r
) {
29 ArrayList
<Object
> res
= new ArrayList
<>();
31 Connection conn
= DriverManager
.getConnection("jdbc:sqlite:"+connectionURL
);
32 PreparedStatement st
= conn
.prepareStatement("SELECT * FROM clients WHERE id=?;");
34 ResultSet rs
= st
.executeQuery();
36 res
.add (rs
.getString("ClientName"));
37 res
.add(rs
.getString("ClientAddress"));
38 res
.add (rs
.getString("ContactPerson"));
39 res
.add (rs
.getString("MailID"));
40 res
.add (rs
.getString("ContactNumber"));
45 } catch (SQLException ex
) {
46 Logger
.getLogger(Utility
.class.getName()).log(Level
.SEVERE
, null, ex
);
52 static boolean addClient(String client_name
, String client_address
,
53 String contact_person
, String email_id
, String phone_number
) {
54 if ("".equals(client_name
))
57 Connection conn
= DriverManager
.getConnection("jdbc:sqlite:" + connectionURL
);
58 PreparedStatement st
= conn
.prepareStatement("INSERT INTO clients (ClientName,"
59 + "ClientAddress, ContactPerson, MailID, ContactNumber) VALUES (?, ?, ?, ?, ?);");
60 st
.setString(1, client_name
);
61 st
.setString(2, client_address
);
62 st
.setString(3, contact_person
);
63 st
.setString (4, email_id
);
64 st
.setString (5, phone_number
);
69 } catch (SQLException ex
) {
70 Logger
.getLogger(Utility
.class.getName()).log(Level
.SEVERE
, null, ex
);
77 static boolean deleteClient(int r
) {
79 Connection conn
= DriverManager
.getConnection("jdbc:sqlite:" + connectionURL
);
80 PreparedStatement st
= conn
.prepareStatement("DELETE FROM clients WHERE id=?;");
81 PreparedStatement st2
= conn
.prepareStatement("DELETE FROM legalnotices WHERE ClientId=?;");
88 } catch (SQLException ex
) {
89 Logger
.getLogger(Utility
.class.getName()).log(Level
.SEVERE
, null, ex
);
95 static boolean updateClient(int r
, String client_name
, String client_address
,
96 String contact_person
, String mail_id
, String phone_number
) {
97 if ("".equals(client_name
))
100 Connection conn
= DriverManager
.getConnection("jdbc:sqlite:" + connectionURL
);
101 PreparedStatement st
= conn
.prepareStatement("UPDATE clients SET "
102 + "ClientName=?, ClientAddress=?,"
103 + "ContactPerson=?, MailID=?, ContactNumber=? WHERE id=?;");
104 st
.setString(1, client_name
);
105 st
.setString(2, client_address
);
106 st
.setString(3, contact_person
);
107 st
.setString(4, mail_id
);
108 st
.setString(5, phone_number
);
113 } catch (SQLException ex
) {
114 Logger
.getLogger(Utility
.class.getName()).log(Level
.SEVERE
, null, ex
);
123 public static String connectionURL
;
129 public static ArrayList
<Object
> getClientsNameAndId () {
130 ArrayList
<Object
> data
= new ArrayList
<>();
132 Connection conn
= DriverManager
.getConnection("jdbc:sqlite:" + connectionURL
);
133 Statement st
= conn
.createStatement();
134 ResultSet rs
= st
.executeQuery("SELECT id, ClientName from clients;");
136 data
.add(rs
.getInt("id"));
137 data
.add(rs
.getString("ClientName"));
141 } catch (SQLException ex
) {
142 Logger
.getLogger(Utility
.class.getName()).log(Level
.SEVERE
, null, ex
);
148 public static void getConnectionURL () {
149 connectionURL
= Preferences
.userRoot().get("ConnectionURL", "legaldb");