API tools faq
paste
Advertisement
Guest User

Untitled

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