gwt ext 连接MySql数据库

最新推荐文章于 2024-10-17 15:56:31 发布

behappy373

最新推荐文章于 2024-10-17 15:56:31 发布

阅读量3.8k

点赞数 2

文章标签： gwt mysql ext string exception service

本文链接：https://blog.csdn.net/behappy373/article/details/5138875

版权

该连接方式采用RPC来返回数据库查询结果。

1.首先是创建普通的GWT-EXT工程。可以参考1http://www.ibm.com/developerworks/cn/java/j-lo-gwtext1/#resources

系列入门教程。具体通讯过程服务也可参考上述的最后部分说明。

2. 接下来就是要创建GWT Remote Service了，在原有工程上new->Other->GWT Remote Service 。如图1：

图1

新建一个GWT Remote Service如下图2：

图2

完成输入确定后，GWT会自动在clent端和server端生成需要的文件。如下图3阴影部分文件：

3.完成了基本配置后，我们要写需要实现的代码；

本人数据库为student;为了简单只有3列，sno,name,sex三项。

a.在DbService里实现getInstance()，实现通讯功能。具体见参考1.

代码如下：

package zjm.DbBase.demo.client; import java.util.List; import com.google.gwt.core.client.GWT; import com.google.gwt.user.client.rpc.RemoteService; import com.google.gwt.user.client.rpc.RemoteServiceRelativePath; import com.google.gwt.user.client.rpc.ServiceDefTarget; @RemoteServiceRelativePath("DbService") public interface DbService extends RemoteService { public List<DTO> loadData()throws Exception; public static final String SERVICE_URI = "DbService"; public static class Util { public static DbServiceAsync getInstance() { DbServiceAsync instance = (DbServiceAsync) GWT .create(DbService.class); ServiceDefTarget target = (ServiceDefTarget) instance; target.setServiceEntryPoint(GWT.getModuleBaseURL() + SERVICE_URI); return instance; } } }

其中public List<DTO> 方法是自己定义来获取数据库数据的方法。这个方法需要在DbServiceImpl.java中实现。该类实现了DbService这个服务接口。

b. DbServiceImpl.java代码实现上述方法：

代码：

package zjm.DbBase.demo.server; import java.sql.DriverManager; import java.util.LinkedList; import java.util.List; import zjm.DbBase.demo.client.DTO; import zjm.DbBase.demo.client.DbService; import com.google.gwt.user.server.rpc.RemoteServiceServlet; import com.mysql.jdbc.Connection; import com.mysql.jdbc.ResultSet; import com.mysql.jdbc.Statement; public class DbServiceImpl extends RemoteServiceServlet implements DbService { /** * */ private static final long serialVersionUID = 1L; public List<DTO> loadData() throws Exception { // TODO Auto-generated method stub try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/test"; Connection conn = (Connection) DriverManager.getConnection(url, "root", "blue373"); String cmd = "select * from student "; Statement stmt = (Statement) conn.createStatement(); ResultSet rs = (ResultSet) stmt.executeQuery(cmd); List<DTO> userInfo = new LinkedList<DTO>(); while (rs.next()) { DTO temp = new DTO(); temp.setId(Integer.parseInt(rs.getString("sno"))); temp.setName(rs.getString("name")); temp.setSex(rs.getString("sex")); userInfo.add(temp); } //System.out.println(userInfo); return userInfo; } catch (Exception ex) { ex.printStackTrace(); } return null; } }

C .DbServiceAsync.java中不用我们修改，GWT会根据我们在DbService.java中的修改添加方法而修改。

例如这里我们在DbService.java中添加了public List<DTO> loadData()throws Exception;这个方法，GWT会自动在

DbServiceAsync.java中生成public void loadData(AsyncCallback<List<DTO>> callback);方法。

4. DTO是封装了数据库查询的结果的类；

代码：

package zjm.DbBase.demo.client; import com.google.gwt.user.client.rpc.IsSerializable; public class DTO implements IsSerializable{ private int id; private String name; private String sex; public Object[] toObjectArray() { return new Object[] { new Integer(id), name, sex }; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } }

5。最后是实现结果的显示，这里只简单的直接显示。代码在DbDemo.java中；

代码：

package zjm.DbBase.demo.client; import java.util.Iterator; import java.util.List; import com.google.gwt.core.client.EntryPoint; import com.google.gwt.user.client.rpc.AsyncCallback; import com.gwtext.client.data.ArrayReader; import com.gwtext.client.data.FieldDef; import com.gwtext.client.data.IntegerFieldDef; import com.gwtext.client.data.RecordDef; import com.gwtext.client.data.Store; import com.gwtext.client.data.StringFieldDef; import com.gwtext.client.widgets.Panel; import com.gwtext.client.widgets.Viewport; import com.gwtext.client.widgets.grid.ColumnConfig; import com.gwtext.client.widgets.grid.ColumnModel; import com.gwtext.client.widgets.grid.GridPanel; public class DbDemo implements EntryPoint { public void onModuleLoad() { // TODO Auto-generated method stub Panel panel = new Panel("Common Panels"); panel.setClosable(true); panel.setBorder(false); panel.setPaddings(15); DbDemo db=new DbDemo(); panel.add( db.dbPanel()); new Viewport(panel); } public Panel dbPanel(){ final Panel panel = new Panel(); panel.setBorder(false); panel.setWidth(500); final GridPanel grid = new GridPanel(); final RecordDef recordDef = new RecordDef( new FieldDef[]{ new IntegerFieldDef("sno"), new StringFieldDef("name"), new StringFieldDef("sex") } ); final ColumnModel columnModel = new ColumnModel(new ColumnConfig[]{ new ColumnConfig("sno", "sno", 100, true), new ColumnConfig("name", "name", 75, true), new ColumnConfig("sex", "sex", 150, false), }); DbServiceAsync loadService = DbService.Util .getInstance(); final ArrayReader reader = new ArrayReader(recordDef); final Store store = new Store(reader); AsyncCallback cb_load = new AsyncCallback() { public void onFailure(Throwable arg0) { // TODO Auto-generated method stub System.out.println("communication failed!"); } public void onSuccess(Object response) { List<DTO> data =(List<DTO>) response; for (Iterator it = data.iterator(); it.hasNext();) { DTO bean = (DTO)it.next(); //System.out.println(bean.toObjectArray()); store.add(recordDef.createRecord(bean.toObjectArray())); } store.commitChanges(); store.load(); grid.setStore(store); grid.setTitle("load test"); grid.setColumnModel(columnModel); grid.setWidth(500); grid.setHeight(430); grid.setFrame(true); grid.stripeRows(true); panel.add(grid); panel.doLayout(); if (store == null) { System.out.println("store error"); return ; } } }; loadService.loadData(cb_load); return panel; } }

代码比较粗糙。。闪。。。。

运行最终结果：