API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 6th, 2016
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.90 KB | None | 0 0
raw download clone embed print report
  1. package control07;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.util.logging.Level;
  9. import java.util.logging.Logger;
  10.  
  11. /**
  12. *
  13. * @author CESAR
  14. */
  15. public class Crud extends javax.swing.JFrame {
  16.  
  17. /**
  18. * Creates new form Crud
  19. */
  20. public Crud() {
  21. initComponents();
  22. cargarRegion();
  23. cargarPronvincia();
  24. cargarComuna();
  25.  
  26.  
  27. }
  28.  
  29.  
  30. @SuppressWarnings("unchecked")
  31. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  32. private void initComponents() {
  33.  
  34. jLabel1 = new javax.swing.JLabel();
  35. jLabel2 = new javax.swing.JLabel();
  36. jLabel3 = new javax.swing.JLabel();
  37. jLabel4 = new javax.swing.JLabel();
  38. jLabel5 = new javax.swing.JLabel();
  39. jLabel6 = new javax.swing.JLabel();
  40. jLabel7 = new javax.swing.JLabel();
  41. jLabel8 = new javax.swing.JLabel();
  42. jLabel9 = new javax.swing.JLabel();
  43. jTextFieldRut = new javax.swing.JTextField();
  44. jTextFieldNombre = new javax.swing.JTextField();
  45. jTextFieldFono = new javax.swing.JTextField();
  46. jTextFieldCelular = new javax.swing.JTextField();
  47. jTextFieldEmail = new javax.swing.JTextField();
  48. jTextFieldDireccion = new javax.swing.JTextField();
  49. jComboBoxRegion = new javax.swing.JComboBox<>();
  50. jComboBoxProvi = new javax.swing.JComboBox<>();
  51. jComboBoxComuna = new javax.swing.JComboBox<>();
  52. jButtonAgregar = new javax.swing.JButton();
  53. jButtonBuscar = new javax.swing.JButton();
  54. jButtonEliminar = new javax.swing.JButton();
  55. jButtonModificar = new javax.swing.JButton();
  56. jButtonListar = new javax.swing.JButton();
  57. jScrollPane1 = new javax.swing.JScrollPane();
  58. jTextArea1 = new javax.swing.JTextArea();
  59.  
  60. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  61.  
  62. jLabel1.setText("Rut");
  63.  
  64. jLabel2.setText("Nombre");
  65.  
  66. jLabel3.setText("Fono");
  67.  
  68. jLabel4.setText("Celular");
  69.  
  70. jLabel5.setText("E-mail");
  71.  
  72. jLabel6.setText("Dirección");
  73.  
  74. jLabel7.setText("Región");
  75.  
  76. jLabel8.setText("Provincia");
  77.  
  78. jLabel9.setText("Comuna");
  79.  
  80. jComboBoxRegion.addActionListener(new java.awt.event.ActionListener() {
  81. public void actionPerformed(java.awt.event.ActionEvent evt) {
  82. jComboBoxRegionActionPerformed(evt);
  83. }
  84. });
  85.  
  86. jComboBoxProvi.addActionListener(new java.awt.event.ActionListener() {
  87. public void actionPerformed(java.awt.event.ActionEvent evt) {
  88. jComboBoxProviActionPerformed(evt);
  89. }
  90. });
  91.  
  92. jButtonAgregar.setText("Agregar");
  93.  
  94. jButtonBuscar.setText("Buscar");
  95.  
  96. jButtonEliminar.setText("Eliminar");
  97.  
  98. jButtonModificar.setText("Modificar");
  99.  
  100. jButtonListar.setText("Listar");
  101.  
  102. jTextArea1.setColumns(20);
  103. jTextArea1.setRows(5);
  104. jScrollPane1.setViewportView(jTextArea1);
  105.  
  106. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  107. getContentPane().setLayout(layout);
  108. layout.setHorizontalGroup(
  109. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  110. .addGroup(layout.createSequentialGroup()
  111. .addGap(24, 24, 24)
  112. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  113. .addGroup(layout.createSequentialGroup()
  114. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  115. .addComponent(jLabel9)
  116. .addComponent(jLabel8))
  117. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  118. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  119. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  120. .addComponent(jScrollPane1)
  121. .addGroup(layout.createSequentialGroup()
  122. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  123. .addGroup(layout.createSequentialGroup()
  124. .addComponent(jLabel4)
  125. .addGap(28, 28, 28)
  126. .addComponent(jTextFieldCelular))
  127. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  128. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  129. .addComponent(jLabel3)
  130. .addComponent(jLabel2))
  131. .addGap(24, 24, 24)
  132. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  133. .addComponent(jTextFieldNombre)
  134. .addComponent(jTextFieldFono)))
  135. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  136. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  137. .addComponent(jLabel6)
  138. .addComponent(jLabel5))
  139. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  140. .addGroup(layout.createSequentialGroup()
  141. .addGap(18, 18, 18)
  142. .addComponent(jTextFieldEmail))
  143. .addGroup(layout.createSequentialGroup()
  144. .addGap(18, 18, 18)
  145. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  146. .addComponent(jTextFieldDireccion)
  147. .addComponent(jComboBoxRegion, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  148. .addComponent(jComboBoxProvi, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  149. .addComponent(jComboBoxComuna, 0, 257, Short.MAX_VALUE)))))
  150. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  151. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  152. .addComponent(jLabel7)
  153. .addComponent(jLabel1))
  154. .addGap(27, 27, 27)
  155. .addComponent(jTextFieldRut)))
  156. .addGap(18, 18, 18)
  157. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  158. .addComponent(jButtonAgregar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  159. .addComponent(jButtonBuscar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  160. .addComponent(jButtonEliminar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  161. .addComponent(jButtonModificar, javax.swing.GroupLayout.DEFAULT_SIZE, 83, Short.MAX_VALUE)
  162. .addComponent(jButtonListar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
  163. .addGap(36, 36, 36))))
  164. );
  165. layout.setVerticalGroup(
  166. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  167. .addGroup(layout.createSequentialGroup()
  168. .addGap(64, 64, 64)
  169. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  170. .addComponent(jLabel1)
  171. .addComponent(jTextFieldRut, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  172. .addComponent(jButtonAgregar))
  173. .addGap(18, 18, 18)
  174. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  175. .addComponent(jLabel2)
  176. .addComponent(jTextFieldNombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  177. .addComponent(jButtonBuscar))
  178. .addGap(18, 18, 18)
  179. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  180. .addComponent(jLabel3)
  181. .addComponent(jTextFieldFono, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  182. .addComponent(jButtonEliminar))
  183. .addGap(18, 18, 18)
  184. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  185. .addComponent(jLabel4)
  186. .addComponent(jTextFieldCelular, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  187. .addComponent(jButtonModificar))
  188. .addGap(18, 18, 18)
  189. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  190. .addComponent(jLabel5)
  191. .addComponent(jTextFieldEmail, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  192. .addComponent(jButtonListar))
  193. .addGap(18, 18, 18)
  194. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  195. .addComponent(jLabel6)
  196. .addComponent(jTextFieldDireccion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  197. .addGap(18, 18, 18)
  198. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  199. .addComponent(jLabel7)
  200. .addComponent(jComboBoxRegion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  201. .addGap(18, 18, 18)
  202. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  203. .addComponent(jLabel8)
  204. .addComponent(jComboBoxProvi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  205. .addGap(18, 18, 18)
  206. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  207. .addComponent(jLabel9)
  208. .addComponent(jComboBoxComuna, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  209. .addGap(18, 18, 18)
  210. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 159, Short.MAX_VALUE)
  211. .addContainerGap())
  212. );
  213.  
  214. pack();
  215. }// </editor-fold>
  216.  
  217. private void jComboBoxRegionActionPerformed(java.awt.event.ActionEvent evt) {
  218.  
  219.  
  220. System.out.println(jComboBoxRegion.getSelectedItem().toString());
  221. }
  222.  
  223. private void jComboBoxProviActionPerformed(java.awt.event.ActionEvent evt) {
  224.  
  225.  
  226. }
  227.  
  228. /**
  229. * @param args the command line arguments
  230. */
  231. public void cargarRegion(){
  232. try {
  233. Connection con=null;
  234. Class.forName("com.mysql.jdbc.Driver");
  235. con = DriverManager.getConnection("jdbc:mysql://localhost/Chile","root","");
  236. Statement st=con.createStatement();
  237. ResultSet rs=st.executeQuery("SELECT * FROM `region`");
  238. jComboBoxRegion.removeAllItems();
  239. while(rs.next()){
  240. jComboBoxRegion.addItem(rs.getString(2));
  241.  
  242. }
  243. } catch (ClassNotFoundException ex) {
  244. Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
  245. } catch (SQLException ex) {
  246. Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
  247. }
  248.  
  249. }
  250. public void cargarPronvincia(){
  251. try {
  252. Connection con=null;
  253. Class.forName("com.mysql.jdbc.Driver");
  254. con = DriverManager.getConnection("jdbc:mysql://localhost/Chile","root","");
  255. Statement st=con.createStatement();
  256. ResultSet rs=st.executeQuery("SELECT * FROM `provincia`");
  257.  
  258. jComboBoxProvi.removeAllItems();
  259. while(rs.next()){
  260. jComboBoxProvi.addItem(rs.getString(2));
  261.  
  262. }
  263. } catch (ClassNotFoundException ex) {
  264. Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
  265. } catch (SQLException ex) {
  266. Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
  267. }
  268.  
  269. }
  270. public void cargarComuna(){
  271. try {
  272. Connection con=null;
  273. Class.forName("com.mysql.jdbc.Driver");
  274. con = DriverManager.getConnection("jdbc:mysql://localhost/Chile","root","");
  275. Statement st=con.createStatement();
  276. ResultSet rs=st.executeQuery("SELECT * FROM `comuna`");
  277. jComboBoxComuna.removeAllItems();
  278. while(rs.next()){
  279. jComboBoxComuna.addItem(rs.getString(2));
  280.  
  281. }
  282. } catch (ClassNotFoundException ex) {
  283. Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
  284. } catch (SQLException ex) {
  285. Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
  286. }
  287.  
  288. }
  289.  
  290.  
  291. public static void main(String args[]) {
  292. /* Set the Nimbus look and feel */
  293. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  294. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  295. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  296. */
  297. try {
  298. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  299. if ("Nimbus".equals(info.getName())) {
  300. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  301. break;
  302. }
  303. }
  304. } catch (ClassNotFoundException ex) {
  305. java.util.logging.Logger.getLogger(Crud.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  306. } catch (InstantiationException ex) {
  307. java.util.logging.Logger.getLogger(Crud.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  308. } catch (IllegalAccessException ex) {
  309. java.util.logging.Logger.getLogger(Crud.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  310. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  311. java.util.logging.Logger.getLogger(Crud.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  312. }
  313. //</editor-fold>
  314.  
  315. /* Create and display the form */
  316. java.awt.EventQueue.invokeLater(new Runnable() {
  317. public void run() {
  318. new Crud().setVisible(true);
  319. }
  320. });
  321. }
  322.  
  323. // Variables declaration - do not modify
  324. private javax.swing.JButton jButtonAgregar;
  325. private javax.swing.JButton jButtonBuscar;
  326. private javax.swing.JButton jButtonEliminar;
  327. private javax.swing.JButton jButtonListar;
  328. private javax.swing.JButton jButtonModificar;
  329. private javax.swing.JComboBox<String> jComboBoxComuna;
  330. private javax.swing.JComboBox<String> jComboBoxProvi;
  331. private javax.swing.JComboBox<String> jComboBoxRegion;
  332. private javax.swing.JLabel jLabel1;
  333. private javax.swing.JLabel jLabel2;
  334. private javax.swing.JLabel jLabel3;
  335. private javax.swing.JLabel jLabel4;
  336. private javax.swing.JLabel jLabel5;
  337. private javax.swing.JLabel jLabel6;
  338. private javax.swing.JLabel jLabel7;
  339. private javax.swing.JLabel jLabel8;
  340. private javax.swing.JLabel jLabel9;
  341. private javax.swing.JScrollPane jScrollPane1;
  342. private javax.swing.JTextArea jTextArea1;
  343. private javax.swing.JTextField jTextFieldCelular;
  344. private javax.swing.JTextField jTextFieldDireccion;
  345. private javax.swing.JTextField jTextFieldEmail;
  346. private javax.swing.JTextField jTextFieldFono;
  347. private javax.swing.JTextField jTextFieldNombre;
  348. private javax.swing.JTextField jTextFieldRut;
  349. // End of variables declaration
  350. }
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!