java.lang.NoClassDefFoundError
package servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import service.addservice;
import test.Test;
import utils.utils;
//@WebServlet("/addServlet")
public class addServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//获得输入内容
String name=request.getParameter("class");
String path=request.getParameter("path");
String desp=request.getParameter("desp");
//获得时间
Calendar ca = Calendar.getInstance();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
Date time1=ca.getTime();
String time=formatter.format(time1);
//调用方法
int i=addservice.setJDBC(name, path, desp, time);
System.out.println("aaa");
if(i>0) {
//跳转链接至显示servlet
request.getRequestDispatcher("/showServlet").forward(request, response);
}
}
}package servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import service.addservice;
public class showServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setAttribute("list", addservice.getjdbc());
request.getRequestDispatcher("/showCourse.jsp").forward(request, response);
}
}servlet
package service;
//添加到数据库的方法
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 test.Test;
import utils.utils;
public class addservice {
//设置jdbc方法
public static int setJDBC(String name,String path,String desp,String time) {
//数据表中数据集合
List<Test> classlist=new ArrayList<Test>();
//将对象添加进数据库
ResultSet rs=null;
Connection conn=null;
PreparedStatement pstmt=null;
int i=0;
try {
//获得链接
conn=utils.getConnection();
String sql="insert class values(?,?,?,?)";
// String sql1="select *from class";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, path);
pstmt.setString(3, desp);
pstmt.setString(4, time);
i =pstmt.executeUpdate();
// rs=pstmt.executeQuery(sql1);
//如果添加成功返回i
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
utils.release(conn, pstmt);
}
return i;
}
//数据库封装进集合方法
public static List getjdbc() {
//新建list
List<Test> testlist=new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs= null;
Test t=new Test();
try {
conn=utils.getConnection();
String sql="select*from class";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next()) {
t.setName(rs.getString("name"));
t.setPath(rs.getString("path"));
t.setDesp(rs.getString("desp"));
t.setTime(rs.getString("time"));
testlist.add(t);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
utils.release(conn, pstmt, rs);
}
return testlist;
}
}service
package test;
//课程类
public class Test {
private String name;
private String path;
private String desp;
private String time;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPath() {
return path;
}
public void setPath(String path) {
this.path = path;
}
public String getDesp() {
return desp;
}
public void setDesp(String desp) {
this.desp = desp;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
public Test(String name, String path, String desp, String time) {
super();
this.name = name;
this.path = path;
this.desp = desp;
this.time = time;
}
public Test() {
}
}课程类
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>添加成功</h1>
<table border=10>
<tr>
<td>名称</td>
<td>方向</td>
<td>介绍</td>
<td>时间</td>
</tr>
<c:forEach items="${list}" var="n">
<tr>
<td>${n.name}</td>
<td>${n.path}</td>
<td>${n.desp}</td>
<td>${n.time}</td>
</tr>
</c:forEach>
</table>
</body>
</html><%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <form action="/jdbcwork1/addServlet" enctype="multipart/form-data" method="post"> <h1>课程添加</h1> 课程名 <input type="text" placehoder="课程名" name="class"></br> 方向<input type="text" placehoder="方向" name="path"></br> 简介<input type="text" placehoder="介绍" name="desp"></br> <input type="submit" value="添加" > </form> </body> </html>
0
收起
正在回答 回答被采纳积分+1
1回答
Java数据库开发与实战应用2018版
- 参与学习 人
- 提交作业 277 份
- 解答问题 4297 个
Java数据库开发的必备技能,从流行的MySQL数据库开始,到Java原生的数据库管理接口JDBC的使用,再到常用的数据持久化框架MyBatis,让你向Java工程师的目标又迈进了一步!
了解课程
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星