Comment on Tutorial - JSP Example to connect to MS SQL database and retrieve records By Abinaya



Comment Added by : sillee

Comment Added at : 2009-08-13 03:22:14

Comment on Tutorial : JSP Example to connect to MS SQL database and retrieve records By Abinaya
i'm a student and new to all these HTML and JSP.
i want to learn to do this Tomcat with Ms SQL where my Uni only provide us these resources. i've tried to copy the above codes and past to my Tomcat and tried to run, i can only get the junk text as below:
May i know what are the installation needed?
can any1 suggest on how to start from installing all the application to connecting them.
I'm using Windows based OS,
i got Ms SQL Server 2005 Studio Express installer,
i got Apache Tomcat 5.5.27 Server installer.
what are the necessary configuration needed to run these server application on my PC (i'm testing with my PC as server at the moment).

can any1 pls help~

<%@ page import="java.util.*" %> <%@ page import="javax.sql.*;" %> <% java.sql.Connection con; java.sql.Statement s; java.sql.ResultSet rs; java.sql.PreparedStatement pst; con=null; s=null; pst=null; rs=null; // Remember to change the next line with your own environment String url= "jdbc:jtds:sqlserver://research.utar.edu.my/ResearchPortal"; String id= "username"; String pass = "password"; try{ Class.forName("net.sourceforge.jtds.jdbc.Driver"); con = java.sql.DriverManager.getConnection(url, id, pass); }catch(ClassNotFoundException cnfex){ cnfex.printStackTrace(); } String sql = "select top 10 * from tbl_sys_user"; try{ s = con.createStatement(); rs = s.executeQuery(sql); %> <% while( rs.next() ){ %><% } %> <% } catch(Exception e){e.printStackTrace();} finally{ if(rs!=null) rs.close(); if(s!=null) s.close(); if(con!=null) con.close(); } %>
<%= rs.getString("cust_id") %> <%= rs.getString("rdate") %> <%= rs.getString("email") %>


View Tutorial



Subscribe to Tutorials

Related Tutorials

Program using concept of byte long short and int in java

Update contents of a file within a jar file

Tomcat and httpd configured in port 8080 and 80

Java File

Java String

Count number of vowels, consonants and digits in a String in Java

Reverse a number in Java

Student marks calculation program in Java

Handling Fractions in Java

Calculate gross salary in Java

Calculate average sale of the week in Java

Vector in Java - Sample Program

MultiLevel Inheritance sample in Java

Multiple Inheritance sample in Java

Java program using Method Overriding

Archived Comments

1. Actually i had downloaded all the files but it thr
View Tutorial          By: bornwithpowers at 2009-11-11 04:48:21

2. I agree with #2 u are missing that line
View Tutorial          By: ויזה לארה"ב at 2011-10-26 10:39:50

3. Hi there,
this doesnt work in IE7 or firefo

View Tutorial          By: Gerrard at 2009-10-17 15:19:24

4. Hello sir pls send me
com.sun.speech.freett

View Tutorial          By: sana at 2011-12-23 16:16:24

5. This is helpful for newbies like me :P
View Tutorial          By: Mustafa at 2011-06-18 23:40:27

6. how to multiply 2.54*0.7071 using only bitwise ope
View Tutorial          By: vindya at 2012-01-12 07:23:08

7. it giving me error in following statment (using wi
View Tutorial          By: prathamesh at 2007-03-16 05:57:20

8. Does your Siemens CX75 can show up as COM port dev
View Tutorial          By: mchon at 2008-10-10 18:24:11

9. I get this error:
Can someone please help m

View Tutorial          By: Carlos at 2010-06-14 02:42:53

10. voire pluse a des command java
View Tutorial          By: lahcine moubarek at 2009-02-16 01:59:17