简单的SSH项目案例增删查，使用注解开发

项目未动，数据库先搭，MySQL数据库名称为s

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for classes
-- ----------------------------
DROp TABLE IF EXISTS `classes`;
CREATE TABLE `classes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of classes
-- ----------------------------
INSERT INTO `classes` VALUES ('1', 'Java');
INSERT INTO `classes` VALUES ('2', 'C#/.Net');
INSERT INTO `classes` VALUES ('3', 'C语言');
INSERT INTO `classes` VALUES ('4', '数据库');

-- ----------------------------
-- Table structure for faqs
-- ----------------------------
DROP TABLE IF EXISTS `faqs`;
CREATE TABLE `faqs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `createdate` datetime DEFAULT NULL,
  `content` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `classid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of faqs
-- ----------------------------
INSERT INTO `faqs` VALUES ('1', '如何安装配置IIS', '2012-10-19 00:00:00', '放假啊浪费大家阿里山扩大发生快递费', '2');
INSERT INTO `faqs` VALUES ('2', '如何理解指针', '2012-12-17 00:00:00', '放假啊浪费大家阿里山扩大发生快递费', '3');
INSERT INTO `faqs` VALUES ('3', 'JavaWeb开发的常用服务器有哪些', '2009-10-15 00:00:00', '放假啊浪费大家阿里山扩大发生快递费', '1');
INSERT INTO `faqs` VALUES ('4', 'javaOOP', '2021-10-22 11:53:01', 'dfada', '1');
INSERT INTO `faqs` VALUES ('5', 'javaee', '2021-10-22 12:00:18', '          ee', '3');

web图

先导入lib的包：百度网盘请输入提取码提取码：3j4x

web=>WEB-INF=>web.xml



    
    
        org.springframework.web.context.ContextLoaderListener
    

    
    
        contextConfigLocation
        classpath:applicationContext.xml
    

    
        struts2
        org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
    

    
        struts2
        
public class Classes {

    private int id;

    private String cname;

    public Classes() {
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getCname() {
        return cname;
    }

    public void setCname(String cname) {
        this.cname = cname;
    }

    @Override
    public String toString() {
        return "Classes{" +
                "id=" + id +
                ", cname='" + cname + ''' +
                '}';
    }
}

com.tang.pojo.Faqs.java

package com.tang.pojo;

import java.util.Date;


public class Faqs {

    private int id;

    private String title;

    private String createdate;

    private String content;

    private Integer classid;

    private String classidToString;

    public Faqs() {
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getCreatedate() {
        return createdate;
    }

    public void setCreatedate(String createdate) {
        this.createdate = createdate;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public Integer getClassid() {
        return classid;
    }

    public void setClassid(Integer classid) {
        if (classid==1){
            this.classidToString="Java";
        }else if (classid==2){
            this.classidToString="C#.Net";
        }else if (classid==3){
            this.classidToString="C语言";
        }else if (classid==4){
            this.classidToString="数据库";
        }

        this.classid = classid;
    }

    public String getClassidToString() {
        return classidToString;
    }

    @Override
    public String toString() {
        return "Faqs{" +
                "id=" + id +
                ", title='" + title + ''' +
                ", createdate=" + createdate +
                ", content='" + content + ''' +
                ", classidToString='" + classidToString + ''' +
                '}';
    }
}

com.tang.controller.action.FaqsController.java

package com.tang.controller.action;

import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.tang.pojo.Faqs;
import com.tang.service.FaqsService;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;


@Namespace("/")
@ParentPackage("struts-default")
@Controller
public class FaqsController extends ActionSupport implements ModelDriven {

    private List list;

    public List getList() {
        return list;
    }

    @Autowired
    private FaqsService faqsService;

    private Faqs faqs=new Faqs();

    @Override
    public Faqs getModel() {
        return faqs;
    }

    
    @Action(value = "list",results = {@Result(name = "success",location = "/index.jsp")})
    public String faqsList(){
        System.out.println("FaqsController=>faqsList()");
        list = faqsService.faqsList();
        return SUCCESS;
    }

    @Action(value = "delete",results = {@Result(name = "success",location = "list",type ="chain")})
    public String delete(){
        System.out.println("FaqsController=>delete()");
        faqsService.deleteFaqs(faqs.getId());
        return SUCCESS;
    }

    @Action(value = "add",results = {@Result(name = "success",location = "list",type = "chain")})
    public String addFags(){
        System.out.println("FaqsController=>addFags()");
        SimpleDateFormat sdf = new SimpleDateFormat();// 格式化时间
        sdf.applyPattern("yyyy-MM-dd HH:mm:ss");// a为am/pm的标记
        Date date = new Date();// 获取当前时间
        faqs.setCreatedate(sdf.format(date));
        faqsService.addFaqs(faqs);
        return SUCCESS;
    }

}

com.tang.service.FaqsService.java

package com.tang.service;

import com.tang.pojo.Faqs;

import java.util.List;


public interface FaqsService {

    void addFaqs(Faqs faqs);

    List faqsList();

    void deleteFaqs(int id);

}

com.tang.service.impl.FaqsServiceImpl.java

package com.tang.service.impl;

import com.tang.dao.FaqsDao;
import com.tang.pojo.Faqs;
import com.tang.service.FaqsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;


@Service("faqsService")
@Transactional
public class FaqsServiceImpl implements FaqsService {

    @Autowired
    private FaqsDao faqsDao;

    @Override
    public void addFaqs(Faqs faqs) {
        faqsDao.addFaqs(faqs);
    }

    @Override
    public List faqsList() {
        return faqsDao.faqsList();
    }

    @Override
    public void deleteFaqs(int id) {
        faqsDao.deleteFaqs(id);
    }
}

com.tang.dao.FaqsDao.java

package com.tang.dao;

import com.tang.pojo.Faqs;

import java.util.List;


public interface FaqsDao {

    void addFaqs(Faqs faqs);

    List faqsList();

    void deleteFaqs(int id);
}

com.tang.dao.impl.FaqsDaoImpl.java

package com.tang.dao.impl;

import com.tang.dao.FaqsDao;
import com.tang.pojo.Faqs;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.classic.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;


@Repository("faqsDao")
public class FaqsDaoImpl implements FaqsDao {

    @Autowired
    private HibernateTemplate hibernateTemplate;

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    public void addFaqs(Faqs faqs) {
        Session session = sessionFactory.openSession();
        Transaction tx = session.beginTransaction();
        session.save(faqs);
        tx.commit();
    }


    @Override
    public List faqsList() {
        Session session = sessionFactory.openSession();
            Transaction tx = session.beginTransaction();
            Query query = session.createQuery("from Faqs");
            List list = query.list();
            tx.commit();
            return list;
    }

    @Override
    public void deleteFaqs(int id) {
        Session session = sessionFactory.openSession();
        Transaction ts = session.beginTransaction();
        Faqs faqs = (Faqs) session.get(Faqs.class, id);
        session.delete(faqs);
        ts.commit();
    }
}

简单的SSH项目案例增删查，使用注解开发

Java相关栏目本月热门文章