Guest User

Untitled

a guest
Jul 12th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. <select>
  2. <%
  3. ConectaDB con=new ConectaDB();
  4. try{
  5. con.conectar();
  6. String sql="select unique(n_dep) from ocex_uea order by n_dep asc";
  7. con.st=con.conexion.createStatement();
  8. con.rt=con.st.executeQuery(sql);
  9. while (con.rt.next()){
  10. out.println("<option>"+con.rt.getString(2)+"</option>");}
  11. }catch(Exception e){
  12. out.print(e.toString());}
  13. %>
  14. </select>
  15. <label for="DEPARTAMENTO"><Strong>SELECCIONE DEPARTAMENTO:</Strong></label>
  16.  
  17. import java.sql.Connection;
  18. import java.sql.DriverManager;
  19. import java.sql.ResultSet;
  20. import java.sql.Statement;
  21.  
  22. public class ConectaDB {
  23. public Connection conexion;
  24.  
  25. public Statement st=null;
  26. public ResultSet rt=null;
  27.  
  28. public Connection getConnection() {
  29. return conexion;
  30. }
  31.  
  32. public void setConexion(Connection conexion) {
  33. this.conexion = conexion;
  34. }
  35.  
  36. public ConectaDB conectar() {
  37. try {
  38. Class.forName("oracle.jdbc.OracleDriver");
  39. String BaseDeDatos = "jdbc:oracle:thin:@localhost:1521:XE";
  40. conexion = DriverManager.getConnection(BaseDeDatos, "ocexpnp", "root");
  41.  
  42. if (conexion != null) {
  43. System.out.println("Conexion exitosa!");
  44. }
  45. else {
  46. System.out.println("Conexion fallida!");
  47. }
  48. } catch (Exception e) {
  49. e.printStackTrace();
  50. }
  51. return this;
  52. }
  53. }
Add Comment
Please, Sign In to add comment