learn java
The moose likes JDBC and Relational Databases and the fly likes Connection with database... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection with database..." Watch "Connection with database..." New topic

Connection with database...

yunuss khan

Joined: Apr 22, 2006
Posts: 17
Hi All,

I want to retreive records from database but i have one problm in the below Code where should i pass my Server name and Database name..because my data is on server not on my local database..in below code "Data" is my database name and "Cust" is my tablename..

Pls help.....

<%@ page import="java.sql.*" %>

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

<TITLE>Selecting tableName From a Database</TITLE>

<H1>Selecting tableName From a Database</H1>

Connection connection = DriverManager.getConnection(
"jdbcdbc:data", "userName", "password");

Statement statement = connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from cust where city = 'Boston'") ;

<% while(resultset.next()){ %><TR>
<TD> <%= resultset.getString(1) %></td>
<TD> <%= resultset.getString(2) %></TD>
<TD> <%= resultset.getString(3) %></TD>
<TD> <%= resultset.getString(4) %></TD>
<TD> <%= resultset.getString(5) %></TD>
<% } %>

Thanks & Regards,
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

Originally posted by yunuss khan:

hi yunus,

A database on a remote server requires more information, however. If the database is to be accessed over the Internet, for example, the network address should be included in the JDBC URL as part of the parameter.

[ December 08, 2006: Message edited by: Saif uddin ]

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
I agree. Here's the link: http://aspose.com/file-tools
subject: Connection with database...