Generador-procedimientos-almacenados-mysql - Genera procedimientos almacenados para MySQL - Por Nés

  •        0

Por Néstor Hernández Loli - Java Developer Este proyecto ha sido escrito en Java (mi primera contribución al software libre). Es simple lee las bases de datos de MySQL escoge una tabla y genera 5 procedimientos almacenados: para grabar (INSERT), actualizar (UPDATE), listar todos (SELECT), listar por código (SELECT) y borrar por código (DELETE). Gracias a todos los profesores del grupo IDAT en especial al Ingeniero Iván Petrlik y Carlos Jara, ellos me enseñaron las cosas magníficas que suceden cuando Open Source y talento se fusionan. Para realizar el mantenimiento a tablas mediante procedimientos almacenados el programador suele repetir las mismos códigos en diferentes escenarios por ejemplo para realizar un procedimiento de registro a la tabla Clientes y otro a la tabla Productos, la lógica es la misma, el escenario cambia. Con este programa se puede generar 5 procedimientos almacenados una para registrar (INSERT), para actualizar por código (UPDATE), para borrar por código (DELETE), consultar todos (SELECT) y consultar por código (SELECT). de una tabla seleccionada. Objetivos de este programa: Impulsar la investigación y desarrollo en software libre en el instituto IDAT, Agilizar la productividad del programador. Reinvindicar a Java en IDAT como lenguaje de programación de excelente nivel. Descarga ya la versión 1.2 del software. Clic en el zona 'Downloads', hay también una guía de usuario!celebra conmigo el lanzamiento de Java 7!No tienes Java Requerimientos de hardware y software Procesador Pentium II, Java instalado- JRE Créditos de software: Rsyntaxarea, apoyó con el resaltado de SQL, Substance y Trident animation gracias por el diseño visual de GUI, GNOME Icons gracias por los íconos Silviera Nieto gracias por la imagen del logo



Related Projects

Fast Code Eclipse Plugin

Fast Code Plugin is a free eclipse plugin designed to help write code faster in Java and Php applications. In Java, it has some special features for applications that uses the well known Spring Framework. It helps to generate code snippets based on fields from arbitrary pojo class or class from any package or files in folder, Generates database templates, Spring config files, Boiler plate classes, Junit test code and lote more.

Propel - smart easy object persistance in PHP

Propel is an open-source Object-Relational Mapping (ORM) for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. Propel uses PDO as an abstraction layer, and code generation to remove the burden of runtime introspection. Therefore Propel is fast.

NHibernate - object-relational mapper for .NET

NHibernate is a mature, open source object-relational mapper for the .NET framework. NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database.

Rainbow - portal development made easy

Rainbow CMS available today in 29 languages, allows content authoring to be safely delegated to role-based team members who need little or no knowledge of HTML. Rainbow optionally supports a two-step approval-publish process. 75 plug-in modules are now included in the standard release. It is also fairly easy to build your own custom modules.

MySQL Workbench - Visual database design tool for MySQL

MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

Monolog - Logging for PHP

Sends your logs to files, sockets, inboxes, databases and various web services from PHP. It can log to files and syslogs, Send alerts and emails, Log specific servers and networked logging, Log to databases and lot more.

ArgoUML - UML modeling tool

ArgoUML is the leading open source UML modeling tool and includes support for all standard UML 1.4 diagrams. It supports Class diagram, Statechart diagram, Activity diagram, Use Case diagram, Collaboration diagram, Deployment diagram and Sequence diagram. The diagram could be exported to GIF, PNG, PS, EPS, PGML and SVG. It generates code for Java, C++, C# and PHP. It also supports reverse engineering, generates code from diagram.

HyperGraphDB - Database for Storing Strongly-Typed Hypergraphs

HyperGraphDB is a general purpose, open-source data storage mechanism based on a powerful knowledge management formalism known as directed hypergraphs. While a persistent memory model designed mostly for Knowledge management, Artificial Intelligence and Semantic web projects, it can also be used as an embedded object-oriented database for Java projects of all sizes. It could also be used as graph database or as (non-SQL) relational database.


Avro is a data serialization system. It is a subproject of Apache Hadoop.

Berkeley DB - Embeddable Databases to Meet Your Needs

Oracle Berkeley DB provides the best open source embeddable databases allowing developers the choice of SQL, Key/Value, XML/XQuery or Java Object storage for their data model. At its core is a fast, scalable, transactional database engine with proven reliability and availability. Berkeley DB comes three versions: Berkeley DB, Berkeley DB Java Edition, and Berkeley DB XML.