API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 30th, 2017
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.59 KB | None | 0 0
raw download clone embed print report
  1. import java.sql.*;
  2. import java.util.logging.Level;
  3. import java.util.logging.Logger;
  4. import javax.swing.DefaultListModel;
  5. import javax.swing.JOptionPane;
  6.  
  7.  
  8. public class Secundario extends javax.swing.JFrame {
  9. DefaultListModel lm;
  10. DefaultListModel lm1;
  11. static Connection conexion1=null;
  12. static Statement s1=null;
  13. static ResultSet rs1=null;
  14.  
  15.  
  16. public Secundario() {
  17. initComponents();
  18. lm=new DefaultListModel ();
  19. lm1=new DefaultListModel ();
  20. panel1.setModel(lm);
  21. panel2.setModel(lm1);
  22. cargaLista();
  23. conectaBD1();
  24. }
  25. void conectaBD1(){
  26. try {
  27. // Cargar el driver
  28. Class.forName("com.mysql.jdbc.Driver");
  29.  
  30. // Se obtiene una conexión con la base de datos.
  31. conexion1 = DriverManager.getConnection
  32. ("jdbc:mysql://localhost/tienda", "ivan", "alumno");
  33. s1= conexion1.createStatement(ResultSet.TYPE_FORWARD_ONLY,
  34. ResultSet.CONCUR_UPDATABLE);
  35. rs1=s1.executeQuery("select * from carrito");
  36. //Lo situo en el primer registro
  37. rs1.next();
  38.  
  39. } catch (Exception e){
  40. JOptionPane.showMessageDialog(null, e.getMessage());
  41. }
  42. }
  43.  
  44. void cargaLista (){
  45. lm.clear();
  46. try {
  47. Principal.rs.beforeFirst();
  48. while(Principal.rs.next()){
  49. lm.addElement(Principal.rs.getString("Nombre")
  50. + " "+Principal.rs.getString("Precio")+
  51. " "+ Principal.rs.getString("Stock"));
  52. }
  53. Principal.rs.first();
  54. }catch (Exception e){
  55. JOptionPane.showMessageDialog(this, e.getMessage());
  56. }
  57. }
  58. void listaderecha(){
  59. lm1.clear();
  60. try{
  61. rs1.beforeFirst();
  62. while(rs1.next()){
  63. lm1.addElement(" "+rs1.getString("nombre").toString()+" "+
  64. String.valueOf(rs1.getInt("precio"))+"€ "+
  65. String.valueOf(rs1.getInt("cantidad"))+" Unidades");
  66. }
  67. rs1.first();
  68. }catch(SQLException e){
  69. JOptionPane.showMessageDialog(this, e.getMessage());
  70. }
  71. }
  72. @SuppressWarnings("unchecked")
  73. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  74. private void initComponents() {
  75.  
  76. jLabel1 = new javax.swing.JLabel();
  77. bComprar = new javax.swing.JButton();
  78. Bdevolver = new javax.swing.JButton();
  79. jLabel2 = new javax.swing.JLabel();
  80. jTextField1 = new javax.swing.JTextField();
  81. jLabel3 = new javax.swing.JLabel();
  82. jLabel4 = new javax.swing.JLabel();
  83. jLabel5 = new javax.swing.JLabel();
  84. jLabel6 = new javax.swing.JLabel();
  85. jLabel7 = new javax.swing.JLabel();
  86. jLabel8 = new javax.swing.JLabel();
  87. jLabel9 = new javax.swing.JLabel();
  88. jScrollPane1 = new javax.swing.JScrollPane();
  89. panel1 = new javax.swing.JList<>();
  90. jScrollPane2 = new javax.swing.JScrollPane();
  91. panel2 = new javax.swing.JList<>();
  92.  
  93. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  94.  
  95. jLabel1.setText("DISPONIBLES");
  96.  
  97. bComprar.setText("C O M P R A R -->");
  98. bComprar.addActionListener(new java.awt.event.ActionListener() {
  99. public void actionPerformed(java.awt.event.ActionEvent evt) {
  100. bComprarActionPerformed(evt);
  101. }
  102. });
  103.  
  104. Bdevolver.setText("<-- D E V O L V E R");
  105. Bdevolver.addMouseListener(new java.awt.event.MouseAdapter() {
  106. public void mouseClicked(java.awt.event.MouseEvent evt) {
  107. BdevolverMouseClicked(evt);
  108. }
  109. });
  110.  
  111. jLabel2.setText("TOTAL");
  112.  
  113. jLabel3.setText("CARRITO DE LA COMPRA");
  114.  
  115. jLabel4.setText("Nombre");
  116.  
  117. jLabel5.setText("Precio");
  118.  
  119. jLabel6.setText("Stock");
  120.  
  121. jLabel7.setText("Nombre");
  122.  
  123. jLabel8.setText("Precio");
  124.  
  125. jLabel9.setText("Cantidad");
  126.  
  127. panel1.addMouseListener(new java.awt.event.MouseAdapter() {
  128. public void mouseClicked(java.awt.event.MouseEvent evt) {
  129. panel1MouseClicked(evt);
  130. }
  131. });
  132. jScrollPane1.setViewportView(panel1);
  133.  
  134. jScrollPane2.setViewportView(panel2);
  135.  
  136. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  137. getContentPane().setLayout(layout);
  138. layout.setHorizontalGroup(
  139. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  140. .addGroup(layout.createSequentialGroup()
  141. .addContainerGap()
  142. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  143. .addGroup(layout.createSequentialGroup()
  144. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  145. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  146. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  147. .addGroup(layout.createSequentialGroup()
  148. .addGap(0, 0, Short.MAX_VALUE)
  149. .addComponent(jLabel2)
  150. .addGap(18, 18, 18)
  151. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
  152. .addGap(42, 42, 42))
  153. .addGroup(layout.createSequentialGroup()
  154. .addComponent(Bdevolver, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  155. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
  156. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  157. .addComponent(bComprar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  158. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED))))
  159. .addGroup(layout.createSequentialGroup()
  160. .addComponent(jLabel4)
  161. .addGap(67, 67, 67)
  162. .addComponent(jLabel5)
  163. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  164. .addComponent(jLabel6)
  165. .addGap(181, 181, 181)))
  166. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  167. .addGroup(layout.createSequentialGroup()
  168. .addComponent(jLabel7)
  169. .addGap(76, 76, 76)
  170. .addComponent(jLabel8)
  171. .addGap(70, 70, 70)
  172. .addComponent(jLabel9))
  173. .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))
  174. .addGap(22, 22, 22))
  175. .addGroup(layout.createSequentialGroup()
  176. .addGap(53, 53, 53)
  177. .addComponent(jLabel1)
  178. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  179. .addComponent(jLabel3)
  180. .addGap(31, 31, 31))
  181. );
  182. layout.setVerticalGroup(
  183. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  184. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  185. .addContainerGap()
  186. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  187. .addComponent(jLabel1)
  188. .addComponent(jLabel3))
  189. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 33, Short.MAX_VALUE)
  190. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  191. .addComponent(jLabel4)
  192. .addComponent(jLabel6)
  193. .addComponent(jLabel7)
  194. .addComponent(jLabel8)
  195. .addComponent(jLabel9)
  196. .addComponent(jLabel5))
  197. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  198. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  199. .addGroup(layout.createSequentialGroup()
  200. .addGap(38, 38, 38)
  201. .addComponent(bComprar)
  202. .addGap(47, 47, 47)
  203. .addComponent(Bdevolver)
  204. .addGap(70, 70, 70)
  205. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  206. .addComponent(jLabel2)
  207. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  208. .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 206, javax.swing.GroupLayout.PREFERRED_SIZE)
  209. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 205, javax.swing.GroupLayout.PREFERRED_SIZE))
  210. .addGap(25, 25, 25))
  211. );
  212.  
  213. pack();
  214. }// </editor-fold>
  215.  
  216. private void bComprarActionPerformed(java.awt.event.ActionEvent evt) {
  217. try {
  218. int seleccion=panel1.getSelectedIndex()+1;
  219. if(seleccion<0){
  220. JOptionPane.showMessageDialog(null,"FAILagor");
  221. }else{
  222. Principal.rs.absolute(seleccion);
  223. int stock=Principal.rs.getInt("stock");
  224.  
  225. if(stock>=0){
  226. stock--;
  227. Principal.rs.updateInt("stock", stock);
  228. Principal.rs.updateRow();
  229. cargaLista ();
  230.  
  231. rs1.moveToInsertRow();
  232. rs1.updateInt("id_cliente", +1);
  233. rs1.updateInt("id_movil", Principal.rs.getInt("ID"));
  234. rs1.updateString("nombre", Principal.rs.getString("Nombre"));
  235. rs1.updateInt("precio", Principal.rs.getInt("Precio"));
  236. rs1.updateInt("cantidad", +1);
  237. rs1.insertRow();
  238. listaderecha();
  239.  
  240. }else {
  241. JOptionPane.showMessageDialog(this, "No quedan unidades");
  242. }
  243. }} catch (SQLException ex) {
  244. JOptionPane.showMessageDialog(this, ex.getMessage());
  245. }
  246. }
  247.  
  248. private void panel1MouseClicked(java.awt.event.MouseEvent evt) {
  249.  
  250. }
  251.  
  252. private void BdevolverMouseClicked(java.awt.event.MouseEvent evt) {
  253. lm1.clear();
  254.  
  255. }
  256.  
  257. public static void main(String args[]) {
  258.  
  259. java.awt.EventQueue.invokeLater(new Runnable() {
  260. public void run() {
  261. new Secundario().setVisible(true);
  262. }
  263. });
  264. }
  265.  
  266. // Variables declaration - do not modify
  267. private javax.swing.JButton Bdevolver;
  268. private javax.swing.JButton bComprar;
  269. private javax.swing.JLabel jLabel1;
  270. private javax.swing.JLabel jLabel2;
  271. private javax.swing.JLabel jLabel3;
  272. private javax.swing.JLabel jLabel4;
  273. private javax.swing.JLabel jLabel5;
  274. private javax.swing.JLabel jLabel6;
  275. private javax.swing.JLabel jLabel7;
  276. private javax.swing.JLabel jLabel8;
  277. private javax.swing.JLabel jLabel9;
  278. private javax.swing.JScrollPane jScrollPane1;
  279. private javax.swing.JScrollPane jScrollPane2;
  280. private javax.swing.JTextField jTextField1;
  281. private javax.swing.JList<String> panel1;
  282. private javax.swing.JList<String> panel2;
  283. // End of variables declaration
  284. }
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!