Jdbc Jdbc Mysql CreateTable

User Comments

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

Current Comments

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

please give solution for that

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

View This Comment Separately

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

View This Comment Separately

you lessons is very great thanks

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

View This Comment Separately

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

View This Comment Separately

<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

View This Comment Separately

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();
}