API tools faq
paste
Guest User

Untitled

a guest
Jan 17th, 2019
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.34 KB | None | 0 0
raw download clone embed print report
  1. import java.sql.*;
  2.  
  3. public class DataBaseConnector
  4. {
  5. private Connection con;
  6.  
  7. public DataBaseConnector()
  8. {
  9.  
  10. }
  11.  
  12. private void createConnection()
  13. {
  14. try
  15. {
  16. Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
  17. con = DriverManager.getConnection("jdbc:derby:contact","yohan","xyz");
  18. }
  19. catch(Exception e)
  20. {
  21. e.printStackTrace();
  22. }
  23. }
  24.  
  25. private void closeConnection()
  26. {
  27. try
  28. {
  29. con.close();
  30. }
  31. catch(Exception e)
  32. {
  33. e.printStackTrace();
  34. }
  35. }
  36.  
  37.  
  38. public void insertData(int id, String firstName, String lastName)
  39. {
  40. createConnection();
  41. try
  42. {
  43. PreparedStatement ps = con.prepareStatement("insert into FRIENDS values(?,?,?)");
  44. ps.setInt(1, id);
  45. ps.setString(1, firstName);
  46. ps.setString(2, lastName);
  47.  
  48. int result = ps.executeUpdate();
  49.  
  50. if(result>0)
  51. {
  52. System.out.println("Data Inserted");
  53. }
  54. else
  55. {
  56. System.out.println("Something happened");
  57. }
  58. }
  59. catch(Exception e)
  60. {
  61. e.printStackTrace();
  62. }
  63. finally
  64. {
  65. closeConnection();
  66. }
  67. }
  68.  
  69.  
  70. }
  71.  
  72. import java.awt.event.*;
  73. import javax.swing.*;
  74. import java.awt.*;
  75.  
  76. public class DatabaseUI extends JFrame
  77. {
  78. private JLabel firstName, id, lastName;
  79. private JTextField idTxt, firstNameTxt, lastNameTxt;
  80. private JButton ok;
  81.  
  82. public DatabaseUI()
  83. {
  84. firstName = new JLabel("First Name: ");
  85. lastName = new JLabel("Last Name: ");
  86. id = new JLabel("ID: ");
  87.  
  88. firstNameTxt = new JTextField(10);
  89. lastNameTxt = new JTextField(10);
  90. idTxt = new JTextField(10);
  91.  
  92. ok = new JButton("OK");
  93. ok.addActionListener(new OKAction());
  94.  
  95. JPanel centerPanel = new JPanel();
  96. centerPanel.setLayout(new GridLayout(4,2));
  97. centerPanel.add(id);
  98. centerPanel.add(idTxt);
  99. centerPanel.add(firstName);
  100. centerPanel.add(firstNameTxt);
  101. centerPanel.add(lastName);
  102. centerPanel.add(lastNameTxt);
  103. centerPanel.add(new JPanel());
  104. centerPanel.add(ok);
  105.  
  106. getContentPane().add(centerPanel,"Center");
  107.  
  108.  
  109. this.pack();
  110. this.setVisible(true);
  111.  
  112.  
  113. }
  114.  
  115. private class OKAction implements ActionListener
  116. {
  117. public void actionPerformed(ActionEvent ae)
  118. {
  119. DataBaseConnector db = new DataBaseConnector();
  120.  
  121. int id = Integer.parseInt(idTxt.getText());
  122.  
  123. db.insertData(id, firstNameTxt.getText().trim(), lastNameTxt.getText().trim());
  124. }
  125. }
  126.  
  127. public static void main(String[]args)
  128. {
  129. new DatabaseUI();
  130. }
  131. }
  132.  
  133. run:
  134. java.sql.SQLException: Database 'contact' not found.
  135. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  136. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  137. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  138. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  139. at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
  140. at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
  141. at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
  142. at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
  143. at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
  144. at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
  145. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  146. at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
  147. at java.sql.DriverManager.getConnection(DriverManager.java:579)
  148. at java.sql.DriverManager.getConnection(DriverManager.java:221)
  149. at DataBaseConnector.createConnection(DataBaseConnector.java:17)
  150. at DataBaseConnector.insertData(DataBaseConnector.java:40)
  151. at DatabaseUI$OKAction.actionPerformed(DatabaseUI.java:52)
  152. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
  153. at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
  154. at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  155. at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  156. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  157. at java.awt.Component.processMouseEvent(Component.java:6504)
  158. at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
  159. at java.awt.Component.processEvent(Component.java:6269)
  160. at java.awt.Container.processEvent(Container.java:2229)
  161. at java.awt.Component.dispatchEventImpl(Component.java:4860)
  162. at java.awt.Container.dispatchEventImpl(Container.java:2287)
  163. at java.awt.Component.dispatchEvent(Component.java:4686)
  164. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
  165. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
  166. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
  167. at java.awt.Container.dispatchEventImpl(Container.java:2273)
  168. at java.awt.Window.dispatchEventImpl(Window.java:2713)
  169. at java.awt.Component.dispatchEvent(Component.java:4686)
  170. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
  171. at java.awt.EventQueue.access$000(EventQueue.java:101)
  172. at java.awt.EventQueue$3.run(EventQueue.java:666)
  173. at java.awt.EventQueue$3.run(EventQueue.java:664)
  174. at java.security.AccessController.doPrivileged(Native Method)
  175. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  176. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
  177. at java.awt.EventQueue$4.run(EventQueue.java:680)
  178. at java.awt.EventQueue$4.run(EventQueue.java:678)
  179. at java.security.AccessController.doPrivileged(Native Method)
  180. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  181. at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
  182. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
  183. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
  184. at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
  185. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
  186. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
  187. at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
  188. Caused by: java.sql.SQLException: Database 'contactDB' not found.
  189. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  190. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  191. ... 53 more
  192. java.lang.NullPointerException
  193. at DataBaseConnector.insertData(DataBaseConnector.java:43)
  194. at DatabaseUI$OKAction.actionPerformed(DatabaseUI.java:52)
  195. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
  196. at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
  197. at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  198. at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  199. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  200. at java.awt.Component.processMouseEvent(Component.java:6504)
  201. at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
  202. at java.awt.Component.processEvent(Component.java:6269)
  203. at java.awt.Container.processEvent(Container.java:2229)
  204. at java.awt.Component.dispatchEventImpl(Component.java:4860)
  205. at java.awt.Container.dispatchEventImpl(Container.java:2287)
  206. at java.awt.Component.dispatchEvent(Component.java:4686)
  207. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
  208. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
  209. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
  210. at java.awt.Container.dispatchEventImpl(Container.java:2273)
  211. at java.awt.Window.dispatchEventImpl(Window.java:2713)
  212. at java.awt.Component.dispatchEvent(Component.java:4686)
  213. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
  214. at java.awt.EventQueue.access$000(EventQueue.java:101)
  215. at java.awt.EventQueue$3.run(EventQueue.java:666)
  216. at java.awt.EventQueue$3.run(EventQueue.java:664)
  217. at java.security.AccessController.doPrivileged(Native Method)
  218. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  219. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
  220. at java.awt.EventQueue$4.run(EventQueue.java:680)
  221. at java.awt.EventQueue$4.run(EventQueue.java:678)
  222. at java.security.AccessController.doPrivileged(Native Method)
  223. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  224. at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
  225. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
  226. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
  227. at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
  228. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
  229. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
  230. at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
  231. java.lang.NullPointerException
  232. at DataBaseConnector.closeConnection(DataBaseConnector.java:29)
  233. at DataBaseConnector.insertData(DataBaseConnector.java:65)
  234. at DatabaseUI$OKAction.actionPerformed(DatabaseUI.java:52)
  235. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
  236. at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
  237. at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  238. at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  239. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  240. at java.awt.Component.processMouseEvent(Component.java:6504)
  241. at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
  242. at java.awt.Component.processEvent(Component.java:6269)
  243. at java.awt.Container.processEvent(Container.java:2229)
  244. at java.awt.Component.dispatchEventImpl(Component.java:4860)
  245. at java.awt.Container.dispatchEventImpl(Container.java:2287)
  246. at java.awt.Component.dispatchEvent(Component.java:4686)
  247. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
  248. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
  249. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
  250. at java.awt.Container.dispatchEventImpl(Container.java:2273)
  251. at java.awt.Window.dispatchEventImpl(Window.java:2713)
  252. at java.awt.Component.dispatchEvent(Component.java:4686)
  253. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
  254. at java.awt.EventQueue.access$000(EventQueue.java:101)
  255. at java.awt.EventQueue$3.run(EventQueue.java:666)
  256. at java.awt.EventQueue$3.run(EventQueue.java:664)
  257. at java.security.AccessController.doPrivileged(Native Method)
  258. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  259. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
  260. at java.awt.EventQueue$4.run(EventQueue.java:680)
  261. at java.awt.EventQueue$4.run(EventQueue.java:678)
  262. at java.security.AccessController.doPrivileged(Native Method)
  263. at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  264. at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
  265. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
  266. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
  267. at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
  268. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
  269. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
  270. at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
  271.  
  272. con = DriverManager.getConnection("jdbc:derby:contact","yohan","xyz");
  273.  
  274. "jdbc:derby://localhost:1527/contact"
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!