后台中数据的增删改查的小案例
我使用的是
eclipse-jee-oxygen-3a-win32-x86_64
链接:https://pan.baidu.com/s/1UMiNVmEA42oKAr5Agl2maQ
提取码:v7h2
apache-tomcat-8.0.50-windows-x64
链接:https://pan.baidu.com/s/1gXeqB3bcbsqX-CoMoBZsCw
提取码:cru8
mysql-connector-java-5.1.40-bin
链接:https://pan.baidu.com/s/1moRwT7kKYZqdtnwbYA1iLA
提取码:12ez
mysql-5.7.22-winx64
链接:https://pan.baidu.com/s/1RutbhO1i4VVwhhDlJC6XXQ
提取码:p9mg
Navicat for MySQL
链接:https://pan.baidu.com/s/195S8MhEex8VNtKrBmvLPQw
提取码:1q4h
jdk-8u171-windows-x64
链接:https://pan.baidu.com/s/1JTRbWiHpZkbYoKXfQgcHKQ
提取码:nvh0
复制这段内容后打开百度网盘手机App,操作更方便哦
工具来做。
mysql代码:
/*
Navicat MySQL Data Transfer
Source Server : APP
Source Server Version : 50722
Source Host : 127.0.0.1:3306
Source Database : itcast
Target Server Type : MYSQL
Target Server Version : 50722
File Encoding : 65001
Date: 2018-07-22 10:00:36
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for studinfo
-- ----------------------------
DROP TABLE IF EXISTS `studinfo`;
CREATE TABLE `studinfo` (
`stuNum` int(11) NOT NULL,
`stuName` varchar(255) DEFAULT NULL,
`stuSex` varchar(255) DEFAULT NULL,
`stuAge` int(11) DEFAULT NULL,
`stuAddr` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of studinfo
-- ----------------------------
INSERT INTO `studinfo` VALUES ('7', '哈哈哈', '男', '14', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('9', '李四', '女', '25', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('10', '账务', '男', '27', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('11', '张武', '女', '25', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('21', '李冰', '男', '17', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('24', '晓雪', '女', '27', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('28', '美味', '男', '17', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('30', '人生', '男', '12', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('29', '李丽', '男', '52', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('25', '嘻嘻', '男', '26', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('1001', '王麻子', '女', '50', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('5', '赵六留', '男', '21', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('15', '李三', '女', '18', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('5', '赵六留', '男', '21', '河北省秦皇岛市河北大街西段550号');
INSERT INTO `studinfo` VALUES ('12', '赵六', '男', '22', '河北省秦皇岛市河北大街西段550号');
jsp部分代码:
Login.js
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<%
String flag = request.getParameter("flag");
if(flag!=null){
out.println("<h1 style='color:red'>登陆失败</h1>");
}
%>
<form action="LoginServlet" method="post">
username:<input type="text" name="username"><br>
password:<input type="password" name="password"><br>
<input type="submit" value="登陆">
</form>
</body>
</html>
ShowMyPerson.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.util.ArrayList,jdb1.MyPerson" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title