创建一个JavaWeb项目,在JSP页面中实现对数据库的一个数据表的增删改查功能。要求通过表单添加数据,通过链接删除数据,通过超链接,链接到修改页面,在表单上修改数据。查询出来的数据以表格形式显示。
delete.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>删除数据超链接</title>
</head>
<body>
<%
String str=request.getParameter("no");
String driverClass = "com.mysql.cj.jdbc.Driver";
String database = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=UTF-8";
String username = "root";
String password = "hongfengting";
// 加载JDBC驱动类
Class.forName(driverClass);
// 连接数据库
// DriverManager.setLogWriter(new PrintWriter(System.out));
Connection conn = DriverManager.getConnection(database, username, password);
Statement stat = conn.createStatement();
String sql = "DELETE FROM STUDENT1 WHERE NO='"+str+"'";
int i = stat.executeUpdate(sql);
System.out.println("成功删除" + i + "行");
stat.close();
conn.close();
%>
成功删<%=i %>行
</body>
</html>
insert.jsp
<%@page import="java.sql.Statement" %>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加数据表单</title>
</head>
<body>
<form action="">
账号:<input name="no" type="text"><br>
姓名:<input name="name" type="text"><br>
性别:<input name="sex" type="radio" value="男" checked>男
<input name="sex" type="radio" value="女">女<br>
<input type="submit" value="添加">
</form>
<%
request.setCharacterEncoding("utf-8");
String no=request.getParameter("no");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
if(no!=null){
String driverClass = "com.mysql.cj.jdbc.Driver";
String database = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=UTF-8";
String username = "root";
String password = "hongfengting";
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(database, username, password);
Statement stat = conn.createStatement();
String sql = "INSERT INTO STUDENT1 (NO,NAME,SEX) VALUES('"+no+"','"+name+"','"+sex+"')";
int i=0;
try{
i= stat.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
System.out.println("成功添加" + i + "行");
stat.close();
conn.close();
%>
成功添加了<%=i %>行
<%} %>
</body>
</html>
updata1.jsp
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*" %>
<%@page import="java.util.Scanner"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>修改数据表单</title>
</head>
<body>
<%-- <%
String no=request.getParameter("no");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
%> --%>
<form action="" >
请输入要更新账号:<input name="no" type="text" ><br>
请输入新的姓名:<input name="name" type="text" ><br>
请输入新的性别:<input name="sex"type="radio" value="男" checked>男
<input name="sex"type="radio" value="女" >女<br>
<input type="submit" value="修改">
</form>
<%
request.setCharacterEncoding("utf-8");
String no=request.getParameter("no");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String driverClass = "com.mysql.cj.jdbc.Driver";
String database = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=UTF-8";
String username = "root";
String password = "hongfengting";
// 加载JDBC驱动类
Class.forName(driverClass);
// 连接数据库
// DriverManager.setLogWriter(new PrintWriter(System.out));
Connection conn = DriverManager.getConnection(database, username, password);
Statement stat = conn.createStatement();
String sql = "UPDATE STUDENT1 SET NAME='"+name+"',SEX='"+sex+"' WHERE NO="+no;
int i = stat.executeUpdate(sql);
System.out.println("成功更新" + i + "行");
stat.close();
conn.close();
%>
<%-- 成功更新了<%=i%>行 --%>
</body>
</html>
select.jsp
<%@page import="java.sql.ResultSet"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询数据表格</title>
</head>
<body>
<table border=1>
<tr>
<td>no</td>
<td>name</td>
<td>sex</td>
<td></td>
<td></td>
</tr>
<%
String driverClass = "com.mysql.cj.jdbc.Driver";
String database = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=UTF-8";
String username = "root";
String password = "hongfengting";
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(database, username, password);
Statement stat = conn.createStatement();
String sql = "SELECT * FROM STUDENT1";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String no = rs.getString("NO");
String name = rs.getString("NAME");
String sex=rs.getString("SEX");
%>
<tr>
<td><%=no%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><a href="delete.jsp?no=<%=no %>">删除</a></td>
<td><a href="updata1.jsp?no=<%=no %>">修改</a></td>
</tr>
<%
}
stat.close();
conn.close();
%>
</table>
<%-- <div style="margin-left:155px;margin-top:-128px;width:180px;heigth:50px">
<table border-style="width:300px;">
<tr>
<td>operate</td>
</tr>
</table>
</div>
<div style="margin-left:155px;margin-top:-95px;">
<table>
<tr>
<td><a href="delete.jsp?id=<%= sql0%>">删除</a>/<a href="#">修改</a></td>
</tr>
</table>
</div>
<div style="margin-left:155px;">
<table>
<tr>
<td><a href="#">删除</a>/<a href="#">修改</a></td>
</tr>
</table>
</div>
<div style="margin-left:155px;">
<table >
<tr>
<td><a href="#">删除</a>/<a href="#">修改</a></td>
</tr>
</table>
</div>
<div style="margin-left:155px;">
<table >
<tr>
<td><a href="#">删除</a>/<a href="#">修改</a></td>
</tr>
</table>
</div> --%>
</body>
</html>