API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 9th, 2016
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.06 KB | None | 0 0
raw download clone embed print report
  1. public class WolffAddressManagerMVCJFrameVIEW extends javax.swing.JFrame {
  2. /**
  3. * Creates new form StoringAdresses1JFrame
  4. */
  5. public WolffAddressManagerMVCJFrameVIEW() {
  6. initComponents();
  7. }
  8.  
  9. @SuppressWarnings("unchecked")
  10.  
  11. private void initComponents() {
  12.  
  13. jPanel1 = new javax.swing.JPanel();
  14. jLabel1 = new javax.swing.JLabel();
  15. jLabel2 = new javax.swing.JLabel();
  16. jLabel3 = new javax.swing.JLabel();
  17. jLabel4 = new javax.swing.JLabel();
  18. jLabel5 = new javax.swing.JLabel();
  19. jLabel6 = new javax.swing.JLabel();
  20. jLabel7 = new javax.swing.JLabel();
  21. firstName = new javax.swing.JTextField();
  22. lastName = new javax.swing.JTextField();
  23. emailAdress = new javax.swing.JTextField();
  24. searchEmailAdress = new javax.swing.JTextField();
  25. removeEmailAddress = new javax.swing.JTextField();
  26. street = new javax.swing.JTextField();
  27. number = new javax.swing.JTextField();
  28. additive = new javax.swing.JTextField();
  29. zipCode = new javax.swing.JTextField();
  30. city = new javax.swing.JTextField();
  31. addAdress = new javax.swing.JButton();
  32. removeAdress = new javax.swing.JButton();
  33. searchAdress = new javax.swing.JButton();
  34. jPanel2 = new javax.swing.JPanel();
  35. jScrollPane1 = new javax.swing.JScrollPane();
  36. showInputOutput = new javax.swing.JTextArea();
  37.  
  38. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  39.  
  40. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Address Input Fields", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Trebuchet MS", 1, 14))); // NOI18N
  41.  
  42. jLabel1.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  43. jLabel1.setText("First Name:");
  44.  
  45. jLabel2.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  46. jLabel2.setText("Last Name:");
  47.  
  48. jLabel3.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  49. jLabel3.setText("Email Adress:");
  50.  
  51. jLabel4.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  52. jLabel4.setText("Street / Number / Add");
  53.  
  54. jLabel5.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  55. jLabel5.setText("Zipcode / City");
  56.  
  57. jLabel6.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  58. jLabel6.setText("Email Address:");
  59.  
  60. jLabel7.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  61. jLabel7.setText("Email Address:");
  62.  
  63. firstName.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  64.  
  65. lastName.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  66.  
  67. emailAdress.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  68.  
  69. street.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  70.  
  71. number.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  72.  
  73. additive.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  74.  
  75. zipCode.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  76.  
  77. city.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
  78.  
  79. addAdress.setFont(new java.awt.Font("Trebuchet MS", 1, 14)); // NOI18N
  80. addAdress.setText("Add Address");
  81. ActionListener actionListener = new MainWindowActionListenerMVCVIEW(firstName, lastName, emailAdress, street, number, additive, zipCode, city, searchEmailAdress, removeEmailAddress);
  82. addAdress.addActionListener(actionListener);
  83.  
  84. removeAdress.setFont(new java.awt.Font("Trebuchet MS", 1, 14)); // NOI18N
  85. removeAdress.setText("Remove Address");
  86. removeAdress.setBackground(Color.RED);
  87. removeAdress.addActionListener(actionListener);
  88.  
  89. searchAdress.setFont(new java.awt.Font("Trebuchet MS", 1, 14)); // NOI18N
  90. searchAdress.setText("Search Address");
  91. searchAdress.addActionListener(actionListener);
  92.  
  93.  
  94. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  95. jPanel1.setLayout(jPanel1Layout);
  96. jPanel1Layout.setHorizontalGroup(
  97. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  98. .addGroup(jPanel1Layout.createSequentialGroup()
  99. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  100. .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  101. .addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  102. .addComponent(jLabel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  103. .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  104. .addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  105. .addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  106. .addComponent(jLabel7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  107. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  108. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  109. .addGroup(jPanel1Layout.createSequentialGroup()
  110. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  111. .addComponent(firstName)
  112. .addComponent(lastName)
  113. .addComponent(emailAdress)
  114. .addComponent(searchEmailAdress)
  115. .addComponent(removeEmailAddress)
  116. .addGroup(jPanel1Layout.createSequentialGroup()
  117. .addComponent(street, javax.swing.GroupLayout.PREFERRED_SIZE, 147, javax.swing.GroupLayout.PREFERRED_SIZE)
  118. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  119. .addComponent(number, javax.swing.GroupLayout.DEFAULT_SIZE, 49, Short.MAX_VALUE)
  120. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  121. .addComponent(additive, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)))
  122. .addGap(8, 8, 8))
  123. .addGroup(jPanel1Layout.createSequentialGroup()
  124. .addComponent(zipCode, javax.swing.GroupLayout.PREFERRED_SIZE, 114, javax.swing.GroupLayout.PREFERRED_SIZE)
  125. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  126. .addComponent(city)
  127. .addContainerGap())))
  128. .addGroup(jPanel1Layout.createSequentialGroup()
  129. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  130. .addComponent(addAdress, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  131. .addComponent(removeAdress, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  132. .addComponent(searchAdress, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  133. .addContainerGap())
  134. );
  135. jPanel1Layout.setVerticalGroup(
  136. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  137. .addGroup(jPanel1Layout.createSequentialGroup()
  138. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  139. .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  140. .addGroup(jPanel1Layout.createSequentialGroup()
  141. .addGap(2, 2, 2)
  142. .addComponent(firstName, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)))
  143. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  144. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  145. .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  146. .addComponent(lastName, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
  147. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  148. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  149. .addComponent(emailAdress, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  150. .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
  151. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  152. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  153. .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  154. .addComponent(street, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  155. .addComponent(number, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  156. .addComponent(additive, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
  157. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  158. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  159. .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  160. .addComponent(zipCode, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  161. .addComponent(city, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
  162. .addGap(41, 41, 41)
  163. .addComponent(addAdress, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  164. .addGap(18, 18, 18)
  165.  
  166. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  167. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  168. .addComponent(removeEmailAddress, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  169. .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
  170. .addGap(18, 18, 18)
  171. .addComponent(removeAdress, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  172. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  173. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  174. .addComponent(searchEmailAdress, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  175. .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
  176. .addGap(18, 18, 18)
  177. .addComponent(searchAdress, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
  178. .addContainerGap(203, Short.MAX_VALUE))
  179. );
  180.  
  181. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Show Input / Show Search", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Trebuchet MS", 1, 14))); // NOI18N
  182.  
  183. showInputOutput.setFont(new java.awt.Font("Trebuchet MS", 1, 14)); // NOI18N
  184. jScrollPane1.setViewportView(showInputOutput);
  185.  
  186. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  187. jPanel2.setLayout(jPanel2Layout);
  188. jPanel2Layout.setHorizontalGroup(
  189. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  190. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 349, Short.MAX_VALUE)
  191. );
  192. jPanel2Layout.setVerticalGroup(
  193. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  194. .addComponent(jScrollPane1)
  195. );
  196.  
  197. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  198. getContentPane().setLayout(layout);
  199. layout.setHorizontalGroup(
  200. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  201. .addGroup(layout.createSequentialGroup()
  202. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  203. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  204. .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  205. .addContainerGap())
  206. );
  207. layout.setVerticalGroup(
  208. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  209. .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  210. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  211. );
  212.  
  213. pack();
  214. }
  215. private javax.swing.JButton addAdress;
  216. private javax.swing.JButton removeAdress;
  217. private javax.swing.JButton searchAdress;
  218. private javax.swing.JLabel jLabel1;
  219. private javax.swing.JLabel jLabel2;
  220. private javax.swing.JLabel jLabel3;
  221. private javax.swing.JLabel jLabel4;
  222. private javax.swing.JLabel jLabel5;
  223. private javax.swing.JLabel jLabel6;
  224. private javax.swing.JLabel jLabel7;
  225. public javax.swing.JTextArea showInputOutput;
  226. private javax.swing.JPanel jPanel1;
  227. private javax.swing.JPanel jPanel2;
  228. private javax.swing.JScrollPane jScrollPane1;
  229. private javax.swing.JTextField firstName;
  230. private javax.swing.JTextField lastName;
  231. private javax.swing.JTextField emailAdress;
  232. private javax.swing.JTextField searchEmailAdress;
  233. private javax.swing.JTextField removeEmailAddress;
  234. private javax.swing.JTextField street;
  235. private javax.swing.JTextField number;
  236. private javax.swing.JTextField additive;
  237. private javax.swing.JTextField zipCode;
  238. private javax.swing.JTextField city;
  239. }
  240.  
  241. public class MainWindowActionListenerMVCVIEW implements ActionListener {
  242. public JTextField firstName, lastName, emailAddress, street, number, additive, zipCode, city, searchEmailAdress, removeEmailAddress;
  243.  
  244.  
  245. public MainWindowActionListenerMVCVIEW(JTextField fName, JTextField lName, JTextField eAddress, JTextField streetName, JTextField houseNumber, JTextField add, JTextField zCode, JTextField cityName, JTextField searchEAdress, JTextField removeEAddress) {
  246.  
  247. this.firstName = fName;
  248. this.lastName = lName;
  249. this.emailAddress = eAddress;
  250. this.street = streetName;
  251. this.number = houseNumber;
  252. this.additive = add;
  253. this.zipCode = zCode;
  254. this.city = cityName;
  255. this.searchEmailAdress = searchEAdress;
  256. this.removeEmailAddress = removeEAddress;
  257. }
  258.  
  259.  
  260. @Override
  261. public void actionPerformed(ActionEvent e) {
  262. firstName.getText();
  263. lastName.getText();
  264. emailAddress.getText();
  265. street.getText();
  266. number.getText();
  267. additive.getText();
  268. zipCode.getText();
  269. city.getText();
  270. searchEmailAdress.getText();
  271. removeEmailAddress.getText();
  272. System.out.println("test" + " " + firstName.getText());
  273.  
  274. }
  275. }
  276.  
  277. public class WolffAddressManagerMVCMODEL {
  278. public String firstName;
  279. public String lastName;
  280. public String emailAddress;
  281. public String street;
  282. public String number;
  283. public String additive;
  284. public String zipCode;
  285. public String city;
  286. }
  287.  
  288. public class WolffAddressManagerMVCController {
  289. public WolffAddressManagerMVCMODEL controllerModel;
  290. public MainWindowActionListenerMVCVIEW controllerActionListener;
  291. public WolffAddressManagerMVCJFrameVIEW controllerJFrame;
  292. private Connection connect = null;
  293. private final Statement statement = null;
  294. private PreparedStatement preparedStatement = null;
  295. private ResultSet resultSet = null;
  296. public ArrayList<String> queryResultSet = new ArrayList();
  297.  
  298. public void saveAddressToDataBase(MainWindowActionListenerMVCVIEW controller) throws Exception {
  299.  
  300. try {
  301. Class.forName("com.mysql.jdbc.Driver");
  302. connect = DriverManager.getConnection("jdbc:mysql://localhost/dev?" + "user=root&password=fiat128slc");
  303. preparedStatement = connect.prepareStatement("SELECT email FROM dev.addresses WHERE email= '" + controller.emailAddress.getText() + "'");
  304. resultSet = preparedStatement.executeQuery();
  305.  
  306. if(resultSet.next()) {
  307. JOptionPane.showMessageDialog(null, "Email already exist", "InfoBox: " + "Error", JOptionPane.INFORMATION_MESSAGE);
  308. } else {
  309. preparedStatement = connect.prepareStatement("INSERT INTO dev.addresses (firstname, lastname, email, street, housenumber, additve, zipcode, city) VALUES(?, ?, ?, ?, ?, ?, ?, ?)");
  310. preparedStatement.setString(1, controller.firstName.getText());
  311. preparedStatement.setString(2, controller.lastName.getText());
  312. preparedStatement.setString(3, controller.emailAddress.getText());
  313. preparedStatement.setString(4, controller.street.getText());
  314. preparedStatement.setString(5, controller.number.getText());
  315. preparedStatement.setString(6, controller.additive.getText());
  316. preparedStatement.setString(7, controller.zipCode.getText());
  317. preparedStatement.setString(8, controller.city.getText());
  318. preparedStatement.executeUpdate();
  319. }
  320.  
  321. } catch (ClassNotFoundException | SQLException | HeadlessException e) {
  322. throw e;
  323. } finally {
  324. close();
  325. }
  326. }
  327.  
  328. public void searchAddress(String emailAddress) throws Exception {
  329. try {
  330. Class.forName("com.mysql.jdbc.Driver");
  331. // Setup the connection with the DB
  332. connect = DriverManager.getConnection("jdbc:mysql://localhost/dev?" + "user=root&password=fiat128slc");
  333. preparedStatement = connect.prepareStatement("SELECT * FROM dev.addresses WHERE email= '" + emailAddress + "'");
  334. resultSet = preparedStatement.executeQuery();
  335. if(resultSet.isBeforeFirst()) {
  336. while(resultSet.next()) {
  337. queryResultSet.add(resultSet.getString("firstname"));
  338. queryResultSet.add(resultSet.getString("lastname"));
  339. queryResultSet.add(resultSet.getString("email"));
  340. queryResultSet.add(resultSet.getString("street"));
  341. queryResultSet.add(resultSet.getString("housenumber"));
  342. queryResultSet.add(resultSet.getString("additve"));
  343. queryResultSet.add(resultSet.getString("zipcode"));
  344. queryResultSet.add(resultSet.getString("city"));
  345. }
  346. } else {
  347. JOptionPane.showMessageDialog(null, "Email doesn't exist", "InfoBox: " + "Error", JOptionPane.INFORMATION_MESSAGE);
  348. }
  349. } catch (ClassNotFoundException | SQLException | HeadlessException e) {
  350. throw e;
  351. } finally {
  352. close();
  353. }
  354. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!