{"id":1629,"date":"2016-05-05T14:04:00","date_gmt":"2016-05-05T19:04:00","guid":{"rendered":"http:\/\/linuxitos.com\/main\/guardar-imagenes-en-postgresql-desde-java\/"},"modified":"2016-05-05T14:04:00","modified_gmt":"2016-05-05T19:04:00","slug":"guardar-imagenes-en-postgresql-desde-java","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/guardar-imagenes-en-postgresql-desde-java\/","title":{"rendered":"Guardar im\u00e1genes en PostgreSQL desde Java"},"content":{"rendered":"<div dir=\"ltr\" style=\"text-align: left;\">\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/3.bp.blogspot.com\/-xAJvq0VGj5A\/VyuY7ixR3vI\/AAAAAAAAB9Q\/v9pPd40arooe_aVjTY0tEj0zfvI8wtFMACLcB\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-56-18.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"388\" src=\"https:\/\/3.bp.blogspot.com\/-xAJvq0VGj5A\/VyuY7ixR3vI\/AAAAAAAAB9Q\/v9pPd40arooe_aVjTY0tEj0zfvI8wtFMACLcB\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-56-18.png\" width=\"640\" \/><\/a><\/div>\n<p><\/p>\n<div style=\"text-align: justify;\"><span style=\"font-size: large;\">Esta es la versi\u00f3n 2.0.0 de Black-List utilizando una base de datos en PostgreSQL, aunque no sea mucha la diferencia con MySQL, ciertos m\u00e9todos y tipos de datos no son iguales o no se llaman igual. Por lo tanto me decid\u00ed a armar el mismo proyecto para ambos gestores de bases de datos.<\/span><\/div>\n<div style=\"text-align: justify;\"><span style=\"font-size: large;\"><br \/><\/span><\/div>\n<div style=\"text-align: justify;\"><span style=\"font-size: large;\">Esta versi\u00f3n contiene lo siguiente:<\/span><\/div>\n<ul><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Guardado de fechas en PostgreSQL.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Abrir link desde clic sobre JLabel.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Guardado y recuperaci\u00f3n de im\u00e1genes guardas en PostgreSQL usando tipo de dato BYTEA.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Recuperaci\u00f3n de las fechas y colocadas en una tabla<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Colocado de fechas en un JDateChooser<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Guardado de contrase\u00f1as encriptadas en md5 en PostgreSQL<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Validaci\u00f3n de usuarios a trav\u00e9s de la contrase\u00f1a encriptadas<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">SplashScreen con barra de progreso modificable.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Modificar la informaci\u00f3n del usuario en configuraci\u00f3n de la cuenta.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Login.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Creaci\u00f3n de usuarios.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Detecci\u00f3n al presionar enter: es decir, que cuando se presiona enter  en un cuadro de texto autom\u00e1ticamente se ejecuta la acci\u00f3n  correspondiente.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Altas, bajas, modificaciones, busquedas en la BD.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Uso de JDialog.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">B\u00fasqueda datos mientras se escribe: es decir, se van filtrando los registros al escribir.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Detecci\u00f3n de la tecla scape: es decir, en algunas ventanas, se  detecta la tecla scape, para indicar que se cancela la edici\u00f3n o  modificaci\u00f3n.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Uso de \u00edcono para la aplicaci\u00f3n.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Deshabilitar la opci\u00f3n del bot\u00f3n cerrar.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Uso de abrir y regresar a otro jframe.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Uso de clases.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Uso de objetos completos.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Manipulaci\u00f3n de objetos como registros.<\/span><\/li>\n<p><span style=\"font-size: large;\"><\/span><\/p>\n<li><span style=\"font-size: large;\">Incluye Script de la BD.<\/span><\/li>\n<\/ul>\n<p><\/p>\n<div style=\"text-align: center;\"><span style=\"font-size: large;\"><b>LInk de Descarga<\/b><\/span><\/div>\n<div style=\"text-align: center;\"><span style=\"font-size: x-large;\"><b><a href=\"https:\/\/github.com\/jesusferm\/BlackList-PostgreSQL\" target=\"_blank\">https:\/\/github.com\/jesusferm\/BlackList-PostgreSQL<\/a><\/b><\/span><\/div>\n<div style=\"text-align: center;\"><span style=\"font-size: large;\"><b>Algunas Capturas<\/b><\/span><\/div>\n<p><\/p>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/2.bp.blogspot.com\/-GwB4RK-pk7E\/VyuY7qez3JI\/AAAAAAAAB9M\/YXXDY7cKDAUUoy69KXQAqUOPAZWH389KgCLcB\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-56-30.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"640\" src=\"https:\/\/2.bp.blogspot.com\/-GwB4RK-pk7E\/VyuY7qez3JI\/AAAAAAAAB9M\/YXXDY7cKDAUUoy69KXQAqUOPAZWH389KgCLcB\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-56-30.png\" width=\"520\" \/><\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/2.bp.blogspot.com\/-HvQFPHRwqXQ\/VyuY8mwNOGI\/AAAAAAAAB9g\/4pbBdqa4EVQ8TxCYWeJ6f-6UR5nrmfgMgCLcB\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-54.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"394\" src=\"https:\/\/2.bp.blogspot.com\/-HvQFPHRwqXQ\/VyuY8mwNOGI\/AAAAAAAAB9g\/4pbBdqa4EVQ8TxCYWeJ6f-6UR5nrmfgMgCLcB\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-54.png\" width=\"640\" \/><\/a><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/1.bp.blogspot.com\/-skRAxn2m_gw\/VyuY79lkW3I\/AAAAAAAAB9U\/oU8myDvTobMIBhq8pnGOH2AU1Otnn73rwCLcB\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-08.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"396\" src=\"https:\/\/1.bp.blogspot.com\/-skRAxn2m_gw\/VyuY79lkW3I\/AAAAAAAAB9U\/oU8myDvTobMIBhq8pnGOH2AU1Otnn73rwCLcB\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-08.png\" width=\"640\" \/><\/a><\/div>\n<p><\/p>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/4.bp.blogspot.com\/-Ae4SinMFJqY\/VyuY8F7sbXI\/AAAAAAAAB9Y\/zgh97fpRRqgAEJ3PBQ3DaQCIOwrekQTZgCLcB\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-10.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"550\" src=\"https:\/\/4.bp.blogspot.com\/-Ae4SinMFJqY\/VyuY8F7sbXI\/AAAAAAAAB9Y\/zgh97fpRRqgAEJ3PBQ3DaQCIOwrekQTZgCLcB\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-10.png\" width=\"640\" \/><\/a><\/div>\n<p><\/p>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/3.bp.blogspot.com\/-I29X2_zgbsg\/VyuY8Z_xI0I\/AAAAAAAAB9c\/tcarn1qSG6MgnwD5kHvMuIX-XZavUM4-gCLcB\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-21.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"640\" src=\"https:\/\/3.bp.blogspot.com\/-I29X2_zgbsg\/VyuY8Z_xI0I\/AAAAAAAAB9c\/tcarn1qSG6MgnwD5kHvMuIX-XZavUM4-gCLcB\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2016-05-05%2B13-57-21.png\" width=\"492\" \/><\/a><\/div>\n<p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Esta es la versi\u00f3n 2.0.0 de Black-List utilizando una base de datos en PostgreSQL, aunque no sea mucha la diferencia con MySQL, ciertos m\u00e9todos y tipos de datos no son iguales o no se llaman igual. Por lo tanto me decid\u00ed a armar el mismo proyecto para ambos gestores de bases de datos. Esta versi\u00f3n [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[709,711,710,700,707,446,712,713,708],"tags":[],"class_list":["post-1629","post","type-post","status-publish","format-standard","hentry","category-bd","category-guardar-imagenes-en-bd","category-guardar-imagenes-en-postgresql-desde-java","category-imagenes","category-inputstream","category-java","category-pottgresql","category-retrieve-imagen-from-postgresql-on-java","category-save-image-in-postgresql"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=1629"}],"version-history":[{"count":0,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1629\/revisions"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=1629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=1629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=1629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}