Hi..
Step 6-In the left hand side click on tree of the project and src will be extract...
In src >com.client> there are 4 files
package com.client;
import com.google.gwt.user.client.rpc.RemoteService;
import com.google.gwt.user.client.rpc.RemoteServiceRelativePath;
/**
* The client side stub for the RPC service.
*/
@RemoteServiceRelativePath("greet")
public interface GreetingService extends RemoteService {
String check(String name,String password);
String newuser(String name,String password);
}
Code for GreetingServiceAsync.java
interface GreetingServiceAsync {void check(String name,String password, AsyncCallback<String> callback);void newuser(String name,String password,AsyncCallback<String> callback);
Step 6-In the left hand side click on tree of the project and src will be extract...
In src >com.client> there are 4 files
- loginpage
- Newuser
- GreetingService.java
- GreetingServiceAsync.java
package com.client;
import com.google.gwt.user.client.rpc.RemoteService;
import com.google.gwt.user.client.rpc.RemoteServiceRelativePath;
/**
* The client side stub for the RPC service.
*/
@RemoteServiceRelativePath("greet")
public interface GreetingService extends RemoteService {
String check(String name,String password);
String newuser(String name,String password);
}
Code for GreetingServiceAsync.java
interface GreetingServiceAsync {void check(String name,String password, AsyncCallback<String> callback);void newuser(String name,String password,AsyncCallback<String> callback);
com.client;
package
import
/**
* The async counterpart of
*/
<code>GreetingService</code>. public
void check(String name,String password, AsyncCallback<String> callback);
void newuser(String name,String password,AsyncCallback<String> callback);
}
interface GreetingServiceAsync { com.google.gwt.user.client.rpc.AsyncCallback;Step 7-
Open src > Com.Server >
Greeting ServiceImpl.java
Greeting ServiceImpl.java
package com.server;
import java.net.ConnectException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.client.GreetingService;
import com.google.gwt.user.client.Window;
import com.google.gwt.user.server.rpc.RemoteServiceServlet;
import com.google.gwt.user.client.Window;
import com.google.gwt.user.server.rpc.RemoteServiceServlet;
/**
* The server side implementation of the RPC service.
*/
@SuppressWarnings("serial")
public class GreetingServiceImpl extends RemoteServiceServlet implements
GreetingService {
Connection con=null;
Statement st=null;
ResultSet rs=null;
String url="jdbc:mysql://localhost:3306/mydb";
public void call()
{
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
System.out.print(e.getMessage());
}
try
{
con=DriverManager.getConnection(url, "root", "");
st=con.createStatement();
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
}
* The server side implementation of the RPC service.
*/
@SuppressWarnings("serial")
public class GreetingServiceImpl extends RemoteServiceServlet implements
GreetingService {
Connection con=null;
Statement st=null;
ResultSet rs=null;
String url="jdbc:mysql://localhost:3306/mydb";
public void call()
{
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
System.out.print(e.getMessage());
}
try
{
con=DriverManager.getConnection(url, "root", "");
st=con.createStatement();
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
}
@Override
public String check(String s1, String s2) {
// TODO Auto-generated method stub
String ss="no";
call();
try
{
rs = st.executeQuery("select * from login where name='" + s1 + "' and password='" + s2+"'" );
if(rs.next())
{
ss="yes";
System.out.println(rs.getString(0));
System.out.println(rs.getString(1));
}
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
return ss;
}
public String check(String s1, String s2) {
// TODO Auto-generated method stub
String ss="no";
call();
try
{
rs = st.executeQuery("select * from login where name='" + s1 + "' and password='" + s2+"'" );
if(rs.next())
{
ss="yes";
System.out.println(rs.getString(0));
System.out.println(rs.getString(1));
}
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
return ss;
}
@Override
public String newuser(String name, String password) {
public String newuser(String name, String password) {
String ss = "no";
call();
try
{
boolean ss1;
ss1 = st.execute("insert into login values('" + name+"','"+ password +"')");
if(ss1)
{
ss="yes";
}
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
call();
try
{
boolean ss1;
ss1 = st.execute("insert into login values('" + name+"','"+ password +"')");
if(ss1)
{
ss="yes";
}
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
return ss;
}
}
Step 8-
}
}
Step 8-
- Install MYSQL and start its all services
- mysql cmd>create database mydb;
- cmd > cretae table login(name varchar(20),password varchar(20));
- insert into login values('vishal','myprogram');
- insert into login values('sonal','helloworld');
Hence now the program is complete and u can us it for database connectivity.
Thank you,
SONAL GARG
VISHAL DIXIT
3 June 2011 at 04:15
[ERROR] javax.servlet.ServletContext log: Exception while dispatching incoming RPC call
com.google.gwt.user.server.rpc.UnexpectedException:
I got the above problem, can any one suggest for exception?
30 January 2012 at 17:53
on the GreetingServiceAsync.java, how do you build it up coz everytime I replace the code with your given code, I got an error that saying
ERROR:
Multiple markers at this line
- Syntax error on token "void", @ expected
- Syntax error on tokens, delete these tokens
- Syntax error on token "String", = expected after this
token
- Syntax error on token "String", = expected after this
token
- Syntax error on token "<", = expected
30 January 2012 at 17:55
this is the setup of my code for GreetingServiceAsync.java:
package
import
/**
* The async counterpart of
*/
public void check(String name,String password, AsyncCallback callback);
void newuser(String name,String password,AsyncCallback callback);
}
interface GreetingServiceAsync {void check(String name,String password, AsyncCallback callback);void newuser(String name,String password,AsyncCallback callback);
}
15 May 2013 at 02:11
Hello, please can you tell me what's "greet" in @RemoteServiceRelativePath("greet") coz i have jetty 404 error greet is not found thanks.