hi,
when i run a java program for to store data and retrive using mysql datatabse i got the following errors.I think in that one of error is due to set the class path.I placed my mysql-connector-java-3.0.11-stable-bin jar in lib directory.What is the command to set a classpath in windows for java mysql connectivity.plz tell that .And also how i avoid these errors.
[java]
import java.sql.*;
import java.util.*;
import java.net.*;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
class Test
{
public static void main(String args[])
{
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
//dbCon = DriverManager.getConnection("jdbc:mysql://194.230.33.43/databasename", "phoneliv_root", "root");
dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/DataMiningdb","root","root");
Connection dbCon;
ResultSet rsGroups;
Statement stmtSql;
String strSql="", strToMobileNo = "", strMemberName = "", groupId = "";
/*
** The Statement enables the resultset obtained from it to be scrollable and read only.
*/
stmtSql = dbCon.createStatement(ResultSet.TYPE_SCROLL_INSENS ITIVE, ResultSet.CONCUR_READ_ONLY);
/*
** The List of the groups are retrieved and displayed.
*/
stmtSql = dbCon.createStatement(ResultSet.TYPE_SCROLL_INSENS ITIVE, ResultSet.CONCUR_READ_ONLY);
strSql = "Select * from vehicles";
rsGroups = stmtSql.executeQuery(strSql);
while(rsGroups.next()){
strMemberName = rsGroups.getInt("vehicle_id");
strToMobileNo = rsGroups.getString("vehicle_stockno");
groupId = rsGroups.getString("vehicle_make");
}
System.out.println("strToMobileNo");
System.out.println("strMemberName");
System.out.println("groupId");
}
}
[/java]
errors :
C:\j2sdk1.4.0\bin>javac dbcon.java
dbcon.java:15: cannot resolve symbol
symbol : variable dbCon
location: class Test
dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/DataMiningdb","root
","root");
^
dbcon.java:32: incompatible types
found : int
required: java.lang.String
strMemberName = rsGroups.getInt("vehicle_id");
^
2 errors
plz help me.