API tools faq
paste
Advertisement
Guest User

Java

a guest
Sep 3rd, 2016
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.54 KB | None | 0 0
raw download clone embed print report
  1. ////////// CODE //////////
  2. import java.sql.Connection;
  3.  
  4. import java.sql.DriverManager;
  5.  
  6. import java.sql.Statement;
  7.  
  8.  
  9.  
  10. import javax.swing.JOptionPane;
  11.  
  12.  
  13.  
  14. public class db extends javax.swing.JFrame {
  15.  
  16.  
  17. static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
  18.  
  19. static final String DB_URL = "jdbc:mysql://localhost:3306/userdb";
  20.  
  21. static final String USER="root";
  22.  
  23. static final String PASS="";
  24.  
  25. Connection conn = null;
  26.  
  27. Statement stmt = null;
  28.  
  29.  
  30.  
  31. /**
  32.  
  33. * Creates new form NewJFrame1
  34.  
  35. */
  36.  
  37. public db() {
  38.  
  39. initComponents();
  40.  
  41. }
  42.  
  43.  
  44.  
  45. /**
  46.  
  47. * This method is called from within the constructor to initialize the form.
  48.  
  49. * WARNING: Do NOT modify this code. The content of this method is always
  50.  
  51. * regenerated by the Form Editor.
  52.  
  53. */
  54.  
  55. @SuppressWarnings("unchecked")
  56.  
  57. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  58.  
  59. private void initComponents() {
  60.  
  61.  
  62.  
  63. jTextField1 = new javax.swing.JTextField();
  64.  
  65. jTextField2 = new javax.swing.JTextField();
  66.  
  67. jTextField3 = new javax.swing.JTextField();
  68.  
  69. jTextField4 = new javax.swing.JTextField();
  70.  
  71. jTextField5 = new javax.swing.JTextField();
  72.  
  73. jLabel1 = new javax.swing.JLabel();
  74.  
  75. jLabel2 = new javax.swing.JLabel();
  76.  
  77. jLabel3 = new javax.swing.JLabel();
  78.  
  79. jLabel4 = new javax.swing.JLabel();
  80.  
  81. jLabel5 = new javax.swing.JLabel();
  82.  
  83. jTextField6 = new javax.swing.JTextField();
  84.  
  85. jLabel6 = new javax.swing.JLabel();
  86.  
  87. jTextField7 = new javax.swing.JTextField();
  88.  
  89. jLabel7 = new javax.swing.JLabel();
  90.  
  91. jButton1 = new javax.swing.JButton();
  92.  
  93.  
  94.  
  95. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  96.  
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103. jLabel1.setText("Name");
  104.  
  105.  
  106.  
  107. jLabel2.setText("Id");
  108.  
  109.  
  110.  
  111. jLabel3.setText("No. of clients");
  112.  
  113.  
  114.  
  115. jLabel4.setText("Name of client");
  116.  
  117.  
  118.  
  119. jLabel5.setText("office");
  120.  
  121.  
  122.  
  123. jLabel6.setText("assistant");
  124.  
  125.  
  126.  
  127. jLabel7.setText("properties");
  128.  
  129.  
  130.  
  131. jButton1.setText("Submit");
  132.  
  133. jButton1.addActionListener(new java.awt.event.ActionListener() {
  134.  
  135. public void actionPerformed(java.awt.event.ActionEvent evt) {
  136.  
  137. jButton1ActionPerformed(evt);
  138.  
  139. }
  140.  
  141. });
  142.  
  143.  
  144.  
  145. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  146.  
  147. getContentPane().setLayout(layout);
  148.  
  149. layout.setHorizontalGroup(
  150.  
  151. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  152.  
  153. .addGroup(layout.createSequentialGroup()
  154.  
  155. .addGap(43, 43, 43)
  156.  
  157. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  158.  
  159. .addComponent(jLabel1)
  160.  
  161. .addComponent(jLabel2)
  162.  
  163. .addComponent(jLabel3)
  164.  
  165. .addComponent(jLabel4)
  166.  
  167. .addComponent(jLabel5)
  168.  
  169. .addComponent(jLabel6)
  170.  
  171. .addComponent(jLabel7))
  172.  
  173. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  174.  
  175. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  176.  
  177. .addGap(50, 50, 50)
  178.  
  179. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  180.  
  181. .addComponent(jTextField5, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
  182.  
  183. .addComponent(jTextField6, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
  184.  
  185. .addComponent(jTextField7, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)))
  186.  
  187. .addGroup(layout.createSequentialGroup()
  188.  
  189. .addGap(44, 44, 44)
  190.  
  191. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  192.  
  193. .addComponent(jButton1)
  194.  
  195. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  196.  
  197. .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 111, Short.MAX_VALUE)
  198.  
  199. .addComponent(jTextField2)
  200.  
  201. .addComponent(jTextField3)
  202.  
  203. .addComponent(jTextField4)))))
  204.  
  205. .addContainerGap(110, Short.MAX_VALUE))
  206.  
  207. );
  208.  
  209. layout.setVerticalGroup(
  210.  
  211. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  212.  
  213. .addGroup(layout.createSequentialGroup()
  214.  
  215. .addGap(16, 16, 16)
  216.  
  217. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  218.  
  219. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  220.  
  221. .addComponent(jLabel1))
  222.  
  223. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  224.  
  225. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  226.  
  227. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  228.  
  229. .addComponent(jLabel2))
  230.  
  231. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  232.  
  233. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  234.  
  235. .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  236.  
  237. .addComponent(jLabel3))
  238.  
  239. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  240.  
  241. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  242.  
  243. .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  244.  
  245. .addComponent(jLabel4))
  246.  
  247. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  248.  
  249. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  250.  
  251. .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  252.  
  253. .addComponent(jLabel5))
  254.  
  255. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  256.  
  257. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  258.  
  259. .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  260.  
  261. .addComponent(jLabel6))
  262.  
  263. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  264.  
  265. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  266.  
  267. .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  268.  
  269. .addComponent(jLabel7))
  270.  
  271. .addGap(18, 18, 18)
  272.  
  273. .addComponent(jButton1)
  274.  
  275. .addContainerGap(19, Short.MAX_VALUE))
  276.  
  277. );
  278.  
  279.  
  280.  
  281. pack();
  282.  
  283. }// </editor-fold>
  284.  
  285.  
  286.  
  287.  
  288.  
  289.  
  290.  
  291. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  292.  
  293. try
  294.  
  295. {
  296.  
  297. Class.forName("com.mysql.jdbc.Driver");
  298.  
  299. conn=DriverManager.getConnection(DB_URL,USER,PASS);
  300.  
  301. stmt = conn.createStatement();
  302.  
  303. stmt.executeUpdate("insert into agent(name,id) values('"+jTextField1.getText()+"',"+jTextField2.getText()+")");
  304. stmt.executeUpdate("insert into office(address) values('"+jTextField5.getText()+"')");
  305. stmt.executeUpdate("insert into assistant(name) values('"+jTextField6.getText()+"')");
  306. stmt.executeUpdate("insert into client(name) values('"+jTextField4.getText()+"')");
  307. JOptionPane.showMessageDialog(null,"Inserted Successfully!");
  308.  
  309. }
  310.  
  311. catch(Exception e)
  312.  
  313. {
  314.  
  315. e.printStackTrace();
  316.  
  317. }
  318.  
  319. }
  320.  
  321.  
  322.  
  323. /**
  324.  
  325. * @param args the command line arguments
  326.  
  327. */
  328.  
  329. public static void main(String args[]) {
  330.  
  331.  
  332.  
  333. try {
  334.  
  335. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  336.  
  337. if ("Nimbus".equals(info.getName())) {
  338.  
  339. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  340.  
  341. break;
  342.  
  343. }
  344.  
  345. }
  346.  
  347. } catch (ClassNotFoundException ex) {
  348.  
  349. java.util.logging.Logger.getLogger(db.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  350.  
  351. } catch (InstantiationException ex) {
  352.  
  353. java.util.logging.Logger.getLogger(db.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  354.  
  355. } catch (IllegalAccessException ex) {
  356.  
  357. java.util.logging.Logger.getLogger(db.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  358.  
  359. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  360.  
  361. java.util.logging.Logger.getLogger(db.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  362.  
  363. }
  364.  
  365. //</editor-fold>
  366.  
  367.  
  368.  
  369. /* Create and display the form */
  370.  
  371. java.awt.EventQueue.invokeLater(new Runnable() {
  372.  
  373. public void run() {
  374.  
  375. new db().setVisible(true);
  376.  
  377. }
  378.  
  379. });
  380.  
  381. }
  382.  
  383.  
  384.  
  385. // Variables declaration - do not modify
  386.  
  387. private javax.swing.JButton jButton1;
  388.  
  389. private javax.swing.JLabel jLabel1;
  390.  
  391. private javax.swing.JLabel jLabel2;
  392.  
  393. private javax.swing.JLabel jLabel3;
  394.  
  395. private javax.swing.JLabel jLabel4;
  396.  
  397. private javax.swing.JLabel jLabel5;
  398.  
  399. private javax.swing.JLabel jLabel6;
  400.  
  401. private javax.swing.JLabel jLabel7;
  402.  
  403. private javax.swing.JTextField jTextField1;
  404.  
  405. private javax.swing.JTextField jTextField2;
  406.  
  407. private javax.swing.JTextField jTextField3;
  408.  
  409. private javax.swing.JTextField jTextField4;
  410.  
  411. private javax.swing.JTextField jTextField5;
  412.  
  413. private javax.swing.JTextField jTextField6;
  414.  
  415. private javax.swing.JTextField jTextField7;
  416.  
  417. // End of variables declaration
  418.  
  419. }
  420. ///////////// CREATE DB TABLES ////////
  421.  
  422.  
  423. CREATE TABLE office (
  424. id MEDIUMINT NOT NULL AUTO_INCREMENT,
  425. address CHAR(30) NOT NULL,
  426. PRIMARY KEY (id)
  427. );
  428. create table client (
  429. id MEDIUMINT NOT NULL AUTO_INCREMENT,
  430. name char(20),
  431. PRIMARY KEY (id)
  432. );
  433. create table assistant (
  434. id MEDIUMINT NOT NULL AUTO_INCREMENT,
  435. name char(20),
  436. PRIMARY KEY (id)
  437. );
  438.  
  439.  
  440. create table agent (name varchar2(10),id int);
  441. create database userdb;
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!