aspose file tools*
The moose likes Web Services and the fly likes how to show database table with webservice? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "how to show database table with webservice?" Watch "how to show database table with webservice?" New topic
Author

how to show database table with webservice?

sahar zare
Greenhorn

Joined: Jun 16, 2010
Posts: 3
hello
i want to retrive database table as service in java
i use Resultset,but give error it
error is:C:\Users\Documents\NetBeansProjects\QAProject1\nbproject\build-impl.xml:553: The module has not been deployed.
this problem is related to the following location:
at javax.servlet.jsp.jstl.sql.Result
at private javax.servlet.jsp.jstl.sql.Result servicepac.jaxws.ShowOpenResponse._return
at servicepac.jaxws.ShowOpenResponse

[cod]

@WebService()
public class qaservice {





Logic obj=new Logic();
@WebMethod(operationName="showOpen")
public Result showOpen(){
Result res=obj.showOpenq();
return res;
}
}



//--------------
public class Logic {
DB db=new DB("localhost","testqa",3306,"root","123");

public Logic(){}
public Result showOpenq() {
db.connect();
String sql="SELECT * FROM questions where openq=true";
//sql=String.format(sql);
Result rs=db.ShowOpenq(sql);
db.disConnect();
return rs;
}
}
//--------------------
/---------------------

public class DB {

public String serverName;
public String dbName;
public int port;
public String userName;
public String passWord;

private Connection connection;
private Statement st;

public DB(String serverName,String dbName, int port, String userName,String passWord) {

this.serverName = serverName;
this.dbName = dbName;
this.port = port;
this.userName=userName;
this.passWord=passWord;

try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception e) {
System.err.println(e.getMessage());
}
}

public void connect(){
try {
String url = "jdbc:mysql://"+serverName+":"+port+"/"+dbName;
connection = DriverManager.getConnection(url,userName,passWord);
st = connection.createStatement();
} catch (Exception e) {
System.err.println(e.getMessage());
}
}

public void disConnect(){
try {
st.close();
connection.close();
} catch (Exception e) {
System.err.println(e.getMessage());
}
}

public Result ShowOpenq(String sql){
try {
st.executeQuery(sql);
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
ResultSet rs = null;
try {
rs = st.executeQuery(sql);
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
Result res= ResultSupport.toResult(rs);
try {
rs.close();
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}


return res;}
} [/code]
excuseme as bad english.
Peter Taucher
Ranch Hand

Joined: Nov 18, 2006
Posts: 174
Please UseCodeTags and TellTheDetails because 'it can not deploy' is not a valid problem description.


Censorship is the younger of two shameful sisters, the older one bears the name inquisition.
-- Johann Nepomuk Nestroy
 
Consider Paul's rocket mass heater.
 
subject: how to show database table with webservice?