SQL Example To Create Table On MySql DB

This is a very basic script that creates a table in the database. This has been tested to work with mysql, but similar format can be applied to other databases such as MS SQL Server, Oracle, IBM DB2 etc.

Here is the database schema that we want to create:

The code to create this table is:

CREATE TABLE KP_BANK_PYMT_INFO(
	INFO_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	BANK_NAME VARCHAR(100),
	CURRENT_BAL DECIMAL(5,2),
	PYMT_DUE_DT TIMESTAMP DEFAULT NOW()
	LAST_PYMT_AMT DECIMAL(5,2).
	LAST_PAID_DT TIMESTAMP,
	APR DECIMAL (3,2),
	REMARKS VARCHAR (100)
)

  1. All About Java Garbage Collection : Types, Algorithms, Advantages and Disadvantages
  2. Java Static Import Explained With Easy Example With Source Code
  3. SQL Example To Create Table On MySql DB
  4. Book Review – Drools JBoss Rules 5.X Developer’s Guide by Micahal Bali (Packt Publishing)
  5. List of valid @suppresswarning annotation parameters in Java for Eclipse and IBM RAD IDE
  6. Finding Java System Properties
  7. List of Major Java 7 Features – How java programming language has changed in JDK 7
  8. Date From Timestamp in Long format
  9. How to resolve – java.lang.VerifyError java.lang.SecurityException: Signers of org.junit.runner.Runner do not match signers of other classes in package
  10. Complete List Of Java Keywords
  11. List of 25 Plus Devices That Run On Java
  12. What is the difference between java and javaw?
  13. These 100 plus programming languages run on Java Virtual machine (List)
  14. Read XML File In JAVA using DOM – A Simple Tutorial
Tagged , , , , , , , , , , , , . Bookmark the permalink.

4 Responses to Read XML File In JAVA using DOM – A Simple Tutorial

  1. harry says:

    I need a tutorial on an exact opposite of this excellent article. That is I need to serialize Java Object to XML. Can you help me in that Kushal??? I wud appreciate it a lot.

    Thanks

  2. Jim says:

    Hey Kushal!
    This is very great and helpful, but I got another question about that. If I have an Element which hasn’t any values, I always get a NullpointerException. Do you have an Idea how to fix/catch that?

    Thank you!

  3. Mridula says:

    The advantage in Java is that there it is not necessary to take care of objects which are no longer used. Garbage collector takes care of these objects unlike C/C++ language where because of this issue the program terminates causing OutOfMemoryErrors.

Leave a Reply

Your email address will not be published. Required fields are marked *