[appengine-java] how to do jdbc in eclipse

[bhagya laxmi]

hi
iam very new to this google apps
i know  how to deploy application.

can you please guide me how to do jdbc part using mysql .
i want to create database ,tables and i also want to do CURD
operation.
its very urgent.
i add this code to tomact
grant codeBase "file:${catalina.home}/webapps/-" {
      permission java.net.SocketPermission "192.168.12.81:3306",
"connect";
};


this is my code:

Connection conn     = null;
String url          = "jdbc:mysql://192.168.12.81:3306/";
String db           = "First";
String driver       = "com.mysql.jdbc.Driver";
String user         = "";
String pass         = "";



try {
    Class.forName(driver).newInstance();
} catch (InstantiationException e) {
        out.println(e);
    e.printStackTrace();
} catch (IllegalAccessException e) {
        out.println(e);
    e.printStackTrace();
} catch (ClassNotFoundException e) {
        out.println(e);
    e.printStackTrace();
}
try {

            conn = DriverManager.getConnection(url+db, user, pass);
             PreparedStatement pst=conn.prepareStatement("create table
testbhagya(name varchar(20))");

            int i=pst.executeUpdate();
            out.println("table created"+i);
            PreparedStatement pst1=conn.prepareStatement("insert into
testbhagya values('laxmi')");


            int j=pst1.executeUpdate();
            out.println("insert"+i);
            PreparedStatement pst2=conn.prepareStatement("select *
from tab");

            ResultSet rs=pst2.executeQuery();
            while(rs.next())
            {
                out.println(rs.getString(1));
            }

} catch (Exception e) {
        out.println(e);
            System.err.println("Mysql Connection Error: ");
    e.printStackTrace();
}


i am getting error.
what is wrong.
Thanks and Regards
Bhagya..

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.