&&精S2SH(spring + struts2 + hibernate)整合开发java web进销存后台管理系统，前端extjs郑重声明：本文分享内容来自互联网，转载目的在于传递更多信息，帮助大家，并不代表本人赞同其观点和对其真实性负责。如涉及作品内容、版权和其它问题，请在七日内与本人联系，我将在第一时间删除内容！操作系统：Windows。数据库：MySQL。编程平台：eclipse浏览器：googleWeb服务器：tomcat 7.0用户名和密码 adminjar地址1：/s/1nuiOtcdjar地址2：/s/1i5IDr9b运行截图:1.2.3.4.5.6.7.数据库截图由编辑于 18:46:41猜你喜欢12个牛币请下载代码后再发表评论//SSHStock/SSHStock/.classpath/SSHStock/.project/SSHStock/.settings/SSHStock/.settings/.jsdtscope/SSHStock/.settings/org.eclipse.jdt.core.prefs/SSHStock/.settings/org.ponent/SSHStock/.settings/org.mon.project.facet.core.xml/SSHStock/.settings/org.eclipse.wst.jsdt.ui.superType.container/SSHStock/.settings/org.eclipse.wst.jsdt.ui.superType.name/SSHStock/src/SSHStock/src/com/SSHStock/src/com/cxstock/SSHStock/src/com/cxstock/action/SSHStock/src/com/cxstock/action/chushou/SSHStock/src/com/cxstock/action/jinhuo/SSHStock/src/com/cxstock/action/kucun精精精精原精精原原原原相关分享精精精原最近下载暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级最近浏览暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级暂无贡献等级扫描二维码关注最代码为好友"/>扫描二维码关注最代码为好友新建个user.js 里面放入一下内容:
Ext.onReady(function() {
var record_start = 0;
var num = function(v,p,Record,rowIndex){
return record_start + rowIndex + 1; };
function renderSex(value) {
if (value == '1') {
return "&span style='color:blue'&先生&/span&";
return "&span style='color:orange'&女士&/span&";
var comboSex = [
['0','女'],
['1','男']
var sm = new Ext.grid.CheckboxSelectionModel({
handleMouseDown : Ext.emptyFn });
// 创建复选框
var cm = new Ext.grid.ColumnModel([new Ext.grid.RowNumberer({
renderer : num }), // 创建自动行号
header : '姓名',
dataIndex : 'stuName',
editor : new Ext.grid.GridEditor(new Ext.form.TextField({
allowBlank : false
sortable : true
header : '性别',
dataIndex : 'stuSex',
editor : new Ext.grid.GridEditor(new boBox({
store : new Ext.data.SimpleStore({
fields : ['value', 'text'],
data : comboSex
emptyText : '请选择',
mode : 'local',
triggerAction : 'all',
valueField : 'value',
displayField : 'text',
readOnly : true
renderer : renderSex,
sortable : true
header : '年龄',
dataIndex : 'stuAge',
editor : new Ext.grid.GridEditor(new Ext.form.NumberField({
allowBlank : false
sortable : true
header : '住址',
dataIndex : 'stuAddr',
editor : new Ext.grid.GridEditor(new Ext.form.TextField({
allowBlank : false
sortable : true
header : '电话',
dataIndex : 'stuTel',
editor : new Ext.grid.GridEditor(new Ext.form.NumberField({
allowBlank : false
sortable : true
// 定义类型 var Record = Ext.data.Record.create([{
name : 'stuId',
type : 'int' }, {
name : 'clsId',
type : 'int' }, {
name : 'stuSex',
type : 'int' }, {
name : 'stuName',
type : 'string' }, {
name : 'stuAge',
type : 'int' },{
name : 'stuAddr',
type : 'string' },{
name : 'stuTel',
type : 'String' }]);
var store = new Ext.data.Store({
proxy : new Ext.data.HttpProxy({
url : 'servlet/Query'
pruneModifiedRecords: true,
reader : new Ext.data.JsonReader({
totalProperty : 'totalProperty',
root : 'root'
name : 'stuId'
name : 'clsId'
name : 'stuSex'
name : 'stuName'
name : 'stuAge'
name : 'stuAddr'
name : 'stuTel'
// var grid = new Ext.grid.GridPanel({ // 不可编辑的grid
var grid = new Ext.grid.EditorGridPanel({ // 可编辑的grid
title : '学生信息管理',
autoHeight : true,
renderTo : 'grid',
store : store,
// 分页底端显示工具条
bbar : new Ext.PagingToolbar({
pageSize : 10,
displayInfo : true,
store : store,
displayMsg : '显示第{0}条到{1}条记录，一共{2}条',
emptyMsg : '没有记录',
doLoad: function(start){
record_start =
var o = {},pn = this.paramN
o[pn.start] =
o[pn.limit] = this.pageS
this.store.load({params:o});
// 添加与删除顶端显示工具条
tbar : new Ext.Toolbar(['-', {
text : '添加一行',
handler : function() {
var p = new Record({
stuId : '',
clsId: '1',
stuSex : '',
stuName : '',
stuAge : '',
stuAddr : '',
stuTel: ''
grid.stopEditing();
store.insert(0, p);
grid.startEditing(0, 2);
text : '删除一行',
handler : function() {
Ext.Msg.confirm('信息', '确定要删除？', function(btn) {
if (btn == 'yes') {
var cells = sm.getSelections();
var jsonArray = [];
for (var i = 0; i & cells. i++) {
jsonArray.push(cells[i].data);//
store.remove(cells[i]);
Ext.lib.Ajax.request('POST', 'servlet/Del', {
success : function(response) {
Ext.Msg.alert('信息', response.responseText,
function() {
store.reload();
failure : function() {
Ext.Msg.alert("错误", "与后台联系的时候出现了问题");
}, 'data=' + encodeURIComponent(Ext.encode(jsonArray)));
text: '保存',
handler: function(){
var m = store.modified.slice(0);
var jsonArray = [];
Ext.each(m, function(item) {
jsonArray.push(item.data);
Ext.lib.Ajax.request(
'servlet/Save',
{success: function(response){
Ext.Msg.alert('信息', response.responseText, function(){
store.reload();
},failure: function(){
Ext.Msg.alert("错误", "与后台联系的时候出现了问题");
'data=' + encodeURIComponent(Ext.encode(jsonArray))
viewConfig : {
forceFit : true
store.load({
params : {
start : 0,
limit : 10
新建个index.jsp页面 放入以下内容:
&%@ page language="java" import="java.util.*" pageEncoding="utf-8"%&
&!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&&html&
&title&ExtJsDemo&/title&
&link rel="stylesheet" type="text/css" href="ext/resources/css/ext-all.css"&
&script type="text/javascript" src="ext/adapter/ext/ext-base.js"&&/script&
&script type="text/javascript" src="ext/ext-all-debug.js"&&/script&
&script type="text/javascript" src="ext/ext-fun.js"&&/script&
&script type="text/javascript" src="ext/PagingMemoryProxy.js"&&/script&
&script type="text/javascript" src="js/user.js"&&/script&
&div id="grid"&&/div&
&/body&&/html&
配置下web.xml
&?xml version="1.0" encoding="UTF-8"?&&web-app version="2.4"
xmlns:xsi=""
xsi:schemaLocation="
&description&This is the description of my J2EE component&/description&
&display-name&This is the display name of my J2EE component&/display-name&
&servlet-name&Query&/servlet-name&
&servlet-class&ext.servlet.Query&/servlet-class&
&/servlet&
&description&This is the description of my J2EE component&/description&
&display-name&This is the display name of my J2EE component&/display-name&
&servlet-name&Save&/servlet-name&
&servlet-class&ext.servlet.Save&/servlet-class&
&/servlet&
&description&This is the description of my J2EE component&/description&
&display-name&This is the display name of my J2EE component&/display-name&
&servlet-name&Del&/servlet-name&
&servlet-class&ext.servlet.Del&/servlet-class&
&/servlet&
&description&This is the description of my J2EE component&/description&
&display-name&This is the display name of my J2EE component&/display-name&
&servlet-name&GetCls&/servlet-name&
&servlet-class&ext.servlet.GetCls&/servlet-class&
&/servlet&
&servlet-mapping&
&servlet-name&Query&/servlet-name&
&url-pattern&/servlet/Query&/url-pattern&
&/servlet-mapping&
&servlet-mapping&
&servlet-name&Save&/servlet-name&
&url-pattern&/servlet/Save&/url-pattern&
&/servlet-mapping&
&servlet-mapping&
&servlet-name&Del&/servlet-name&
&url-pattern&/servlet/Del&/url-pattern&
&/servlet-mapping&
&servlet-mapping&
&servlet-name&GetCls&/servlet-name&
&url-pattern&/servlet/GetCls&/url-pattern&
&/servlet-mapping&
&welcome-file-list&
&welcome-file&index.jsp&/welcome-file&
&/welcome-file-list&&/web-app&上面的web.xml是自动生成的......
后台的实现:
package ext.
import java.sql.Cimport java.sql.DriverMimport java.sql.PreparedSimport java.sql.ResultSimport java.sql.SQLE
public class BaseDao {
public final String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8";
public final String user = "root";
public final String pwd = "root";
private Connection conn =
private ResultSet rs =
public PreparedStatement pstm =
public BaseDao() {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
* @Function getConnection()
* @return Connection
*/ public Connection getConnection() {
conn = DriverManager.getConnection(url, user, pwd);
} catch (SQLException e) {
e.printStackTrace();
* @Function closePreparedStatement()
*/ public void closePreparedStatement() {
this.pstm.close();
} catch (SQLException e) {
e.printStackTrace();
* @Function closeConnection()
*/ public void closeConnection() {
this.conn.close();
} catch (SQLException e) {
e.printStackTrace();
* @Function exectueQuery()
* @param sql
* @return ResultSet
*/ public ResultSet exectueQuery(String sql) {
conn = this.getConnection();
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
* @Function executeUpdate()
* @throws SQLException
*/ public void executeUpdate() throws SQLException {
pstm.executeUpdate();
this.closePreparedStatement();
this.closeConnection(); }
* @Function executeDelete()
* @throws SQLException
*/ public void executeDelete() throws SQLException {
pstm.executeUpdate();
this.closePreparedStatement();
this.closeConnection(); }
* @Function executeInsert()
* @throws SQLException
*/ public void executeInsert() throws SQLException {
pstm.executeUpdate();
this.closePreparedStatement();
this.closeConnection(); }
* @Function preparedStatement()
* @param sql
* @throws SQLException
*/ public void preparedStatement(String sql) throws SQLException {
conn = this.getConnection();
pstm = conn.prepareStatement(sql); }}
package ext.
import java.sql.ResultSimport java.sql.SQLEimport java.util.ArrayLimport java.util.L
import ext.po.Cimport ext.po.U
public class UserDao extends BaseDao { public UserDao() { }
* @Function getUser()
* @return List&User&
* @throws SQLException
*/ public List&User& getUser(int start, int limit) {
String sql = "select * from student LIMIT ?,?";
this.preparedStatement(sql);
pstm.setInt(1, start);
pstm.setInt(2, limit);
} catch (SQLException e1) {
e1.printStackTrace();
List&User& list = new ArrayList&User&();
User user =
ResultSet rs = this.exectueQuery(sql);
while (rs.next()) {
user = new User();
user.setStuId(rs.getInt("stu_id"));
user.setClsId(rs.getInt("cls_id"));
user.setStuName(rs.getString("stu_name"));
user.setStuSex(rs.getInt("stu_sex"));
user.setStuAge(rs.getInt("stu_age"));
user.setStuAddr(rs.getString("stu_addr"));
user.setStuTel(rs.getString("stu_tel"));
list.add(user);
} catch (SQLException e) {
e.printStackTrace();
this.closePreparedStatement();
this.closeConnection();
*/ public int getCount() {
String sql = "select count(*) from student";
this.preparedStatement(sql);
ResultSet rs = this.exectueQuery(sql);
while (rs.next()) {
return rs.getInt(1);
} catch (SQLException e) {
e.printStackTrace();
return 0; }
* @Function addUser()
* @param user
* @throws SQLException
*/ public void addUser(User user) throws SQLException {
String sql = "insert into student(cls_id,stu_name,stu_sex,stu_age,stu_addr,stu_tel) values(?,?,?,?,?,?)";
this.preparedStatement(sql);
pstm.setInt(1, user.getClsId());
pstm.setString(2, user.getStuName());
pstm.setInt(3, user.getStuSex());
pstm.setInt(4, user.getStuAge());
pstm.setString(5, user.getStuAddr());
pstm.setString(6, user.getStuTel());
this.executeInsert(); }
* @Function editUser()
* @param user
* @throws SQLException
*/ public void editUser(User user) throws SQLException {
String sql = "update student set stu_name=?," + "stu_sex=?," + "stu_age=?," + "stu_addr=?," + "stu_tel=? "
+ "where stu_id=?";
this.preparedStatement(sql);
pstm.setString(1, user.getStuName());
pstm.setInt(2, user.getStuSex());
pstm.setInt(3, user.getStuAge());
pstm.setString(4, user.getStuAddr());
pstm.setString(5, user.getStuTel());
pstm.setInt(6, user.getStuId());
this.executeUpdate(); }
* @Function deleteUser()
* @param user
* @throws SQLException
*/ public void deleteUser(Integer id) throws SQLException {
String sql = "delete
from student where stu_id=?";
this.preparedStatement(sql);
pstm.setInt(1, id);
this.executeDelete(); }
* function : 获取班级列表
* @author wxl Jul 17, 2009
*/ public List&Clasz& getClassList() {
List&Clasz& list = new ArrayList&Clasz&();
String sql = "select * from class order by cls_cdate desc";
this.preparedStatement(sql);
ResultSet rs = this.exectueQuery(sql);
while (rs.next()) {
Clasz cls = new Clasz();
cls.setClsId(rs.getInt("cls_id"));
cls.setClsName(rs.getString("cls_name"));
list.add(cls);
} catch (Exception ex) {
package ext.
import java.sql.SQLEimport java.util.ArrayLimport java.util.L
import org.json.JSONAimport org.json.JSONE
import ext.dao.UserDimport ext.po.Cimport ext.po.U
public class UserBo {
* function : 从数据库获取数据并转化成json数据
* @param start
* @param limit
* @author wxl Jul 16, 2009
*/ public String getJsonData(int start, int limit) {
UserDao uDao = new UserDao();
List&User& list = uDao.getUser(start, limit);
StringBuffer sb = new StringBuffer();
int count = uDao.getCount();
sb.append("{totalProperty:");
sb.append(count);
sb.append(",root:[");
for (User user : list) {
sb.append("{");
sb.append("stuId:" + user.getStuId() + ",");
sb.append("clsId:" + user.getClsId() + ",");
sb.append("stuSex:" + user.getStuSex() + ",");
sb.append("stuName:'" + user.getStuName() + "',");
sb.append("stuAge:" + user.getStuAge() + ",");
sb.append("stuAddr:'" + user.getStuAddr() + "',");
sb.append("stuTel:'" + user.getStuTel() + "'");
sb.append("},");
sb.append("]}");
return sb.substring(0, sb.lastIndexOf(",")) + sb.substring(sb.lastIndexOf(",") + 1); }
* function : 保存或修改数据
* @param data
* @author wxl Jul 17, 2009
*/ public void saveOrUpdate(String jsonData) {
UserDao uDao = new UserDao();
List&User& list = this.getUserFromJson(jsonData);
if (list != null && list.size() & 0) {
for (User user : list) {
if (user.getStuId() != null && !"".equals(user.getStuId())) {
uDao.editUser(user);
uDao.addUser(user);
} catch (SQLException e) {
e.printStackTrace();
* function : 把Json数据转化成List
* @param jsonData
* @author wxl Jul 17, 2009
*/ private List&User& getUserFromJson(String jsonData) {
List&User& list = new ArrayList&User&();
org.json.JSONArray array = new JSONArray(jsonData);
for (int i = 0; i & array.length(); i++) {
org.json.JSONObject jo = new org.json.JSONObject(array.get(i).toString());
User uPo = new User();
uPo.setClsId(Integer.parseInt(jo.getString("clsId")));
uPo.setStuAddr(jo.getString("stuAddr"));
String stuAge = jo.getString("stuAge");
if (stuAge != null && !"".equals(stuAge)) {
uPo.setStuAge(Integer.parseInt(stuAge));
uPo.setStuAge(0);
uPo.setStuName(jo.getString("stuName"));
String stuSex = jo.getString("stuSex");
if (stuSex != null && !"".equals(stuSex)) {
uPo.setStuSex(Integer.parseInt(stuSex));
uPo.setStuSex(0);
uPo.setStuTel(jo.getString("stuTel"));
String stuId = jo.getString("stuId");
if (stuId != null && !"".equals(stuId)) {
uPo.setStuId(Integer.parseInt(stuId));
list.add(uPo);
} catch (JSONException e) {
e.printStackTrace();
* function : 删除数据
* @param jsonData
* @author wxl Jul 17, 2009
*/ public void delUser(String jsonData) {
UserDao uDao = new UserDao();
List&User& list = this.getUserFromJson(jsonData);
if (list != null && list.size() & 0) {
for (User user : list) {
if (user.getStuId() != null && !"".equals(user.getStuId())) {
uDao.deleteUser(user.getStuId());
} catch (Exception ex) {
ex.printStackTrace();
*function: 获取班级的json数据
wxl Jul 17, 2009
*/ public String getClsJsonData() {
UserDao uDao = new UserDao();
List&Clasz& list = uDao.getClassList();
StringBuffer sb = new StringBuffer();
sb.append("[");
if (list != null && list.size() & 0) {
for (Clasz clasz : list) {
sb.append("['");
sb.append(clasz.getClsId() + "','");
sb.append(clasz.getClsName() + "'");
sb.append("],");
sb.append("]");
return sb.substring(0, sb.lastIndexOf(",")) + sb.substring(sb.lastIndexOf(",") + 1); }}
formbean::实现
package ext.
public class User {
private Integer stuId;
private Integer clsId;
private String stuN
private Integer stuS
private Integer stuA
private String stuA
private String stuT
public Integer getStuId() {
return stuId; }
public void setStuId(Integer stuId) {
this.stuId = stuId; }
public Integer getClsId() {
return clsId; }
public void setClsId(Integer clsId) {
this.clsId = clsId; }
public String getStuName() {
return stuN }
public void setStuName(String stuName) {
this.stuName = stuN }
public Integer getStuSex() {
return stuS }
public void setStuSex(Integer stuSex) {
this.stuSex = stuS }
public Integer getStuAge() {
return stuA }
public void setStuAge(Integer stuAge) {
this.stuAge = stuA }
public String getStuAddr() {
return stuA }
public void setStuAddr(String stuAddr) {
this.stuAddr = stuA }
public String getStuTel() {
return stuT }
public void setStuTel(String stuTel) {
this.stuTel = stuT
另外个formbean:
package ext.
public class Clasz {
private Integer clsId;
private String clsN
public Integer getClsId() {
return clsId; }
public void setClsId(Integer clsId) {
this.clsId = clsId; }
public String getClsName() {
return clsN }
public void setClsName(String clsName) {
this.clsName = clsN }} }}
package ext.
import java.util.ArrayLimport java.util.HashMimport java.util.Iimport java.util.Limport java.util.M
import net.sf.json.JSONAimport net.sf.json.JSONO
public class JsonUtil {
* 从一个JSON 对象字符格式中得到一个java对象
* @param jsonString
* @param pojoCalss
public static Object getObject4JsonString(String jsonString,Class pojoCalss) {
JSONObject jsonObject = JSONObject.fromObject( jsonString );
pojo = JSONObject.toBean(jsonObject,pojoCalss);
* 从json HASH表达式中获取一个map，改map支持嵌套功能
* @param jsonString
public static Map getMap4Json(String jsonString) {
JSONObject jsonObject = JSONObject.fromObject( jsonString );
keyIter = jsonObject.keys();
Map valueMap = new HashMap();
while( keyIter.hasNext())
key = (String)keyIter.next();
value = jsonObject.get(key);
valueMap.put(key, value);
return valueM
* 从json数组中得到相应java数组
* @param jsonString
public static Object[] getObjectArray4Json(String jsonString) {
JSONArray jsonArray = JSONArray.fromObject(jsonString);
return jsonArray.toArray();
* 从json对象集合表达式中得到一个java对象列表
* @param jsonString
* @param pojoClass
public static List getList4Json(String jsonString, Class pojoClass) {
JSONArray jsonArray = JSONArray.fromObject(jsonString);
JSONObject jsonO
Object pojoV
List list = new ArrayList();
for ( int i = 0 ; i&jsonArray.size(); i++) {
jsonObject = jsonArray.getJSONObject(i);
pojoValue = JSONObject.toBean(jsonObject,pojoClass);
list.add(pojoValue);
* 从json数组中解析出java字符串数组
* @param jsonString
public static String[] getStringArray4Json(String jsonString) {
JSONArray jsonArray = JSONArray.fromObject(jsonString);
String[] stringArray = new String[jsonArray.size()];
for( int i = 0 ; i&jsonArray.size() ; i++ ) {
stringArray[i] = jsonArray.getString(i);
return stringA
* 从json数组中解析出javaLong型对象数组
* @param jsonString
public static Long[] getLongArray4Json(String jsonString){
JSONArray jsonArray = JSONArray.fromObject(jsonString);
Long[] longArray = new Long[jsonArray.size()];
for( int i = 0 ; i&jsonArray.size() ; i++ ) {
longArray[i] = jsonArray.getLong(i);
return longA
* 从json数组中解析出java Integer型对象数组
* @param jsonString
public static Integer[] getIntegerArray4Json(String jsonString) {
JSONArray jsonArray = JSONArray.fromObject(jsonString);
Integer[] integerArray = new Integer[jsonArray.size()];
for( int i = 0 ; i&jsonArray.size() ; i++ ) {
integerArray[i] = jsonArray.getInt(i);
return integerA
* 从json数组中解析出java Date 型对象数组，使用本方法必须保证
* @param jsonString
public static Date[] getDateArray4Json(String jsonString,String DataFormat) {//
JSONArray jsonArray = JSONArray.fromObject(jsonString);//
Date[] dateArray = new Date[jsonArray.size()];//
String dateS//
for( int i = 0 ; i&jsonArray.size() ; i++ ) {//
dateString = jsonArray.getString(i);//
date = DateUtil.stringToDate(dateString, DataFormat);//
dateArray[i] =//
return dateA//
* 从json数组中解析出java Integer型对象数组
* @param jsonString
public static Double[] getDoubleArray4Json(String jsonString) {//
JSONArray jsonArray = JSONArray.fromObject(jsonString);//
Double[] doubleArray = new Double[jsonArray.size()];//
for( int i = 0 ; i&jsonArray.size() ; i++ ) {//
doubleArray[i] = jsonArray.getDouble(i);//
return doubleA//
* 将java对象转换成json字符串
* @param javaObj
public static String getJsonString4JavaPOJO(Object javaObj) {
json = JSONObject.fromObject(javaObj);
return json.toString();
* 将java对象转换成json字符串,并设定日期格式
* @param javaObj
* @param dataFormat
public static String getJsonString4JavaPOJO(Object javaObj , String dataFormat) {//
JsonConfig jsonConfig = new JsonConfig(dataFormat);//
json = JSONObject.fromObject(javaObj,jsonConfig);//
return json.toString();//
删除的servlet:
package ext.
import java.io.IOE
import javax.servlet.ServletEimport javax.servlet.http.HttpSimport javax.servlet.http.HttpServletRimport javax.servlet.http.HttpServletR
import ext.bo.UserBo;
public class Del extends HttpServlet {
* The doGet method of the servlet. &br&
* This method is called when a form has its tag value method equals to get.
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response); }
* The doPost method of the servlet. &br&
* This method is called when a form has its tag value method equals to post.
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String jsonData = request.getParameter("data");
UserBo uBo = new UserBo();
uBo.delUser(jsonData);
response.getWriter().print("删除成功!"); }
查询班级的serlvet:
package ext.
import java.io.IOE
import javax.servlet.ServletEimport javax.servlet.http.HttpSimport javax.servlet.http.HttpServletRimport javax.servlet.http.HttpServletR
import ext.bo.UserBo;
public class GetCls extends HttpServlet {
* The doGet method of the servlet. &br&
* This method is called when a form has its tag value method equals to get.
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response); }
* The doPost method of the servlet. &br&
* This method is called when a form has its tag value method equals to post.
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
UserBo uBo = new UserBo();
String jsonData = uBo.getClsJsonData();
response.getWriter().write(jsonData);
response.getWriter().flush(); }
查询用户的servlet:
package ext.
import java.io.IOE
import javax.servlet.ServletEimport javax.servlet.http.HttpSimport javax.servlet.http.HttpServletRimport javax.servlet.http.HttpServletR
import ext.bo.UserBo;
public class Query extends HttpServlet {
* The doGet method of the servlet. &br&
* This method is called when a form has its tag value method equals to get.
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response); }
* The doPost method of the servlet. &br&
* This method is called when a form has its tag value method equals to post.
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String start = request.getParameter("start");
String limit = request.getParameter("limit");
UserBo uBo = new UserBo();
String json = uBo.getJsonData(Integer.parseInt(start), Integer.parseInt(limit));
response.getWriter().write(json);
response.getWriter().flush(); }
保存用户servlet:
package ext.
import java.io.IOE
import javax.servlet.ServletEimport javax.servlet.http.HttpSimport javax.servlet.http.HttpServletRimport javax.servlet.http.HttpServletR
import ext.bo.UserBo;
public class Save extends HttpServlet {
* The doGet method of the servlet. &br&
* This method is called when a form has its tag value method equals to get.
* @param request
the request send by the client to the server
* @param response
the response send by the server to the client
* @throws ServletException
if an error occurred
* @throws IOException
if an error occurred
*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response); }
* The doPost method of the servlet. &br&
* This method is called when a form has its tag value method equals to
* @param request
the request send by the client to the server
* @param response
the response send by the server to the client
* @throws ServletException
if an error occurred
* @throws IOException
if an error occurred
*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String data = request.getParameter("data");
UserBo uBo = new UserBo();
uBo.saveOrUpdate(data);
response.getWriter().print("保存或修改成功!"); }
相关的数据库的创建:
创建数据表:
/*==============================================================*//* DBMS name:
*//* Created on:
*//*==============================================================*/
/*==============================================================*//* Table: class
*//*==============================================================*/create table class(
int not null auto_increment,
varchar(20),
varchar(10),
primary key (cls_id));
/*==============================================================*//* Table: student
*//*==============================================================*/create table student(
int not null auto_increment,
varchar(20),
varchar(20),
primary key (stu_id));
alter table student add constraint FK_Relationship_1 foreign key (cls_id)
references class (cls_id) on delete restric
添加数据表:
insert into class values(null,'A班','');insert into class values(null,'A班','');
insert into student values(null,1,'学生A',1,20,'福州','1111111');insert into student values(null,2,'学生B',0,21,'福州','2222222');insert into student values(null,1,'学生C',1,22,'福州','3333333');insert into student values(null,2,'学生D',0,23,'福州','4444444');insert into student values(null,1,'学生E',1,24,'福州','5555555');insert into student values(null,2,'学生F',0,25,'福州','6666666');insert into student values(null,1,'学生G',0,26,'福州','7777777');insert into student values(null,2,'学生H',0,27,'福州','');insert into student values(null,1,'学生I',0,18,'福州','');insert into student values(null,1,'学生J',0,19,'福州','');insert into student values(null,2,'学生K',0,19,'福州','');insert into student values(null,2,'学生L',0,20,'福州','');insert into student values(null,2,'学生M',1,21,'福州','5');insert into student values(null,2,'学生N',1,23,'福州','');insert into student values(null,2,'学生O',1,24,'福州','');insert into student values(null,1,'学生P',1,25,'福州','');insert into student values(null,1,'学生Q',1,24,'福州','');insert into student values(null,1,'学生R',1,23,'福州','');insert into student values(null,2,'学生S',0,21,'福州','2222222');insert into student values(null,1,'学生T',1,20,'福州','3333333');insert into student values(null,1,'学生U',0,23,'福州','');insert into student values(null,1,'学生V',1,24,'福州','5555555');insert into student values(null,1,'学生W',1,19,'福州','');insert into student values(null,1,'学生X',1,24,'福州','');insert into student values(null,2,'学生Y',1,22,'福州','');insert into student values(null,2,'学生Z',1,22,'福州','');insert into student values(null,2,'学生AA',1,18,'福州','');insert into student values(null,1,'学生BB',1,17,'福州','');insert into student values(null,1,'学生CC',0,24,'福州','5859404');insert into student values(null,1,'学生DD',0,16,'福州','5553493');insert into student values(null,1,'学生EE',0,16,'福州','5555555');insert into student values(null,2,'学生FF',0,18,'福州','5553453');insert into student values(null,2,'学生GG',1,17,'福州','');insert into student values(null,1,'学生HH',1,18,'福州','');
运行的结果如下:::
浏览: 276784 次
来自: 北京
不错 果然是hibernate 对数据库字段的问 ...
[b][/b]真的非常强大。。。多谢分享
真的很强大，不错
是啊大哥啊,给个图片多好啊
火狐里貌似不显示控件