Advertisement
Guest User

Untitled

a guest
Jan 31st, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.00 KB | None | 0 0
  1. Exception in thread "main" java.lang.NullPointerException
  2. at java.awt.Container.addImpl(Container.java:1041)
  3. at java.awt.Container.add(Container.java:959)
  4. at javax.swing.JFrame.addImpl(JFrame.java:545)
  5. at java.awt.Container.add(Container.java:365)
  6. at based1.<init>(based1.java:143)
  7. at based1.main(based1.java:218)
  8.  
  9. import java.awt.*;
  10. import javax.swing.*;
  11. import java.awt.event.*;
  12. import java.util.*;
  13. import java.sql.*;
  14. import java.util.Vector;
  15. import javax.swing.table.AbstractTableModel;
  16. import javax.swing.event.TableModelEvent;
  17. import javax.swing.table.DefaultTableModel;
  18.  
  19. public class based1 extends JFrame implements ActionListener{
  20. private JTextField textfield1,textfield2,textfield3,textfield4,textfield5;
  21. private JLabel label1,label2,label3,label4,label5;
  22. private JButton boton1,boton2,boton3,boton4;
  23. private JTextArea texto;
  24.  
  25. //variables
  26. int id;
  27. int aux1=0,aux2=0,aux3=0,aux4=0,aux5=0;
  28. float aux6=0;
  29.  
  30. String linea="";
  31. String linea1="";
  32. String linea2="";
  33. String linea3="";
  34. String linea4="";
  35. String linea5="";
  36.  
  37. public void limpiar(){
  38. textfield1.setText("");
  39. textfield2.setText("");
  40. textfield3.setText("");
  41. textfield4.setText("");
  42. textfield5.setText("");
  43.  
  44. }
  45.  
  46. public void tabla1() {
  47. Vector nombresColumnas=new Vector();
  48. nombresColumnas.add("MATRICULA");
  49. nombresColumnas.add("NOMBRES Y APELLIDOS");
  50. nombresColumnas.add("EX1");
  51. nombresColumnas.add("EX2");
  52. nombresColumnas.add("EX3");
  53. DefaultTableModel modelo=new DefaultTableModel(nombresColumnas,0);//0
  54. JTable tabla=new JTable();
  55. tabla.setModel(modelo);
  56.  
  57. try{ Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
  58. } catch (ClassNotFoundException e1){
  59. System.out.println(e1.getMessage());}
  60.  
  61. try{
  62. String password ="";
  63. //nombre de la base de datos Acces con extencion *.mdb o *.accdb
  64. String dbName = "curso1.mdb";
  65. //direccion de la base de datos
  66. String bd= System.getProperty ("user.dir") + "\" + dbName + ";PWD=" + password;
  67. Connection conexion = DriverManager.getConnection("jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ="+bd);
  68. Statement estatuto = conexion.createStatement();
  69. ResultSet rs = estatuto.executeQuery ("select * FROM lista ORDER BY MATRICULA" );
  70. while (rs.next())
  71.  
  72. {
  73. Vector v;
  74. v= new Vector();
  75. v.add (rs.getString("MATRICULA"));
  76. v.add (rs.getString("NOMBRE"));
  77. v.add (rs.getInt("EX1"));
  78. v.add (rs.getInt("EX2"));
  79. v.add (rs.getInt("EX3"));
  80. modelo.addRow(v);
  81. }
  82.  
  83. ///WHILE
  84. JScrollPane scroll=new JScrollPane (tabla);
  85. this.getContentPane().add (scroll);
  86. scroll.setBounds(350,30,400,300);
  87. scroll.setViewportView(tabla);
  88. scroll.setVisible(true);
  89. estatuto.close();
  90. conexion.close();
  91. }catch(SQLException e1) {System.out.println(e1.getMessage());
  92. }
  93. this.setTitle("Datos Ingresados Correctamente!!!") ;
  94. }
  95.  
  96. public based1() {
  97. setLayout(null);
  98.  
  99. label1=new JLabel("Matricula:");
  100. label1.setBounds(5,5,100,30);
  101. add(label1);
  102. textfield1=new JTextField();
  103. textfield1.setBounds(65,10,100,20);
  104. add(textfield1);
  105.  
  106. label2=new JLabel("Nombres:");
  107. label2.setBounds(5,25,100,30);
  108. add(label2);
  109.  
  110. textfield2=new JTextField();
  111. textfield2.setBounds(65,32,200,21);
  112. add(textfield2);
  113.  
  114. label3=new JLabel("Nota 1:");
  115. label3.setBounds(5,53,100,30);
  116. add(label3);
  117. textfield3=new JTextField();
  118. textfield3.setBounds(65,55,50,21);
  119. add(textfield3);
  120.  
  121. label4=new JLabel("Nota 2:");
  122. label4.setBounds(120,53,100,30);
  123. add(label4);
  124. textfield4=new JTextField();
  125. textfield4.setBounds(170,55,50,21);
  126. add(textfield4);
  127.  
  128. label5=new JLabel("Nota 3:");
  129. label5.setBounds(225,53,100,30);
  130. add(label5);
  131. textfield5=new JTextField();
  132. textfield5.setBounds(280,55,50,21);
  133. add(textfield5);
  134.  
  135. boton1=new JButton("Grabar");
  136. boton1.setMnemonic('G');
  137. boton1.setBounds(10,120,100,30);
  138. add(boton1);
  139. boton1.addActionListener(this);
  140.  
  141. boton2=new JButton("Salir");
  142. boton2.setMnemonic('S');
  143. boton2.setBounds(220,120,100,30);
  144. add(boton2);
  145. boton2.addActionListener(this);
  146.  
  147.  
  148. boton2=new JButton("Mostrar");
  149. boton2.setMnemonic('D');
  150. boton2.setBounds(350,120,100,30);
  151. add(boton3);
  152. boton2.addActionListener(this);
  153.  
  154.  
  155. boton2=new JButton("Limpiar");
  156. boton2.setMnemonic('D');
  157. boton2.setBounds(500,120,100,30);
  158. add(boton4);
  159. boton2.addActionListener(this);
  160. }
  161.  
  162. public void actionPerformed(ActionEvent e) {
  163. if (e.getSource()==boton1) {
  164. linea="";
  165. linea1=textfield1.getText();
  166. linea2=textfield2.getText();
  167. linea3=textfield3.getText();
  168. linea4=textfield4.getText();
  169. linea5=textfield5.getText();
  170. id=Integer.parseInt(linea1);
  171.  
  172. try{
  173. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  174.  
  175. } catch(ClassNotFoundException e1) {
  176.  
  177. System.out.println(e1.getMessage());
  178. }
  179. if(id>0) {
  180.  
  181. try{
  182.  
  183. String password ="";
  184.  
  185. String dbName= "curso1.mdb";
  186.  
  187.  
  188. String bd = System.getProperty("user.dir") + "\" + dbName + ";PWD=" + password;
  189.  
  190. Connection conexion = DriverManager.getConnection("jdbc:odbc:;DRIVER=Microsoft Acces Driver (*.mdb,*.accdb);DBQ=" +bd);
  191.  
  192. Statement estatuto= conexion.createStatement();
  193.  
  194. aux1=Integer.parseInt(linea1);
  195. aux3=Integer.parseInt(linea3);
  196. aux4=Integer.parseInt(linea4);
  197. aux5=Integer.parseInt(linea5);
  198.  
  199. String q="insert into lista (MATRICULA,NOMBRE,EX1,EX2,EX3)values("+aux1 +", '"+linea2+"',"+aux3+","+aux4+","+aux5+")";
  200.  
  201. estatuto.executeUpdate(q);
  202. estatuto.close();
  203. conexion.close();
  204.  
  205. }catch(SQLException e1){
  206.  
  207. texto.append(e1.getMessage());
  208. }
  209. }
  210. else{
  211. JOptionPane.showMessageDialog(null, "La matricula es incorrecta, debe ser numerica");
  212. }
  213. tabla1();
  214. limpiar();
  215. }
  216.  
  217. if (e.getSource()==boton2) {
  218.  
  219. System.exit(0);
  220. }
  221. }
  222.  
  223.  
  224. public static void main(String[] args) {
  225.  
  226. based1 formulario1=new based1();
  227. formulario1.setBounds(1,50,850,450);
  228. formulario1.setVisible(true);
  229. formulario1.setTitle("Formulario de ingreso de Datos Java+Acces");
  230. }
  231.  
  232. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement