API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 16th, 2016
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.87 KB | None | 0 0
raw download clone embed print report
  1. public void enterStaff() throws ClassNotFoundException, SQLException {
  2. try {
  3. Class.forName("com.mysql.jdbc.Driver");
  4. connect = DriverManager
  5. .getConnection("jdbc:mysql://localhost:3306/project?"
  6. + "user=root&password=virus");
  7. statement = connect.createStatement();
  8.  
  9. preparedStatement = connect
  10. .prepareStatement("SELECT count(*)FROM information_schema.tablesn"
  11. + "WHERE table_schema = 'project' AND table_name = 'staff'");
  12. rs = preparedStatement.executeQuery();
  13. rs.next();
  14. int chk = rs.getInt(1);
  15.  
  16. if (chk != 1) {
  17. preparedStatement = connect
  18. .prepareStatement("create table staff (staffname varchar(30) primary key);");
  19. preparedStatement.executeUpdate();
  20. }
  21.  
  22. preparedStatement = connect
  23. .prepareStatement("insert into staff values(?);");
  24. preparedStatement.setString(1, addSubName.getText());
  25.  
  26. preparedStatement.executeUpdate();
  27. } catch (ClassNotFoundException | SQLException e) {
  28. throw e;
  29. } finally {
  30. close2();
  31. }
  32.  
  33. }
  34.  
  35. private void close2() {
  36. try {
  37.  
  38. if (statement != null) {
  39. statement.close();
  40. }
  41.  
  42. if (connect != null) {
  43. connect.close();
  44. }
  45. } catch (SQLException e) {
  46.  
  47. }
  48. }
  49.  
  50. addSubName = new TextField();
  51. addSubName.setPromptText("Staff Name");
  52. addSubName.setPrefSize(200, 30);
  53.  
  54. final Button b2 = new Button("Add");
  55. b2.setFont(Font.font("Calibri", FontWeight.BOLD, 17));
  56. b2.setPrefSize(70, 30);
  57. b2.setStyle(" -fx-base: #0066ff;");
  58. b2.setTextFill(Color.BLACK);
  59. b2.setOnAction(new EventHandler<ActionEvent>() {
  60. @Override
  61. public void handle(ActionEvent e) {
  62.  
  63. data.add(new Staff(addSubName.getText()));
  64. addSubName.clear();
  65.  
  66. try {
  67. enterStaff();
  68. } catch (ClassNotFoundException ex) {
  69. Logger.getLogger(AddStaff.class.getName()).log(Level.SEVERE, null, ex);
  70. } catch (SQLException ex) {
  71. Logger.getLogger(AddStaff.class.getName()).log(Level.SEVERE, null, ex);
  72. }
  73. }
  74. });
  75.  
  76. com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '' for key 'PRIMARY'
  77. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  78. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  79. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  80. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  81. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  82. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  83. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  84. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
  85. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
  86. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
  87. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
  88. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
  89. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
  90. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
  91. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
  92. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
  93. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
  94. at addstaff.AddStaff.enterStaff(AddStaff.java:149)
  95. at addstaff.AddStaff$2.handle(AddStaff.java:100)
  96. at addstaff.AddStaff$2.handle(AddStaff.java:92)
  97. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:69)
  98. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:217)
  99. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:170)
  100. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:38)
  101. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:37)
  102. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)
  103. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:35)
  104. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)
  105. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:53)
  106. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:28)
  107. at javafx.event.Event.fireEvent(Event.java:171)
  108. at javafx.scene.Node.fireEvent(Node.java:6867)
  109. at javafx.scene.control.Button.fire(Button.java:179)
  110. at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:193)
  111. at com.sun.javafx.scene.control.skin.SkinBase$4.handle(SkinBase.java:336)
  112. at com.sun.javafx.scene.control.skin.SkinBase$4.handle(SkinBase.java:329)
  113. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:64)
  114. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:217)
  115. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:170)
  116. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:38)
  117. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:37)
  118. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)
  119. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:35)
  120. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)
  121. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:35)
  122. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:92)
  123. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:53)
  124. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:33)
  125. at javafx.event.Event.fireEvent(Event.java:171)
  126. at javafx.scene.Scene$MouseHandler.process(Scene.java:3311)
  127. at javafx.scene.Scene$MouseHandler.process(Scene.java:3151)
  128. at javafx.scene.Scene$MouseHandler.access$1900(Scene.java:3106)
  129. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1563)
  130. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2248)
  131. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:250)
  132. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:173)
  133. at java.security.AccessController.doPrivileged(Native Method)
  134. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:292)
  135. at com.sun.glass.ui.View.handleMouseEvent(View.java:530)
  136. at com.sun.glass.ui.View.notifyMouse(View.java:924)
  137. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  138. at com.sun.glass.ui.win.WinApplication.access$100(WinApplication.java:17)
  139. at com.sun.glass.ui.win.WinApplication$3$1.run(WinApplication.java:67)
  140. at java.lang.Thread.run(Thread.java:744)
  141.  
  142. prepareStatement("create table staff (staffname varchar(30) primary key);");
  143.  
  144. preparedStatement = connect.prepareStatement("insert into staff values(?);");
  145.  
  146. prepareStatement("create table staff (staffname varchar(30) primary key)");
  147.  
  148. preparedStatement = connect.prepareStatement("insert into staff values(?)");
  149.  
  150. insert into staff values(?)
  151.  
  152. INSERT INTO table_name
  153. VALUES (value1,value2,value3,...);
  154.  
  155. statement = connect.createStatement();
  156. preparedStatement = connect
  157. .prepareStatement("SELECT count(*)FROM information_schema.tablesn"
  158. + "WHERE table_schema = 'project' AND table_name = 'staff'");
  159. rs = preparedStatement.executeQuery();
  160. rs.next();
  161.  
  162. Class.forName(driverName).newInstance();
  163. con=DriverManager.getConnection(connectionUrl+dbName,user,password);
  164. st = con.createStatement();
  165. String sql="SELECT * FROM employees";
  166. rs=st.executeQuery(sql);
  167.  
  168. string sql=....sql query...;
  169. statement.executeQuery(sql)
  170.  
  171. public class User
  172. {
  173. private String empname;
  174. public String getEmpName()
  175. {
  176. return empname;
  177. }
  178. public void setEmpName(String empname)
  179. {
  180. this.empname=empname;
  181. }
  182.  
  183. public void addUser(User user)
  184. {
  185. try
  186. {
  187. PreparedStatement ps;
  188. ps=connection.prepareStatement("INSERT INTO employee (empname,empaddress,depname) VALUES (?,?,?)");
  189. ps.setString(1, user.getEmpName());
  190. ps.setString(2, user.getEmpAddress());
  191. ps.setString(3, user.getDepName());
  192. ps.executeUpdate();
  193. }
  194. catch(Exception e)
  195. {
  196. System.out.println(e);
  197. }
  198. }
  199.  
  200. INSERT INTO users ('user_id', 'name', 'age') VALUES (112233, 'Tom', 18);
  201. INSERT INTO users ('user_id', 'name', 'age') VALUES (112233, 'Barry', 21);
  202.  
  203. INSERT INTO social_link ('user_id', 'social_id') VALUES (112233, 59874) ON DUPLICATE KEY UPDATE social_id=575123;
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!