Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- try
- {
- texto1=txt1.getText().trim();
- texto2=txt2.getText().trim();
- texto3=Integer.parseInt(txt3.getText().trim());
- paso=true;
- }
- catch(Exception e2)
- {
- JOptionPane.showMessageDialog(null,"Debe rellenar los campos");
- paso=false;
- }
- if(paso==true)
- {
- modelo = new DefaultListModel();
- try
- {
- Connection conexion=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=menu","sa","sa");
- consulta=conexion.prepareStatement("INSERT INTO ALMACENAR VALUES(?,?,?)");
- consulta.setString(1, texto1);
- consulta.setString(2,texto2);
- consulta.setInt(3, texto3);
- consulta.executeUpdate();
- JOptionPane.showMessageDialog(null, "Datos ingresados correctamente");
- txt1.setText("");
- txt2.setText("");
- txt3.setText("");
- consulta.close();
- try
- {
- conexion=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=menu","sa","sa");
- statement=conexion.createStatement();
- //recorrer bd
- String pedir="SELECT DISTINCT nombre,apellido FROM almacenar order by nombre";
- resulset=statement.executeQuery(pedir);
- while(resulset.next())
- {
- modelo.addElement(resulset.getString(1));
- }
- resulset.close();
- lista.setModel(modelo);
- }
- catch(Exception error)
- {
- error.printStackTrace();
- }
- JOptionPane.showMessageDialog(null,"Usuario registrado Satisfactoriamente");
- }
- catch(Exception ex)
- {
- JOptionPane.showMessageDialog(null, "Este nombre ya esta en uso");
- //ex.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment