con.createStatement() does not work

hi all

when i try to connect MSSQL 2000 server using JDBC Connection, the method createStatement() does not work. I import all the necessary java libraries also.

here is my sample program which didn't work.

import java.sql.*;

public class JDBCCon

{

public static void main (String[] args)

{

String conUrl = "jdbc:sqlserver://localhost:1433;databaseName=JavaDB;user=;password=";

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

try

{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con = DriverManager.getConnection(conUrl);

String str = "SELECT * FROM USER";

stmt = con.createStatement();

}catch (Exception ex) {}

}}

in here con.createStatement(); is not working, it gives me a error. Please help me.

Thankz

[877 byte] By [Sana_Boya] at [2007-11-27 6:26:07]