this is my code
public class test extends JApplet
{
public test()
{
}
Connection conn = null;
Statement stmt;
boolean flag;
public boolean connect(String url, String userName, String password)
{
try
{
//Step:1
System.out.println("JDBC Test" );
Class.forName("com.mysql.jdbc.Driver").newInstance();
//Step:2
conn = DriverManager.getConnection (url, userName, password);
System.out.println ("Database connection established->"+ conn);
JOptionPane.showMessageDialog(null,"Connected...");
stmt = conn.createStatement();
// retrive d data...
ResultSet rs = stmt.executeQuery("select * from player");
while(rs.next())
{
System.out.print("id."+ rs.getString(1));
System.out.println("->Name:"+ rs.getString(2));
}
stmt.close();
flag = true;
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server" + e);
flag = false;
}
finally
{
if (conn != null)
{
try
{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) { }
}
}
return flag;
}
// public static void main (String[] args)
public void init()
{
String db_name = "test";
String url = "jdbc:mysql://10.0.2.76/"+db_name;
String userName = "root";
String password = "root";
boolean flag;
test t = new test();
flag = t.connect(url,userName,password);
System.out.println("Flag:"+ flag);
}
} //end class
