Guest User

Untitled

a guest
Aug 21st, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.11 KB | None | 0 0
  1. public class Conector {
  2. public static Connection connect(){
  3. String url="D:\ANGELO\Base de Datos SQLite\SISGO\sisgo.db";
  4. Connection connect=null;
  5. try {
  6. Class.forName("org.sqlite.JDBC");
  7. connect= DriverManager.getConnection("jdbc:sqlite:"+url);
  8. if (connect!=null) {
  9. System.out.println("Conectado");
  10. }
  11. } catch (SQLException ex) {
  12. System.err.println("No se ha podido conectar a la base de datosn"+ex.getMessage());
  13. } catch (ClassNotFoundException e) {
  14. // TODO Auto-generated catch block
  15. e.printStackTrace();
  16. }
  17. return connect;
  18. }
  19.  
  20. public class Usuario_DTO_bo implements Usuario_DAO {
  21. Connection con=null; //Creando la variable conexion para que sea usada por todos los metodos
  22. @Override
  23. //Metodo para agregar usuario
  24. public void agregarUsuario(Usuario_DTO_bean usuario) {
  25. try {
  26. String salto=PasswordUtils.getSalt(30);
  27. String pass=PasswordUtils.generateSecurePassword(usuario.getClave(), salto);
  28. con=Conector.connect();
  29. PreparedStatement st= con.prepareStatement("insert into usuario (usuario,clave,permisos,estado,apellido_p,apellido_m,nombre,salto) VALUES (?,?,?,?,?,?,?,?);");
  30. st.setString(1, usuario.getUsuario());
  31. st.setString(2, pass);
  32. st.setString(3, usuario.getPermisos());
  33. st.setInt(4, usuario.getEstado());
  34. st.setString(5, usuario.getApellido_p());
  35. st.setString(6, usuario.getApellido_m());
  36. st.setString(7, usuario.getNombre());
  37. st.setString(8, salto);
  38. st.execute();
  39. con.close();
  40. } catch (Exception e) {
  41. System.err.println(e.getMessage());
  42. }
  43. }
  44.  
  45. con=Conector.connect();
  46.  
  47. package Database;
  48.  
  49. //aqui van muchas bibliotecas que no puse para no llenar espacio :)
  50.  
  51. public class prueba {
  52.  
  53. public static void main(String[] args) throws ClassNotFoundException,
  54. IOException {
  55.  
  56. String server = "10.175.51.25";
  57. int port = 21;
  58. String user = "anonymous";
  59. String pass = "anonymous";
  60. FTPClient ftpClient = new FTPClient();
  61. try {
  62. ftpClient.connect(server, port);
  63. showServerReply(ftpClient);
  64. int replyCode = ftpClient.getReplyCode();
  65. if (!FTPReply.isPositiveCompletion(replyCode)) {
  66. System.out.println("Operation failed. Server reply code: " + replyCode);
  67. return;
  68. }
  69. boolean success = ftpClient.login(user, pass);
  70. showServerReply(ftpClient);
  71. if (!success) {
  72. System.out.println("Could not login to the server");
  73. return;
  74. } else {
  75. System.out.println("LOGGED IN SERVER");
  76. }
  77.  
  78. ftpClient.logout();
  79. ftpClient.disconnect();
  80.  
  81.  
  82. }
  83.  
  84. catch (IOException ex) {
  85. System.out.println("Oops! Something wrong happened");
  86. ex.printStackTrace();
  87. }
  88.  
  89. }
  90. private static void showServerReply(FTPClient ftpClient) {
  91. String[] replies = ftpClient.getReplyStrings();
  92. if (replies != null && replies.length > 0) {
  93. for (String aReply : replies) {
  94. System.out.println("SERVER: " + aReply);
  95. }
  96. }
  97.  
  98.  
  99. }
  100. }
  101.  
  102. ftp=Conector_FTP.connect();
Add Comment
Please, Sign In to add comment