Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases and the fly likes a easy question   please help !!! 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 "a easy question   please help !!!" Watch "a easy question   please help !!!" New topic

a easy question please help !!!

David Liu

Joined: Apr 16, 2002
Posts: 24
how can I access microsoft access2000 in jsp
this is my code
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
sqlRst=sqlStmt.executeQuery("select name,age from people");
<title>JDBC ACCESS 测试<title>
<table border="1" cellspacing="0" align="center">

but tomcat says "no suitable driver"

It's better burn out than to fade away.
Janet Wilson
Ranch Hand

Joined: Jul 16, 2002
Posts: 98
I'm sure you figured out an answer to your question and I'm not even certain this will help you out since it's Java and not JSP, but figured I would share some beginner code I have been creating for a training plan which might give you some pointers? The following code does successfully attach to an Access 2000 DB from within JDK 1.4.1 using a User DSN:

Remember, it's meant as a training tool! Hope this helps!
Have you tried LearnNowOnline?
subject: a easy question please help !!!