API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 28th, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.01 KB | None | 0 0
raw download clone embed print report
  1. /*
  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.
  5. */
  6. package dbconnect;
  7.  
  8. import java.sql.Connection;
  9. import java.sql.DriverManager;
  10. import java.sql.PreparedStatement;
  11. import java.sql.ResultSet;
  12. import java.sql.Statement;
  13.  
  14.  
  15.  
  16. /**
  17. *
  18. * @author student
  19. */
  20. public class Frame extends javax.swing.JFrame {
  21.  
  22. /**
  23. * Creates new form Frame
  24. */
  25.  
  26. Connection con;
  27. ResultSet rs;
  28. Statement st;
  29. PreparedStatement pst;
  30. public Frame() {
  31. initComponents();
  32.  
  33. try
  34. {
  35. Class.forName("com.mysql.jdbc.Driver");
  36. con = DriverManager.getConnection("jdbc:mysql://localhost:3306/std","root","");
  37. st = con.createStatement();
  38. }
  39. catch(Exception ex)
  40. {
  41. System.out.println(" error "+ex);
  42. }
  43. }
  44.  
  45. /**
  46. * This method is called from within the constructor to initialize the form.
  47. * WARNING: Do NOT modify this code. The content of this method is always
  48. * regenerated by the Form Editor.
  49. */
  50. @SuppressWarnings("unchecked")
  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. jTextField1 = new javax.swing.JTextField();
  57. jLabel2 = new javax.swing.JLabel();
  58. jTextField2 = new javax.swing.JTextField();
  59. jLabel3 = new javax.swing.JLabel();
  60. jTextField3 = new javax.swing.JTextField();
  61. jLabel4 = new javax.swing.JLabel();
  62. jTextField4 = new javax.swing.JTextField();
  63. jScrollPane1 = new javax.swing.JScrollPane();
  64. jTextArea1 = new javax.swing.JTextArea();
  65. jButton1 = new javax.swing.JButton();
  66. jButton2 = new javax.swing.JButton();
  67. jButton3 = new javax.swing.JButton();
  68. jButton4 = new javax.swing.JButton();
  69.  
  70. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  71.  
  72. jLabel1.setText("name");
  73.  
  74. jLabel2.setText("id");
  75.  
  76. jLabel3.setText("cgpa");
  77.  
  78. jLabel4.setText("major");
  79.  
  80. jTextArea1.setColumns(20);
  81. jTextArea1.setRows(5);
  82. jScrollPane1.setViewportView(jTextArea1);
  83.  
  84. jButton1.setText("save");
  85. jButton1.addActionListener(new java.awt.event.ActionListener() {
  86. public void actionPerformed(java.awt.event.ActionEvent evt) {
  87. jButton1ActionPerformed(evt);
  88. }
  89. });
  90.  
  91. jButton2.setText("delete");
  92.  
  93. jButton3.setText("load/refresh");
  94. jButton3.addActionListener(new java.awt.event.ActionListener() {
  95. public void actionPerformed(java.awt.event.ActionEvent evt) {
  96. jButton3ActionPerformed(evt);
  97. }
  98. });
  99.  
  100. jButton4.setText("jButton4");
  101.  
  102. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  103. jPanel1.setLayout(jPanel1Layout);
  104. jPanel1Layout.setHorizontalGroup(
  105. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  106. .addGroup(jPanel1Layout.createSequentialGroup()
  107. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  108. .addGroup(jPanel1Layout.createSequentialGroup()
  109. .addGap(74, 74, 74)
  110. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  111. .addComponent(jLabel1)
  112. .addComponent(jLabel2)
  113. .addComponent(jLabel3)
  114. .addComponent(jLabel4))
  115. .addGap(42, 42, 42)
  116. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  117. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 422, javax.swing.GroupLayout.PREFERRED_SIZE)
  118. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  119. .addComponent(jTextField4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 118, Short.MAX_VALUE)
  120. .addComponent(jTextField3, javax.swing.GroupLayout.Alignment.LEADING)
  121. .addComponent(jTextField2, javax.swing.GroupLayout.Alignment.LEADING)
  122. .addComponent(jTextField1, javax.swing.GroupLayout.Alignment.LEADING))))
  123. .addGroup(jPanel1Layout.createSequentialGroup()
  124. .addGap(46, 46, 46)
  125. .addComponent(jButton1)
  126. .addGap(51, 51, 51)
  127. .addComponent(jButton2)
  128. .addGap(77, 77, 77)
  129. .addComponent(jButton4)
  130. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 109, Short.MAX_VALUE)
  131. .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)))
  132. .addGap(26, 26, 26))
  133. );
  134. jPanel1Layout.setVerticalGroup(
  135. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  136. .addGroup(jPanel1Layout.createSequentialGroup()
  137. .addGap(41, 41, 41)
  138. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  139. .addComponent(jLabel1)
  140. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  141. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  142. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  143. .addComponent(jLabel2)
  144. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  145. .addGap(18, 18, 18)
  146. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  147. .addComponent(jLabel3)
  148. .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  149. .addGap(23, 23, 23)
  150. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  151. .addComponent(jLabel4)
  152. .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  153. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 28, Short.MAX_VALUE)
  154. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  155. .addComponent(jButton1)
  156. .addComponent(jButton2)
  157. .addComponent(jButton3)
  158. .addComponent(jButton4))
  159. .addGap(42, 42, 42)
  160. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 205, javax.swing.GroupLayout.PREFERRED_SIZE))
  161. );
  162.  
  163. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  164. getContentPane().setLayout(layout);
  165. layout.setHorizontalGroup(
  166. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  167. .addGroup(layout.createSequentialGroup()
  168. .addGap(52, 52, 52)
  169. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  170. .addContainerGap(73, Short.MAX_VALUE))
  171. );
  172. layout.setVerticalGroup(
  173. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  174. .addGroup(layout.createSequentialGroup()
  175. .addGap(38, 38, 38)
  176. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  177. .addContainerGap(49, Short.MAX_VALUE))
  178. );
  179.  
  180. pack();
  181. }// </editor-fold>
  182.  
  183. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  184. // TODO add your handling code here:
  185. load();
  186. }
  187.  
  188. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  189. // TODO add your handling code here:
  190. add();
  191. }
  192.  
  193. /**
  194. * @param args the command line arguments
  195. */
  196. public static void main(String args[]) {
  197. /* Set the Nimbus look and feel */
  198. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  199. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  200. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  201. */
  202. try {
  203. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  204. if ("Nimbus".equals(info.getName())) {
  205. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  206. break;
  207. }
  208. }
  209. } catch (ClassNotFoundException ex) {
  210. java.util.logging.Logger.getLogger(Frame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  211. } catch (InstantiationException ex) {
  212. java.util.logging.Logger.getLogger(Frame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  213. } catch (IllegalAccessException ex) {
  214. java.util.logging.Logger.getLogger(Frame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  215. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  216. java.util.logging.Logger.getLogger(Frame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  217. }
  218. //</editor-fold>
  219.  
  220. /* Create and display the form */
  221. java.awt.EventQueue.invokeLater(new Runnable() {
  222. public void run() {
  223. new Frame().setVisible(true);
  224. }
  225. });
  226. }
  227. public void load()
  228. {
  229. try
  230. {
  231. String q = "select * from student";
  232. rs =st.executeQuery(q);
  233. while(rs.next())
  234. {
  235. jTextArea1.setText(jTextArea1.getText()+rs.getString("name")+"\t"+rs.getString("id")+"\t"+rs.getString("cgpa")+"\t"+rs.getString("major")+"\n\n");
  236. }
  237.  
  238. }
  239. catch(Exception e)
  240. {
  241. System.out.println("error2"+e);
  242. }
  243.  
  244. }
  245.  
  246. public void add()
  247. {
  248. try
  249. {
  250. String q = "insert into student(name,id,cgpa,major) values(?,?,?,?)";
  251. pst = con.prepareStatement(q);
  252. pst.setString(1,jTextField1.getText());
  253. pst.setString(2,jTextField2.getText());
  254. pst.setString(3,jTextField3.getText());
  255. pst.setString(4,jTextField4.getText());
  256. pst.executeUpdate();
  257.  
  258. }
  259. catch(Exception e)
  260. {
  261. System.out.println("error3"+e);
  262. }
  263. }
  264.  
  265. public void delet()
  266. {
  267. try
  268. {
  269. String q = "select * from student";
  270. rs =st.executeQuery(q);
  271. while(rs.next())
  272. {
  273. jTextArea1.setText(jTextArea1.getText()+rs.getString("name")+"\t"+rs.getString("id")+"\t"+rs.getString("cgpa")+"\t"+rs.getString("major")+"\n\n");
  274. }
  275.  
  276. }
  277. catch(Exception e)
  278. {
  279. System.out.println("error2"+e);
  280. }
  281. }
  282.  
  283. // Variables declaration - do not modify
  284. private javax.swing.JButton jButton1;
  285. private javax.swing.JButton jButton2;
  286. private javax.swing.JButton jButton3;
  287. private javax.swing.JButton jButton4;
  288. private javax.swing.JLabel jLabel1;
  289. private javax.swing.JLabel jLabel2;
  290. private javax.swing.JLabel jLabel3;
  291. private javax.swing.JLabel jLabel4;
  292. private javax.swing.JPanel jPanel1;
  293. private javax.swing.JScrollPane jScrollPane1;
  294. private javax.swing.JTextArea jTextArea1;
  295. private javax.swing.JTextField jTextField1;
  296. private javax.swing.JTextField jTextField2;
  297. private javax.swing.JTextField jTextField3;
  298. private javax.swing.JTextField jTextField4;
  299. // End of variables declaration
  300. }
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!