Sun also has a tutorial that covers the basics of using JDBC for DB access
that you might find helpful:
http://www.java.sun.com/docs/books/tutorial/jdbc/index.html
-----Original Message-----
From: Daryani Santosh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 1:29 PM
To: [EMAIL PROTECTED]
Subject: Re: Asking sample on JSP to access the SqlServer Database
import java.sql.*;
public class dataExtract
{
public static void main (String args [])
{
try{
Statement sqlStmt;
String userid;
String password;
ResultSet resultSet;
userid = "userid";//hard code or get it from arguments
password = "password";//hard code or get it from arguments
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbConn =
DriverManager.getConnection("jdbc:odbc:ODBCdsnName);//substitute ODBCdsnName
//with anem of your dsn
sqlCmd = "SELECT * FROM whatever table";
sqlStmt = dbConn.createStatement();
resultSet = sqlStmt.executeQuery(sqlCmd);
Santosh
"Zhang, David" <[EMAIL PROTECTED]> on 01/24/2001 03:59:16 PM
Please respond to A mailing list about Java Server Pages specification and
reference <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Santosh Daryani/IT/Aon Consulting)
Subject: Asking sample on JSP to access the SqlServer Database
Hi all,
I am new at JSP. I want use JSP to access the SqlServer Database (I have set
the ODBC)
please point me to some JSP samples on this .
Thanks
Dave
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
