Free Jobs
Reference




Java Forums: Core Java (15) J2EE (3) EJB (5) Servlet (3) JDBC (6) Hibernate (2) Struts (1) Swing (1) Oracle (7) JSP (4) Other (10)

Topic: How to write a general code for creating a table in Database using JDBC in Java

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share





User: shruti888 Post Date: 05 Jun 2011 11:11

Introduction:
This is a general requirement to create a table in database using using JDBC in Java



Main Content:

In this post I am providing a syntax to to write a general code for creating

a table in Database using JDBC in Java




try

{

Connection MyConn = DriverManager.getConnection(dbURL,myUSERNAME,myPASSWORD);

Statement myStatement = MyConn.createStatement();

myStatement.execute("Create Table MyTable (ID int,Name varchar(50),age int)");

myStatement.Close();

MyConn.Close();

}

catch(Exception ex)

{

//handle exception

}



Conclusion:
Thus we learned a general code for creating a table in Database using JDBC in Java



About Writer:
Hi I am Java Developer from Bangalore


Writer's Link:

Writer's Email:







Comments:
Post Comment





Similar Articles Top ArticlesLatest Articles Other Articles by this Author







www.freejobsreference.com Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)