Java中jqGrid 学习笔记整理——进阶篇(二)-eolink官网

Java中jqGrid 学习笔记整理——进阶篇(二)

相关阅读：

java中jqGrid 学习笔记整理——进阶篇(一)

本篇开始正式与后台（java语言）进行数据交互，使用的平台为

JDK：java 1.8.0_71

myEclisp 2015 Stable 2.0

Apache Tomcat-8.0.30

mysql 5.7

Navicat for mysql 11.2.5(mysql数据库管理工具)

一、数据库部分

1、创建数据库

使用Navicat for mysql创建数据库（使用其他工具或直接使用命令行暂不介绍）

2.创建表

双击打开上步创建数据库——右击Tables——选择New Table

建立如下字段保存时会提示输入表名

二、程序部分

1、新建项目

使用myEclipse新建——Web Project

输入项目名称选择java和运行该项目的Tomcat 一直点下一步直到下图页面点选下面自动生成web.xml文件的复选框后完成

创建如下包结构并新建一个vo类（属性与数据库字段一一对应）

demo.java

package com.xeonmic.vo;

public class demo {

private int id;

private String name;

private int type;

private double pay;

private String text;

public demo() {

// TODO Auto-generated constructor stub

}

public demo(int id, int type, Double pay,String name, String text) {

this.id = id;

this.name = name;

this.type = type;

this.pay = pay;

this.text = text;

}

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 int getType() {

return type;

}

public void setType(int type) {

this.type = type;

}

public double getPay() {

return pay;

}

public void setPay(Double pay) {

this.pay = pay;

}

public String getText() {

return text;

}

public void setText(String text) {

this.text = text;

}

@Override

public String toString() {

return "demo [id=" + id + ", name=" + name + ", type=" + type

+ ", pay=" + pay + ", text=" + text + "]";

}

2、导入数据库连接和jsON文件的jar包

数据库连接jar包可以在mysql安装目录的如下目录查找到

另外下载JSON所需jar包，已上传百度云（http://pan.baidu.com/s/1dETGjRV）一起复制粘贴到WebRoot/WEB-INF/lib目录下

然后全选右键添加到构建路径

3、DAO设计模式的基本分层实现

参考《Java Web开发实战经典基础篇》这里不在叙述直接贴源码后续单独开一篇专门讲这部分基础知识

—3.1、DatabaseConnection.java

package com.xeonmic.dbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DatabaseConnection {

private static final String DBDRIVER="org.gjt.mm.mysql.Driver";

private static final String DBURL="jdbc:mysql://localhost:3306/jqgriddemo";

private static final String DBUSER="root";

private static final String DBPASSWORD="1234";

private Connection conn =null;

public DatabaseConnection(){

try {

Class.forName(DBDRIVER);

this.conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);

} catch (ClassNotFoundException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

//System.out.println("连接数据库成功");

}

public Connection getConnection(){

return this.conn;

}

public void close(){

if(this.conn != null){

try {

this.conn.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

—3.2、DemoDAO.java

package com.xeonmic.dao;

import java.util.List;

import com.xeonmic.vo.demo;

public interface DemoDAO {

//添加方法

public boolean doCreate(demo demo);

//查询方法

public List doSearch(String keys);

//删除方法

public boolean doDelete(int id);

//修改方法

public boolean doChange(demo demo);

}

—3.3、DemoDAOImpl.java

package com.xeonmic.dao.impl;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.xeonmic.dao.DemoDAO;

import com.xeonmic.vo.demo;

public class DemoDAOImpl implements DemoDAO {

private Connection conn = null;

private PreparedStatement pstmt = null;

public DemoDAOImpl(Connection conn){

this.conn=conn;

}

@Override

public boolean doCreate(demo demo) {

boolean flag = false;

String sql = "INSERT INTO t_demo(type,pay,name,text ) VALUES(?,?,?,?)";

try {

this.pstmt = this.conn.prepareStatement(sql);

this.pstmt.setInt(1, demo.getType());

this.pstmt.setDouble(2, demo.getPay());

this.pstmt.setString(3, demo.getName());

this.pstmt.setString(4, demo.getText());

if(this.pstmt.executeUpdate()>0){

flag = true;

}

this.pstmt.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

return flag;

}

@Override

public List doSearch(String keys) {

// TODO Auto-generated method stub

if (keys==null) {

keys="";

}

String sql = "SELECT id,name,type,pay,text FROM t_demo "+keys;

List all = new ArrayList();

System.out.println(sql);

try {

this.pstmt = this.conn.prepareStatement(sql);

ResultSet rs = this.pstmt.executeQuery();

demo demo = null;

while(rs.next()){

demo = new demo(rs.getInt("id"),rs.getInt("type"),rs.getDouble("pay"),rs.getString("name"),rs.getString("text"));

all.add(demo);

}

this.pstmt.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

return all;

}

@Override

public boolean doDelete(int id) {

boolean flag = false;

String sql = "DELETE FROM t_demo WHERE id = ?";

try {

this.pstmt = this.conn.prepareStatement(sql);

this.pstmt.setInt(1, id);

if(this.pstmt.executeUpdate()>0){

flag = true;

}

this.pstmt.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

return flag;

}

@Override

public boolean doChange(demo demo) {

boolean flag = false;

String sql = "UPDATE t_demo SET type=?,pay=?,name=?,text=? WHERE id=?";

try {

this.pstmt = this.conn.prepareStatement(sql);

this.pstmt.setInt(5, demo.getId());

this.pstmt.setInt(1, demo.getType());

this.pstmt.setDouble(2, demo.getPay());

this.pstmt.setString(3, demo.getName());

this.pstmt.setString(4, demo.getText());

if(this.pstmt.executeUpdate()>0){

flag = true;

}

this.pstmt.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

return flag;

}

—3.5、Factory.java

package com.xeonmic.factory;

import com.xeonmic.dao.DemoDAO;

import com.xeonmic.dao.proxy.DemoDAOProxy;

public class Factory {

public static DemoDAO getDemoDAOInstance(){

return new DemoDAOProxy();

}

—3.6、Demotest.java(对前面的方法进行一次简单测试)

package com.xeonmic.test;

import java.util.LinkedList;

import java.util.List;

import com.xeonmic.factory.Factory;

import com.xeonmic.vo.demo;

public class Demotest {

public static void main(String[] args) {

demo demo1 = new demo();

demo1.setName("Name");

demo1.setPay(0.98);

demo1.setType(1);

demo1.setText("Text");

doCreate(demo1);

doSearch(null);

if (doSearch(null)!=null&&!doSearch(null).isEmpty()) {

demo1 = doSearch("").get(0);

demo1.setText("Change Text");

doChange(demo1);

doSearch("WHERE id = "+demo1.getId());

doDelete(demo1.getId());

doSearch(null);

}

public static List doSearch(String keys) {

List allDemos = new LinkedList();

allDemos = Factory.getDemoDAOInstance().doSearch(keys);

for (demo demo : allDemos) {

System.out.println(demo.toString());

}

return allDemos;

}

public static void doCreate(demo demo) {

if (Factory.getDemoDAOInstance().doCreate(demo)) {

System.out.println("添加成功");

}else {

System.out.println("添加失败");

}

public static void doChange(demo demo) {

if (Factory.getDemoDAOInstance().doChange(demo)) {

System.out.println("修改成功");

}else {

System.out.println("修改失败");

}

public static void doDelete(int id) {

if (Factory.getDemoDAOInstance().doDelete(id)) {

System.out.println("删除成功");

}else {

System.out.println("删除失败");

}

* 输出结果

添加成功