Hi Friend,

The driver sun.java.odbc.jdbc.JdbcOdbcDriver is used with MS Access database.

If you want to use MS Access database then follow these steps:

1)Go to the start<<Control Panel<<Administrative Tools<< data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your server and run your jsp code.

Here is your required code:

<%@page import="java.sql.*"%>
<table border=1>
<tr><th>Name</th><th>Address</th></tr>

<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:student");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from data");
while(rs.next()){
    %>
    <tr><td><%=rs.getString("name")%></td><td><%=rs.getString("address")%></td></tr>
<%
}
rs.close();
st.close();
con.close();
}
catch(Exception e){}
%>
</table>

where student is our DSN.

If you want to use My sql database, then visit the following link:

http://www.roseindia.net/jsp/Accessingdatabase-fromJSP.shtml

http://www.roseindia.net/jsp/displaydatafrom_database1.shtml

Thanks

Thank you above question

my project on ticker system submition date is 28-02-2011 so plz help me continue

i want to validate registration of user from server side (JSP PAGE) so plz guide me for that. Give different logic.