API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.54 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. * Compras.java
  8. *
  9. * Created on 4/05/2011, 11:40:33 AM
  10. */
  11.  
  12. package inventarios;
  13.  
  14. import java.sql.Connection;
  15. import java.sql.DriverManager;
  16. import java.sql.SQLException;
  17. import java.sql.Statement;
  18. import java.sql.ResultSet;
  19. import javax.swing.JOptionPane;
  20. import java.sql.PreparedStatement;
  21. import java.text.ParseException;
  22.  
  23.  
  24. //Obtiene la fecha de la maquina
  25. import java.text.SimpleDateFormat;
  26. import java.util.Date;
  27.  
  28.  
  29. /**
  30. *
  31. * @author Administrador
  32. */
  33. public class Compras extends javax.swing.JFrame {
  34.  
  35. /** Creates new form Compras */
  36. public Compras() {
  37. initComponents();
  38. }
  39.  
  40. Connection conn=null;
  41. Statement stmt=null;
  42. PreparedStatement pstmt=null;
  43. ResultSet rs=null;
  44. Integer proveint=null;
  45. Date Fecha=null;
  46.  
  47. /** This method is called from within the constructor to
  48. * initialize the form.
  49. * WARNING: Do NOT modify this code. The content of this method is
  50. * always regenerated by the Form Editor.
  51. */
  52. @SuppressWarnings("unchecked")
  53. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  54. private void initComponents() {
  55.  
  56. jlblModulodeCompras = new javax.swing.JLabel();
  57. jlblOrdendeCompra = new javax.swing.JLabel();
  58. jtxtOrdendeCompra = new javax.swing.JTextField();
  59. jlblFecha = new javax.swing.JLabel();
  60. jtxtFecha = new javax.swing.JTextField();
  61. jlblProveedor = new javax.swing.JLabel();
  62. jtxtProveedor = new javax.swing.JTextField();
  63. jlblNombredelProveedor = new javax.swing.JLabel();
  64. jlblDiasdeCredito = new javax.swing.JLabel();
  65. jcmbComprasAlmacen = new javax.swing.JComboBox();
  66. jLabel7 = new javax.swing.JLabel();
  67. jtxtObservacion = new javax.swing.JTextField();
  68. jbtnAltas = new javax.swing.JButton();
  69. jButton2 = new javax.swing.JButton();
  70. jButton3 = new javax.swing.JButton();
  71. jButton4 = new javax.swing.JButton();
  72. Compras_Almacen = new javax.swing.JLabel();
  73. jBtnGrabar = new javax.swing.JButton();
  74.  
  75. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  76. addWindowListener(new java.awt.event.WindowAdapter() {
  77. public void windowActivated(java.awt.event.WindowEvent evt) {
  78. formWindowActivated(evt);
  79. }
  80. });
  81.  
  82. jlblModulodeCompras.setFont(new java.awt.Font("Arial", 1, 14));
  83. jlblModulodeCompras.setText("Modulo de Compras");
  84.  
  85. jlblOrdendeCompra.setText("Orden de Compra");
  86.  
  87. jtxtOrdendeCompra.setEnabled(false);
  88. jtxtOrdendeCompra.setName("jtxtOrdendeCompra"); // NOI18N
  89.  
  90. jlblFecha.setText("Fecha");
  91.  
  92. jtxtFecha.setEditable(false);
  93. jtxtFecha.setEnabled(false);
  94. jtxtFecha.setName("jtxtFecha"); // NOI18N
  95.  
  96. jlblProveedor.setText("Proveedor");
  97.  
  98. jtxtProveedor.setEnabled(false);
  99. jtxtProveedor.setName("jtxtProveedor"); // NOI18N
  100. jtxtProveedor.addActionListener(new java.awt.event.ActionListener() {
  101. public void actionPerformed(java.awt.event.ActionEvent evt) {
  102. jtxtProveedorActionPerformed(evt);
  103. }
  104. });
  105. jtxtProveedor.addInputMethodListener(new java.awt.event.InputMethodListener() {
  106. public void caretPositionChanged(java.awt.event.InputMethodEvent evt) {
  107. jtxtProveedorCaretPositionChanged(evt);
  108. }
  109. public void inputMethodTextChanged(java.awt.event.InputMethodEvent evt) {
  110. jtxtProveedorInputMethodTextChanged(evt);
  111. }
  112. });
  113. jtxtProveedor.addKeyListener(new java.awt.event.KeyAdapter() {
  114. public void keyPressed(java.awt.event.KeyEvent evt) {
  115. jtxtProveedorKeyPressed(evt);
  116. }
  117. public void keyReleased(java.awt.event.KeyEvent evt) {
  118. jtxtProveedorKeyReleased(evt);
  119. }
  120. });
  121.  
  122. jlblNombredelProveedor.setText("Nombre de Proveedor");
  123. jlblNombredelProveedor.setName("Compras_NombredelProveedor"); // NOI18N
  124.  
  125. jlblDiasdeCredito.setText("Dias de Credito");
  126. jlblDiasdeCredito.setName("Compras_DiasdeCredito"); // NOI18N
  127.  
  128. jcmbComprasAlmacen.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Almacen Principal" }));
  129. jcmbComprasAlmacen.setEnabled(false);
  130. jcmbComprasAlmacen.setName("Compras_Almacen"); // NOI18N
  131.  
  132. jLabel7.setText("Observacion");
  133.  
  134. jtxtObservacion.setEnabled(false);
  135. jtxtObservacion.setName("jtxtObservacion"); // NOI18N
  136.  
  137. jbtnAltas.setText("Altas");
  138. jbtnAltas.addActionListener(new java.awt.event.ActionListener() {
  139. public void actionPerformed(java.awt.event.ActionEvent evt) {
  140. jbtnAltasActionPerformed(evt);
  141. }
  142. });
  143.  
  144. jButton2.setText("Bajas");
  145.  
  146. jButton3.setText("Cambios");
  147.  
  148. jButton4.setText("Consultas");
  149.  
  150. Compras_Almacen.setText("Almacen");
  151.  
  152. jBtnGrabar.setText("Grabar");
  153. jBtnGrabar.addActionListener(new java.awt.event.ActionListener() {
  154. public void actionPerformed(java.awt.event.ActionEvent evt) {
  155. jBtnGrabarActionPerformed(evt);
  156. }
  157. });
  158.  
  159. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  160. getContentPane().setLayout(layout);
  161. layout.setHorizontalGroup(
  162. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  163. .addGroup(layout.createSequentialGroup()
  164. .addContainerGap()
  165. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  166. .addGroup(layout.createSequentialGroup()
  167. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  168. .addComponent(jlblModulodeCompras)
  169. .addGroup(layout.createSequentialGroup()
  170. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  171. .addComponent(jlblOrdendeCompra)
  172. .addComponent(jlblProveedor)
  173. .addComponent(jLabel7))
  174. .addGap(8, 8, 8)
  175. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  176. .addGroup(layout.createSequentialGroup()
  177. .addComponent(jtxtOrdendeCompra, javax.swing.GroupLayout.PREFERRED_SIZE, 89, javax.swing.GroupLayout.PREFERRED_SIZE)
  178. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  179. .addComponent(jlblFecha)
  180. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  181. .addComponent(jtxtFecha, javax.swing.GroupLayout.DEFAULT_SIZE, 259, Short.MAX_VALUE))
  182. .addGroup(layout.createSequentialGroup()
  183. .addComponent(jtxtProveedor, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
  184. .addGap(18, 18, 18)
  185. .addComponent(jlblNombredelProveedor)
  186. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  187. .addComponent(jlblDiasdeCredito)
  188. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  189. .addComponent(jcmbComprasAlmacen, 0, 130, Short.MAX_VALUE))
  190. .addComponent(jtxtObservacion, javax.swing.GroupLayout.PREFERRED_SIZE, 175, javax.swing.GroupLayout.PREFERRED_SIZE)))
  191. .addGroup(layout.createSequentialGroup()
  192. .addComponent(jbtnAltas)
  193. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  194. .addComponent(jButton3)
  195. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  196. .addComponent(jButton2)
  197. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  198. .addComponent(jButton4)
  199. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  200. .addComponent(jBtnGrabar)))
  201. .addContainerGap())
  202. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  203. .addComponent(Compras_Almacen, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
  204. .addGap(50, 50, 50))))
  205. );
  206. layout.setVerticalGroup(
  207. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  208. .addGroup(layout.createSequentialGroup()
  209. .addContainerGap()
  210. .addComponent(jlblModulodeCompras)
  211. .addGap(18, 18, 18)
  212. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  213. .addComponent(jlblOrdendeCompra)
  214. .addComponent(jtxtOrdendeCompra, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  215. .addComponent(jlblFecha)
  216. .addComponent(jtxtFecha, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  217. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  218. .addComponent(Compras_Almacen)
  219. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  220. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  221. .addComponent(jcmbComprasAlmacen, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  222. .addComponent(jlblDiasdeCredito)
  223. .addComponent(jlblNombredelProveedor)
  224. .addComponent(jtxtProveedor, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  225. .addComponent(jlblProveedor))
  226. .addGap(18, 18, 18)
  227. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  228. .addComponent(jtxtObservacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  229. .addComponent(jLabel7))
  230. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 58, Short.MAX_VALUE)
  231. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  232. .addComponent(jbtnAltas)
  233. .addComponent(jBtnGrabar)
  234. .addComponent(jButton3)
  235. .addComponent(jButton4)
  236. .addComponent(jButton2))
  237. .addContainerGap())
  238. );
  239.  
  240. pack();
  241. }// </editor-fold>
  242.  
  243. private void jbtnAltasActionPerformed(java.awt.event.ActionEvent evt) {
  244. // TODO add your handling code here:
  245. jtxtFecha.enable(true);
  246. jtxtOrdendeCompra.enable(true);
  247. jtxtProveedor.enable(true);
  248. jcmbComprasAlmacen.enable(true);
  249. jtxtObservacion.enable(true);
  250. jtxtOrdendeCompra.requestFocus();
  251. }
  252.  
  253. private void formWindowActivated(java.awt.event.WindowEvent evt) {
  254. // TODO add your handling code here:
  255. Date date = new Date();
  256. SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
  257. jtxtFecha.setText(sdf.format(date));
  258. }
  259.  
  260. private void jtxtProveedorInputMethodTextChanged(java.awt.event.InputMethodEvent evt) {
  261. // TODO add your handling code here:
  262. }
  263.  
  264. private void jtxtProveedorCaretPositionChanged(java.awt.event.InputMethodEvent evt) {
  265. // TODO add your handling code here:
  266. }
  267.  
  268. private void jtxtProveedorKeyPressed(java.awt.event.KeyEvent evt) {
  269. // TODO add your handling code here:
  270. }
  271.  
  272. private void jtxtProveedorActionPerformed(java.awt.event.ActionEvent evt) {
  273. // TODO add your handling code here:
  274. }
  275.  
  276. private void jtxtProveedorKeyReleased(java.awt.event.KeyEvent evt) {
  277. // TODO add your handling code here:
  278. //Define la conexion Conn;
  279.  
  280. if (jtxtProveedor.getText().length()>0) {
  281. try{
  282. conn= DriverManager.getConnection("jdbc:mysql://localhost/angelica?"+"user=root&password=alecito");
  283. }catch (SQLException ex) {
  284. System.out.println("SQLException:" + ex.getMessage());
  285. System.out.println("SQLState:"+ ex.getSQLState());
  286. System.out.println("VendorError:"+ex.getErrorCode());
  287. }
  288.  
  289. //Recupera la secuencia de Datos
  290. try{
  291. //stmt=conn.createStatement();
  292. //rs=stmt.executeQuery("select * from prove where cla_prov=1");
  293.  
  294. pstmt=conn.prepareStatement("select * from prove where cla_prov= ?");
  295. proveint=Integer.parseInt(jtxtProveedor.getText());
  296. pstmt.setInt(1,proveint);
  297. rs=pstmt.executeQuery();
  298.  
  299. }catch (SQLException ex) {
  300. // handle any errors
  301. System.out.println("SQLException: " + ex.getMessage());
  302. System.out.println("SQLState: " + ex.getSQLState());
  303. System.out.println("VendorError: " + ex.getErrorCode());
  304. }
  305. finally{
  306. try {
  307. while (rs.next()){
  308. //Pongo los Datos en pantalla
  309. jlblNombredelProveedor.setText(rs.getString("nombre"));
  310. jlblDiasdeCredito.setText(rs.getString("credito"));
  311.  
  312. }
  313. rs.close();
  314. pstmt.close();
  315. } catch (SQLException ex) {
  316. // handle any errors
  317. System.out.println("SQLException: " + ex.getMessage());
  318. System.out.println("SQLState: " + ex.getSQLState());
  319. System.out.println("VendorError: " + ex.getErrorCode());
  320. }
  321. }
  322. }
  323. }
  324.  
  325. private void jBtnGrabarActionPerformed(java.awt.event.ActionEvent evt) {
  326. // TODO add your handling code here:
  327.  
  328. if(jtxtOrdendeCompra.getText().length()<=0){
  329. JOptionPane.showMessageDialog(jBtnGrabar,"Error Debe de meter un numero de compra ","Informativo",JOptionPane.INFORMATION_MESSAGE);
  330. }
  331. if (jtxtProveedor.getText().length()<=0){
  332. JOptionPane.showMessageDialog(jBtnGrabar,"Error Debe de meter un proveedor en la orden de compra","Informativo",JOptionPane.INFORMATION_MESSAGE);
  333. }
  334.  
  335. if((jtxtOrdendeCompra.getText().length()>0) && (jtxtProveedor.getText().length()>0) ){
  336.  
  337. try{
  338. conn= DriverManager.getConnection("jdbc:mysql://localhost/angelica?"+"user=root&password=alecito");
  339. }catch (SQLException ex){
  340. JOptionPane.showMessageDialog(jBtnGrabar,ex.getMessage(),"SQLException",JOptionPane.INFORMATION_MESSAGE);
  341. JOptionPane.showMessageDialog(jBtnGrabar,ex.getSQLState(),"SQLState",JOptionPane.INFORMATION_MESSAGE);
  342. JOptionPane.showMessageDialog(jBtnGrabar,ex.getErrorCode(),"VendorError",JOptionPane.INFORMATION_MESSAGE);
  343. }
  344. //Inserta los registros de la orden de compra
  345. try{
  346. Date date = new Date();
  347. SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
  348. jtxtFecha.setText(sdf.format(date));
  349. try{
  350. Fecha=sdf.parse(jtxtFecha.getText());
  351. }
  352. catch(ParseException e){
  353.  
  354. }
  355.  
  356.  
  357.  
  358.  
  359. pstmt=conn.prepareStatement("Insert into compras (noc,fecha,cla_pro) values(?,?,?)");
  360. pstmt.setInt(1,Integer.parseInt(jtxtOrdendeCompra.getText()));
  361. pstmt.setDate(2, (java.sql.Date) Fecha);
  362. pstmt.setInt(3,Integer.parseInt(jtxtProveedor.getText()));
  363.  
  364.  
  365.  
  366.  
  367. pstmt.executeUpdate();
  368. pstmt.close();
  369.  
  370. }catch(SQLException ex){
  371. JOptionPane.showMessageDialog(jBtnGrabar,ex.getMessage(),"SQLException",JOptionPane.INFORMATION_MESSAGE);
  372. JOptionPane.showMessageDialog(jBtnGrabar,ex.getSQLState(),"SQLState",JOptionPane.INFORMATION_MESSAGE);
  373. JOptionPane.showMessageDialog(jBtnGrabar,ex.getErrorCode(),"VendorError",JOptionPane.INFORMATION_MESSAGE);
  374. }
  375. }
  376.  
  377. JOptionPane.showMessageDialog(jBtnGrabar,"Se Grabo con Exito","Información",JOptionPane.INFORMATION_MESSAGE);
  378. }
  379.  
  380. /**
  381. * @param args the command line arguments
  382. */
  383. public static void main(String args[]) {
  384. java.awt.EventQueue.invokeLater(new Runnable() {
  385. public void run() {
  386. new Compras().setVisible(true);
  387. }
  388. });
  389. }
  390.  
  391. // Variables declaration - do not modify
  392. private javax.swing.JLabel Compras_Almacen;
  393. private javax.swing.JButton jBtnGrabar;
  394. private javax.swing.JButton jButton2;
  395. private javax.swing.JButton jButton3;
  396. private javax.swing.JButton jButton4;
  397. private javax.swing.JLabel jLabel7;
  398. private javax.swing.JButton jbtnAltas;
  399. private javax.swing.JComboBox jcmbComprasAlmacen;
  400. private javax.swing.JLabel jlblDiasdeCredito;
  401. private javax.swing.JLabel jlblFecha;
  402. private javax.swing.JLabel jlblModulodeCompras;
  403. private javax.swing.JLabel jlblNombredelProveedor;
  404. private javax.swing.JLabel jlblOrdendeCompra;
  405. private javax.swing.JLabel jlblProveedor;
  406. private javax.swing.JTextField jtxtFecha;
  407. private javax.swing.JTextField jtxtObservacion;
  408. private javax.swing.JTextField jtxtOrdendeCompra;
  409. private javax.swing.JTextField jtxtProveedor;
  410. // End of variables declaration
  411.  
  412. }
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!