20201023 千锤百炼软工人
今天完成了之前新课程添加链接数据库
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<script language="JavaScript">
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
function isValidate(form)
{
// 得到用户输入的信息
userteacher = form.teacher.value;
userwhere = form.where.value;
// 判断老师名称
if(!minLength(userteacher))
{
alert("教师名称错误！");
form.userteacher.focuqs();
return false;
}
// 判断教室名称
if(!minLength(userwhere))
{
alert("教室名称错误！");
form.userwhere.focus();
return false;
}
//验证教师名称
function minLength(str)
{
var str1 = "TeacherWang";
var str1 = "刘立嘉";
var str1 = "刘丹";
var str1 = "王辉";
var str1 = "杨子光";
if(str==str1||str==str2||str==str3||str==str4||str==str5)
return true;
else
return false;
}
// 判断教室名称
function maxLength(str)
{
var str1 = "BasicTeachingBuilding";
var str2 = "一教";
var str3 = "二教";
var str4 = "三教";
if(str==str1||str==str2||str==str3||str==str4)
return true;
else
return false;
}
</script>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>新课程添加</title>
</head>
<body>
<form name="form1" action="daoru.jsp" method="post"
onsubmit = "return isValidate(form1)">
<table align="center">
<tr>
<td>课程名称</td>
<td><input type="text" name="name">
</td>
</tr>
<tr>
<td>任课老师</td>
<td><input type="text" name="teacher">
</td>
</tr>
<tr>
<td>上课地点</td>
<td><input type="text" name="where">
</td>
</tr>
<tr>
<td><input type="submit" value="保存"></td>
</tr>
</table>
</form>
</body>
</html>
<%@page import="Course.Courseadd"%>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>添加</title>
</head>
<body>
<jsp:useBean id="course" class="Course.Courseadd"></jsp:useBean>
<jsp:setProperty name="course" property="*"/>
<%
Connection conn =null;
try{
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
out.print("驱动器加载失败");
}
String url = ("jdbc:mysql://localhost:3306/course_web?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone = GMT&allowPublicKeyRetrieval=true");
String username = "root";
String password = "15531238359";
try{
conn = DriverManager.getConnection(url,username,password);
}catch (SQLException e){
out.println(e.getMessage());
out.println("数据库连接失败");
}
if(conn != null){
String sql = "insert into course3(coursename,teacher,place)values(?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,course.getName());
ps.setString(2,course.getTeacher());
ps.setString(3,course.getWhere());
int row = ps.executeUpdate();
if(row>0){
out.println("成功添加了" + row + "条数据！");
}
}
}catch (Exception e){
e.printStackTrace();
out.print("课程信息添加失败！");
}
%>
<br>
<a href="Course.jsp">返回</a>
</body>
</html>
package Course;
public class Courseadd {
String name;
String teacher;
String where;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getTeacher() {
return teacher;
}
public void setTeacher(String teacher) {
this.teacher = teacher;
}
public String getWhere() {
return where;
}
public void setWhere(String where) {
this.where = where;
}
}
