小弟尝试着用myeclipse生成web service,但总是报Unable to create JAXBContext错误
package org.course.design.bean;public class Customer {
private String cid; //客户编号
private String from; //查询起始日期
private String to; //查询截止日期 public Customer(String cid, String from, String to) {
super();
this.cid = cid;
this.from = from;
this.to = to;
}
public String getCid() {
return cid;
} public void setCid(String cid) {
this.cid = cid;
} public String getFrom() {
return from;
} public void setFrom(String from) {
this.from = from;
} public String getTo() {
return to;
} public void setTo(String to) {
this.to = to;
}}
package org.course.design.bean;public class Sale {
private String cid;
private String gid;
private String salesTime;
private int goodsCount; public String getCid() {
return cid;
} public void setCid(String cid) {
this.cid = cid;
} public String getGid() {
return gid;
} public void setGid(String gid) {
this.gid = gid;
} public String getSalesTime() {
return salesTime;
} public void setSalesTime(String salesTime) {
this.salesTime = salesTime;
} public int getGoodsCount() {
return goodsCount;
} public void setGoodsCount(int goodsCount) {
this.goodsCount = goodsCount;
}
}
package org.course.design.webservice;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;import org.course.design.bean.Customer;
import org.course.design.bean.Sale;public class QueryFun {
// 输入客户对象,查询数据库,返回一个销售记录集合
public List<Sale> query(Customer c){
//查询语句
String queryString = "select * from sale where cid='"+c.getCid()+"'";
//对起始日期和截止日期进行处理,仅当二者皆不为空的时候进行结合查询,否则只进行客户编号查询
if(!c.getFrom().equals("") && !c.getTo().equals("")){
queryString = queryString + " and salesTime between '" + c.getFrom()
+ "' and '" + c.getTo() + "'";
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
List<Sale> sales = new ArrayList<Sale>();
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/xmlcoursedesign", "root", "333333");
stmt = conn.createStatement();
rs = stmt.executeQuery(queryString);
while (rs.next()) {
Sale s = new Sale();
s.setCid(rs.getString("cid"));
s.setGid(rs.getString("gid"));
s.setSalesTime(rs.getString("salesTime"));
s.setGoodsCount(rs.getInt("goodsCount"));
sales.add(s);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}finally{
try{
if(rs != null)
rs.close();
if(stmt != null)
stmt.close();
if(conn != null)
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
return sales;
}
}
求有经验的哥哥帮手....
package org.course.design.bean;public class Customer {
private String cid; //客户编号
private String from; //查询起始日期
private String to; //查询截止日期 public Customer(String cid, String from, String to) {
super();
this.cid = cid;
this.from = from;
this.to = to;
}
public String getCid() {
return cid;
} public void setCid(String cid) {
this.cid = cid;
} public String getFrom() {
return from;
} public void setFrom(String from) {
this.from = from;
} public String getTo() {
return to;
} public void setTo(String to) {
this.to = to;
}}
package org.course.design.bean;public class Sale {
private String cid;
private String gid;
private String salesTime;
private int goodsCount; public String getCid() {
return cid;
} public void setCid(String cid) {
this.cid = cid;
} public String getGid() {
return gid;
} public void setGid(String gid) {
this.gid = gid;
} public String getSalesTime() {
return salesTime;
} public void setSalesTime(String salesTime) {
this.salesTime = salesTime;
} public int getGoodsCount() {
return goodsCount;
} public void setGoodsCount(int goodsCount) {
this.goodsCount = goodsCount;
}
}
package org.course.design.webservice;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;import org.course.design.bean.Customer;
import org.course.design.bean.Sale;public class QueryFun {
// 输入客户对象,查询数据库,返回一个销售记录集合
public List<Sale> query(Customer c){
//查询语句
String queryString = "select * from sale where cid='"+c.getCid()+"'";
//对起始日期和截止日期进行处理,仅当二者皆不为空的时候进行结合查询,否则只进行客户编号查询
if(!c.getFrom().equals("") && !c.getTo().equals("")){
queryString = queryString + " and salesTime between '" + c.getFrom()
+ "' and '" + c.getTo() + "'";
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
List<Sale> sales = new ArrayList<Sale>();
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/xmlcoursedesign", "root", "333333");
stmt = conn.createStatement();
rs = stmt.executeQuery(queryString);
while (rs.next()) {
Sale s = new Sale();
s.setCid(rs.getString("cid"));
s.setGid(rs.getString("gid"));
s.setSalesTime(rs.getString("salesTime"));
s.setGoodsCount(rs.getInt("goodsCount"));
sales.add(s);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}finally{
try{
if(rs != null)
rs.close();
if(stmt != null)
stmt.close();
if(conn != null)
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
return sales;
}
}
求有经验的哥哥帮手....
解决方案 »
- 监听电脑键盘按下哪个键,最好是java的
- spring+quartz下诡异的错误,不知道和quartz有没有关系
- java正则表达式问题(高分急求-雪地跪求)
- lomboz-all-in-one-R-3.3在下面Window-->Preference下不能看到Lomboz
- struts中关于form表单调用javascript(在线等)
- 谁给提供个求数组平均值的代码
- jfreechart问题 大侠帮忙解决 谢谢
- jboss更改jsp都需要重新启动服务器
- 怪,我直接建一个index.jsp页出也会出错
- 我做的第一个hibernate映射,出错了,大家帮我看下,有详细的说明
- SSH2 脏话过滤
- webservice 在was部署和在tomcat部署生成的wsdl文件字段顺序不一致
哎,终于搞好了!
我的查数据的只有一个类,没有那些有get、set的类