第一个:“insert.jsp”文件
<%@ 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>添加课程</title>
</head>
<body>
<form action="insertjudge.jsp">
<table>
<h2>请输入要添加的课程信息:</h2>
<tr>
<td>课程号:</td>
<td><input type="text" name="cno"></td>
</tr>
<tr>
<td>课程名:</td>
<td><input type="text" name="cname"></td>
</tr>
<tr>
<td>开课学期:</td>
<td><input type="text" name="cterm"></td>
</tr>
<tr>
<td>开课专业:</td>
<td><input type="text" name="cmajor"></td>
</tr>
<tr>
<td>学时:</td>
<td><input type="text" name="chour"></td>
</tr>
<tr>
<td>学分:</td>
<td><input type="text" name="ccredit"></td>
</tr>
<tr>
<td>任课教师:</td>
<td><input type="text" name="tno"></td>
</tr>
<tr>
<td>课程介绍:</td>
<td><textarea name="cIntro" rows="3" cols="20"></textarea></td>
</tr>
<tr><td> </td><td> </td></tr>
<tr align="center">
<td><input type="submit" value="添加" name="submit"></td>
<td><input type="reset" value="重置" name="reset"></td>
</tr>
</table>
</form>
</body>
</html>
第二个(跳转的页面):“insertjudge.jsp”
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!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>添加数据判断</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
String cno=request.getParameter("cno");
String cname=request.getParameter("cname");
String cterm=request.getParameter("cterm");
String cmajor=request.getParameter("cmajor");
String chour=request.getParameter("chour");
String ccredit=request.getParameter("ccredit");
String tno=request.getParameter("tnum");
String cintro=request.getParameter("cintro");
String url = "jdbc:mysql://localhost:3306/scms?"+ "useSSL=false&serverTimezone=CST&characterEncoding=utf-8"; //连接串
String user="root";
String password="2001511ty";
Class.forName("com.mysql.cj.jdbc.Driver"); //加载驱动
Connection conn=DriverManager.getConnection(url,user,password); //创建与数据库的连接
Statement stmt=conn.createStatement(); //执行sql语句
String sql="INSERT INTO course VALUES('"+cno+"','"+cname+"','"+cterm+"','"+cmajor+"','"+chour+"','"+ccredit+"','"+tno+"','"+cintro+"')";
int i=stmt.executeUpdate(sql);
if(i==1){
%>
<h2>记录添加成功</h2>
<%}
else{
%>
<h2>记录添加失败!</h2>
<%}
stmt.close();
conn.close();
%>
</body>
</html>
第二个文件的第28行有错误,不知道错在哪里了:
这个是数据库的表: