Doubt on insert statement in JDBC!!

[dhwani mathur]

Hi all

i am trying to take user input in my
program but later i want to pass this to
the insert statement but everytime i am getting
an error.below is my code

Connect.java class

   import java.sql.*;
 
public class Connect
{
static String name,emailadd,passw;
public Connect(String Firstname,String Emailid,String Pass)
{

this.name=Firstname;
this.emailadd=Emailid;[B]//these are the instance variables[/B]this.passw =Pass;

}

public static void main(String args[]) throws SQLException,ClassNotFoundException
{
Connect cn=new Connect("dhwani","abcd","mathur");
String sql="insert into userinfo values(name,emailadd,passw)";[B]//i am getting error in this line since 
//here i am passing instance variables which will get value from constructor of class ie user input[/B]
System.out.println("just try");
try
{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:information");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
}
catch(SQLException e)
{
e.printStackTrace();
}
}



}
 

please if anyone can help on this
to what is going wrong in program it
will be great...............


thanks in advance..........

Dhwani:>Swimmers never weep.

[Paul Sturrock]

A couple of questions: what is the error you are seeing? And why are you using the jdbcdbc bridge? (is Access your database?)

[dhwani mathur]

hi


My server is SQL and i am getting compiler error
in Eclipse.

[Paul Sturrock]

My server is SQL

Do you mean Microsoft SQL Server? In which case you should use jTDS or their own JDBC driver.

i am getting compiler error

...and what is that compiler error?