Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Conector {
- public static Connection connect(){
- String url="D:\ANGELO\Base de Datos SQLite\SISGO\sisgo.db";
- Connection connect=null;
- try {
- Class.forName("org.sqlite.JDBC");
- connect= DriverManager.getConnection("jdbc:sqlite:"+url);
- if (connect!=null) {
- System.out.println("Conectado");
- }
- } catch (SQLException ex) {
- System.err.println("No se ha podido conectar a la base de datosn"+ex.getMessage());
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return connect;
- }
- public class Usuario_DTO_bo implements Usuario_DAO {
- Connection con=null; //Creando la variable conexion para que sea usada por todos los metodos
- @Override
- //Metodo para agregar usuario
- public void agregarUsuario(Usuario_DTO_bean usuario) {
- try {
- String salto=PasswordUtils.getSalt(30);
- String pass=PasswordUtils.generateSecurePassword(usuario.getClave(), salto);
- con=Conector.connect();
- PreparedStatement st= con.prepareStatement("insert into usuario (usuario,clave,permisos,estado,apellido_p,apellido_m,nombre,salto) VALUES (?,?,?,?,?,?,?,?);");
- st.setString(1, usuario.getUsuario());
- st.setString(2, pass);
- st.setString(3, usuario.getPermisos());
- st.setInt(4, usuario.getEstado());
- st.setString(5, usuario.getApellido_p());
- st.setString(6, usuario.getApellido_m());
- st.setString(7, usuario.getNombre());
- st.setString(8, salto);
- st.execute();
- con.close();
- } catch (Exception e) {
- System.err.println(e.getMessage());
- }
- }
- con=Conector.connect();
- package Database;
- //aqui van muchas bibliotecas que no puse para no llenar espacio :)
- public class prueba {
- public static void main(String[] args) throws ClassNotFoundException,
- IOException {
- String server = "10.175.51.25";
- int port = 21;
- String user = "anonymous";
- String pass = "anonymous";
- FTPClient ftpClient = new FTPClient();
- try {
- ftpClient.connect(server, port);
- showServerReply(ftpClient);
- int replyCode = ftpClient.getReplyCode();
- if (!FTPReply.isPositiveCompletion(replyCode)) {
- System.out.println("Operation failed. Server reply code: " + replyCode);
- return;
- }
- boolean success = ftpClient.login(user, pass);
- showServerReply(ftpClient);
- if (!success) {
- System.out.println("Could not login to the server");
- return;
- } else {
- System.out.println("LOGGED IN SERVER");
- }
- ftpClient.logout();
- ftpClient.disconnect();
- }
- catch (IOException ex) {
- System.out.println("Oops! Something wrong happened");
- ex.printStackTrace();
- }
- }
- private static void showServerReply(FTPClient ftpClient) {
- String[] replies = ftpClient.getReplyStrings();
- if (replies != null && replies.length > 0) {
- for (String aReply : replies) {
- System.out.println("SERVER: " + aReply);
- }
- }
- }
- }
- ftp=Conector_FTP.connect();
Add Comment
Please, Sign In to add comment