Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Spring Framework | Web Services | BioInformatics | Java Server Faces | Jboss 3.0 tutorial | Hibernate 3.0 | XML

Tutorial Categories: Ajax | Articles | JSP | Bioinformatics | Database | Free Books | Hibernate | J2EE | J2ME | Java | JavaScript | JDBC | JMS | Linux | MS Technology | PHP | RMI | Web-Services | Servlets | Struts | UML


 

Java Tutorials


 

 

Struts Tutorials

Struts Resources

Visit Forum! Post Questions!
Jobs At RoseIndia.net!

Jdbc Jdbc Mysql CreateTable

User Comments
Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl
  Blink   Furl   Simpy   Y! MyWeb 

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 

Current Comments

16 comments so far (post your own) View All Comments Latest 10 Comments:

really ROSE INDIA.NET is very useful to the beginners of java programmers really its a good web site


thank you

Posted by rama krishna rao on Saturday, 04.3.10 @ 16:12pm | #96095

hello..
how to update student profile based on jsp application?

Posted by srikanth on Monday, 03.29.10 @ 21:49pm | #95954

hello.....



how to create servlet program for displaying student profile based on hallticket number
?



Posted by srikanth on Monday, 03.29.10 @ 21:47pm | #95953

i like this tutorial

Posted by rohan on Monday, 08.31.09 @ 02:54am | #90435

providing good help to developers keep it up....!

Posted by shailesh on Friday, 01.30.09 @ 05:59am | #84322

it is very easy to understand

Posted by arun on Tuesday, 01.6.09 @ 00:03am | #83506

This tutorial is shit, what sort of shit head wrote this price of crap

Posted by ur kidding right on Thursday, 11.20.08 @ 04:21am | #81848

I get this error when trying to run this code, but I got the create database code to work:

Exception in thread "main" acm.util.ErrorException: Cannot determine the main class.
at acm.program.Program.main(Program.java)

Posted by bigman on Friday, 10.24.08 @ 09:51am | #81284

please give solution for that

Posted by syeddiwan on Tuesday, 03.18.08 @ 16:07pm | #53175

can you please tell me how to create a table when there is Sybase Database

Posted by john on Tuesday, 03.18.08 @ 06:00am | #53060

now i've found a good tutorial on jdbc.
definitly this type of tutorial is going to be
master in java step by step.

Posted by pankaj on Saturday, 02.2.08 @ 07:25am | #46935

you lessons is very great thanks

Posted by mustafa on Tuesday, 11.13.07 @ 09:00am | #37167

Respected!
Would u like to tell me how i can create the table in MS Access, where i have to make changing in the previous example of cretating a table in mysql
regards

Posted by m masoom on Sunday, 09.23.07 @ 01:14am | #28883

<html>
<head>
<%@ page
import = "java.io.*"
import = "java.lang.*"
import = "java.sql.*"
%>
<title>
JSP Example 2
</title>
</head>
<body>
<h1>JSP Example 3</h1>
<%
String place;
Connection dbconn;
ResultSet results;
PreparedStatement sql;
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
try
{
int latitude,longitude,easting,northing;
boolean doneheading = false;


out.println("Suyog before connection");

dbconn = DriverManager.getConnection("jdbc:mysql::/localhost:8080/LA/employee","","");
out.println("Suyog database");
// place = request.getParameter("place");
sql = dbconn.prepareStatement("SELECT * FROM employee");
results = sql.executeQuery();
while(results.next())
{
if(! doneheading)
{
out.println("<table border=2>");
doneheading = true;
}
latitude = results.getInt("latitude");
longitude = results.getInt("longitude");
easting = results.getInt("easting");
northing = results.getInt("northing");
out.println("<tr><td>" + latitude);
out.println("<td>" + longitude);
out.println("<td>" + easting);
out.println("<td>" + northing);
}
if(doneheading)
{
out.println("</table>");
}
else
{
out.println("No matches for ");
}
}
catch (SQLException s)
{
out.println("SQL Error<br>");
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>
</body>
</html>

Posted by suyoh on Saturday, 09.15.07 @ 12:06pm | #27017

how can using statement and create statement


public static void main(String args[]) {
System.out.println("Table Creation Example!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "rameshdb";
String driverName = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
try{
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(url+dbName, userName, password);
try{
Statement st = con.createStatement();
String table = "CREATE TABLE Employee11(Emp_code integer, Emp_name varchar(10))";
st.executeUpdate(table);
System.out.println("Table creation process successfully!");
} catch(SQLException s){
System.out.println("Table all ready exists!");
}
con.close();
} catch (Exception e){
e.printStackTrace();
}

Posted by ramesh on Friday, 07.27.07 @ 16:31pm | #22055

This is the best tutorial i have come through.

Posted by Thatayaone on Sunday, 03.4.07 @ 19:33pm | #10639

Ask programming questions?

 

 

Back to Tutorial

 

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification

Tell A Friend
Your Friend Name

 

 
Browse all Java Tutorials
Java JSP Struts Servlets Hibernate XML
Ajax JDBC EJB MySQL JavaScript JSF
Maven2 Tutorial JEE5 Tutorial Java Threading Tutorial Photoshop Tutorials Linux Technology
Technology Revolutions Eclipse Spring Tutorial Bioinformatics Tutorials Tools SQL
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright 2007. All rights reserved.