hi guys, i am newbie, i have following code

AppletOne.java

[Code]
import java.sql.*;
import javax.swing.*;
import Package_DB.*;

public class AppletOne extends JApplet {

/**
*
*/
private static final long serialVersionUID = 1L;
private Connection connection;
ConnectToDB objConnectToDB = new ConnectToDB();

public void init() {
GetData();
}

private void GetData() {
try {
connection = objConnectToDB.GetConnection("localhost:3306", "test",
"root", "root@123");
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (Throwable e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

String listOfNames = "";
try {
listOfNames = GetaDataFromMySQLDataBase();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JOptionPane.showMessageDialog(null, listOfNames);
}

private String GetaDataFromMySQLDataBase() throws SQLException {
String query = "SELECT * FROM test.test";
String listOfNames = objConnectToDB.GetDataAsString(connection, query);
return listOfNames;
}
}
[Code]

and

a package

[Code]
package Package_DB;

import java.sql.*;

public class ConnectToDB {
private Connection connection;

public static void main(String args[]) {
System.out.print("asdasd");
// JOptionPane.showMessageDialog(null,"listOfNames");
}

public Connection GetConnection(String server, String database,
String userName, String password) throws InstantiationException,
Exception, Throwable {

try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://" + server
+ "/" + database + "?user=" + userName + "&password="
+ password);
return connection;
} catch (SQLException e) {
// return e.getMessage();
return connection;
}

}

public String GetDataAsString(Connection connection, String query)
throws SQLException {
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(query);
String lastName = "";
while (rs.next()) {
lastName += rs.getString("Name") + ",";
}
rs.close();
return lastName;
}
}

[Code]


while running in a eclipse, i got the data from mySQL database.. but in through command prompt i am getting following error

C:\Users\Srihari\workspace\exp1\src>javac AppletOne.java

C:\Users\Srihari\workspace\exp1\src>java AppletOne
Exception in thread "main" java.lang.NoSuchMethodError: main

C:\Users\Srihari\workspace\exp1\src>

and


C:\Users\Srihari\workspace\exp1\src>appletviewer AppletOne.html
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:211)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.applet.AppletClassLoader.loadClass(AppletClassLoader.java:144)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at Package_DB.ConnectToDB.GetConnection(ConnectToDB.java:18)
at AppletOne.GetData(AppletOne.java:20)
at AppletOne.init(AppletOne.java:15)
at sun.applet.AppletPanel.run(AppletPanel.java:424)
at java.lang.Thread.run(Thread.java:662)
java.lang.NullPointerException
at Package_DB.ConnectToDB.GetDataAsString(ConnectToDB.java:32)
at AppletOne.GetaDataFromMySQLDataBase(AppletOne.java:45)
at AppletOne.GetData(AppletOne.java:35)
at AppletOne.init(AppletOne.java:15)
at sun.applet.AppletPanel.run(AppletPanel.java:424)
at java.lang.Thread.run(Thread.java:662)

C:\Users\Srihari\workspace\exp1\src>


and my html page look like

<html>
<applet code="AppletOne.class" width="500" height="200"></applet>
</applet>
</html>

i 've windows7 OS and 've only java path..

but in eclipse i added mysql-connector-java-5.1.6.jar as reference..


please help me in this...