API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 16th, 2017
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.98 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this template, choose Tools | Templates
  3. * and open the template in the editor.
  4. */
  5.  
  6. /*
  7. * GuiInsert.java
  8. *
  9. * Created on Sep 18, 2010, 12:35:28 AM
  10. */
  11.  
  12.  
  13. package myjava;
  14. import java.sql.*;
  15.  
  16.  
  17.  
  18. /**
  19. *
  20. * @author 3csd-21
  21. */
  22. public class GuiInsert extends javax.swing.JFrame {
  23.  
  24. private Connection conn;
  25.  
  26. /** Creates new form GuiInsert */
  27. public GuiInsert()
  28.  
  29. {
  30. initComponents();
  31.  
  32. try
  33. {
  34. Class.forName("com.mysql.jdbc.Driver");
  35. conn = DriverManager.getConnection ("jdbc:mysql://localhost/my3csd","root","12345");
  36. statusTextArea.setText("Connection SUCCESSFUL!");
  37. }
  38. catch (Exception e)
  39. {
  40. statusTextArea.setText( e.getMessage());
  41. }
  42. }
  43.  
  44.  
  45. /** This method is called from within the constructor to
  46. * initialize the form.
  47. * WARNING: Do NOT modify this code. The content of this method is
  48. * always regenerated by the Form Editor.
  49. */
  50.  
  51. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  52. private void initComponents() {
  53.  
  54. jPanel1 = new javax.swing.JPanel();
  55. jLabel1 = new javax.swing.JLabel();
  56. jLabel2 = new javax.swing.JLabel();
  57. jLabel3 = new javax.swing.JLabel();
  58. jLabel4 = new javax.swing.JLabel();
  59. jLabel5 = new javax.swing.JLabel();
  60. sectionCombo = new javax.swing.JComboBox();
  61. tuitionField = new javax.swing.JTextField();
  62. birthdayField = new javax.swing.JTextField();
  63. studnoField = new javax.swing.JTextField();
  64. nameField = new javax.swing.JTextField();
  65. jPanel2 = new javax.swing.JPanel();
  66. saveButton = new javax.swing.JButton();
  67. jPanel3 = new javax.swing.JPanel();
  68. jScrollPane1 = new javax.swing.JScrollPane();
  69. statusTextArea = new javax.swing.JTextArea();
  70.  
  71. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  72. setTitle("Janine Anne Myrtle R. Go");
  73. addWindowListener(new java.awt.event.WindowAdapter() {
  74. public void windowClosing(java.awt.event.WindowEvent evt) {
  75. formWindowClosing(evt);
  76. }
  77. });
  78.  
  79. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Data", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(0, 0, 0))); // NOI18N
  80.  
  81. jLabel1.setText("Student Number");
  82.  
  83. jLabel2.setText("Name");
  84.  
  85. jLabel3.setText("Section");
  86.  
  87. jLabel4.setText("Tuition");
  88.  
  89. jLabel5.setText("Birthday (YYYY-MM-DD)");
  90.  
  91. sectionCombo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "-", "3CSA", "3CSB", "3CSC", "3CSD", "3ITA", "3ITB", "3ITC", "3ITD", "3ISA", "3ISB", "3ISC", "3ISD" }));
  92.  
  93. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  94. jPanel1.setLayout(jPanel1Layout);
  95. jPanel1Layout.setHorizontalGroup(
  96. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  97. .addGroup(jPanel1Layout.createSequentialGroup()
  98. .addGap(25, 25, 25)
  99. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  100. .addComponent(jLabel1)
  101. .addComponent(jLabel2)
  102. .addComponent(jLabel5)
  103. .addComponent(jLabel4)
  104. .addComponent(jLabel3))
  105. .addGap(56, 56, 56)
  106. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  107. .addComponent(tuitionField, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 203, Short.MAX_VALUE)
  108. .addComponent(sectionCombo, 0, 203, Short.MAX_VALUE)
  109. .addComponent(birthdayField, javax.swing.GroupLayout.DEFAULT_SIZE, 203, Short.MAX_VALUE)
  110. .addComponent(studnoField, javax.swing.GroupLayout.DEFAULT_SIZE, 203, Short.MAX_VALUE)
  111. .addComponent(nameField, javax.swing.GroupLayout.DEFAULT_SIZE, 203, Short.MAX_VALUE))
  112. .addContainerGap())
  113. );
  114. jPanel1Layout.setVerticalGroup(
  115. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  116. .addGroup(jPanel1Layout.createSequentialGroup()
  117. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  118. .addComponent(jLabel1)
  119. .addComponent(studnoField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  120. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  121. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  122. .addComponent(jLabel2)
  123. .addComponent(nameField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  124. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  125. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  126. .addComponent(sectionCombo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  127. .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE))
  128. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  129. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  130. .addComponent(tuitionField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  131. .addComponent(jLabel4))
  132. .addGap(12, 12, 12)
  133. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  134. .addComponent(birthdayField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  135. .addComponent(jLabel5))
  136. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  137. );
  138.  
  139. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Save", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(0, 0, 0))); // NOI18N
  140.  
  141. saveButton.setText("Insert Record");
  142. saveButton.addActionListener(new java.awt.event.ActionListener() {
  143. public void actionPerformed(java.awt.event.ActionEvent evt) {
  144. saveButtonActionPerformed(evt);
  145. }
  146. });
  147.  
  148. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  149. jPanel2.setLayout(jPanel2Layout);
  150. jPanel2Layout.setHorizontalGroup(
  151. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  152. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
  153. .addContainerGap(190, Short.MAX_VALUE)
  154. .addComponent(saveButton, javax.swing.GroupLayout.PREFERRED_SIZE, 207, javax.swing.GroupLayout.PREFERRED_SIZE)
  155. .addContainerGap())
  156. );
  157. jPanel2Layout.setVerticalGroup(
  158. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  159. .addComponent(saveButton)
  160. );
  161.  
  162. jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Insert Status", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(0, 0, 0))); // NOI18N
  163.  
  164. statusTextArea.setColumns(20);
  165. statusTextArea.setLineWrap(true);
  166. statusTextArea.setRows(5);
  167. jScrollPane1.setViewportView(statusTextArea);
  168.  
  169. javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
  170. jPanel3.setLayout(jPanel3Layout);
  171. jPanel3Layout.setHorizontalGroup(
  172. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  173. .addGroup(jPanel3Layout.createSequentialGroup()
  174. .addContainerGap()
  175. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 387, Short.MAX_VALUE)
  176. .addContainerGap())
  177. );
  178. jPanel3Layout.setVerticalGroup(
  179. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  180. .addGroup(jPanel3Layout.createSequentialGroup()
  181. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  182. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  183. );
  184.  
  185. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  186. getContentPane().setLayout(layout);
  187. layout.setHorizontalGroup(
  188. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  189. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  190. .addContainerGap()
  191. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  192. .addComponent(jPanel3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  193. .addComponent(jPanel2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  194. .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  195. .addContainerGap())
  196. );
  197. layout.setVerticalGroup(
  198. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  199. .addGroup(layout.createSequentialGroup()
  200. .addContainerGap()
  201. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  202. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  203. .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  204. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  205. .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  206. .addContainerGap())
  207. );
  208.  
  209. java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
  210. setBounds((screenSize.width-451)/2, (screenSize.height-415)/2, 451, 415);
  211. }// </editor-fold>
  212.  
  213. private void formWindowClosing(java.awt.event.WindowEvent evt) {
  214. // TODO add your handling code here:
  215. try
  216. {
  217. conn.close();
  218. }
  219. catch (Exception e)
  220. {};
  221. }
  222.  
  223. private void saveButtonActionPerformed(java.awt.event.ActionEvent evt) {
  224. // TODO add your handling code here:
  225. String studnof = studnoField.getText();
  226. String namef = nameField.getText();
  227. String sectionf = (String) sectionCombo.getSelectedItem();
  228. String tuitionf = tuitionField.getText();
  229. String birthdayf = birthdayField.getText();
  230.  
  231. try{
  232.  
  233. String SQL = "INSERT INTO students VALUES("
  234. + "'" + studnof + "'" + ","
  235. + "'" + namef + "'" + ","
  236. + "'" + sectionf + "'" + ","
  237. + tuitionf + ","
  238. + "'" + birthdayf + "'"
  239. + ")";
  240.  
  241. PreparedStatement stmt = conn.prepareStatement(SQL);
  242. stmt.executeUpdate();
  243.  
  244. getContentPane().removeAll(); //removes all the components
  245. initComponents(); //display back the components
  246.  
  247. statusTextArea.setText("Insert Successful!");
  248. }
  249. catch(Exception e)
  250. {
  251. statusTextArea.setText( e.getMessage() );
  252. }
  253. }
  254.  
  255. /**
  256. * @param args the command line arguments
  257. */
  258.  
  259. @SuppressWarnings("Unchecked")
  260.  
  261.  
  262. public static void main(String args[]) {
  263. java.awt.EventQueue.invokeLater(new Runnable() {
  264. public void run() {
  265. new GuiInsert().setVisible(true);
  266. }
  267. });
  268. }
  269.  
  270. // Variables declaration - do not modify
  271. private javax.swing.JTextField birthdayField;
  272. private javax.swing.JLabel jLabel1;
  273. private javax.swing.JLabel jLabel2;
  274. private javax.swing.JLabel jLabel3;
  275. private javax.swing.JLabel jLabel4;
  276. private javax.swing.JLabel jLabel5;
  277. private javax.swing.JPanel jPanel1;
  278. private javax.swing.JPanel jPanel2;
  279. private javax.swing.JPanel jPanel3;
  280. private javax.swing.JScrollPane jScrollPane1;
  281. private javax.swing.JTextField nameField;
  282. private javax.swing.JButton saveButton;
  283. private javax.swing.JComboBox sectionCombo;
  284. private javax.swing.JTextArea statusTextArea;
  285. private javax.swing.JTextField studnoField;
  286. private javax.swing.JTextField tuitionField;
  287. // End of variables declaration
  288.  
  289. }
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!