课堂测试七

---恢复内容开始---

题目要求：

按照图片要求设计添加新课程界面。（0.5分）在后台数据库中建立相应的表结构存储课程信息。（0.5分）实现新课程添加的功能。要求判断任课教师为王建民、刘立嘉、刘丹、王辉、杨子光五位教师的其中一位。（0.5分）要求上课地点开头为“一教、二教、三教、基教”中的一种。（0.5分）实现数据存储功能。（3分）

课堂练习设计思想：

课堂测试设计思路：

1. 建立课程类封装课程信息

2. dao包对添加信息的操作方法对数据库进行相应的操作

3. util包对数据库进行链接，驱动，链接对象，传输对象，接收结果集，遍历结果集，关闭资源

4. jsp文件构建web界面，用web页面对.java传值user函数对数据库进行操作，数据库信息返回到web页面

源程序代码：

package com.jaovo.msg.user;

/**

* @author 李奇原信1605-3 20163525

* @time 2017/11/28/10:30-12:00/16:00-17:30

public class Bean {

/**

* 设置get,set函数，构造函数

private int id;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

private String classteacher;

private String classname;

private String classspace;

public String getClassteacher() {

return classteacher;

}

public void setClassteacher(String classteacher) {

this.classteacher = classteacher;

}

public String getClassname() {

return classname;

}

public void setClassname(String classname) {

this.classname = classname;

}

public String getClassspace() {

return classspace;

}

public void setClassspace(String classspace) {

this.classspace = classspace;

}

package com.jaovo.msg.user;

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 com.jaovo.msg.Util.DBUtil;

import com.jaovo.msg.Util.UserException;

//import sun.net.www.content.text.plain;

public class Dao {

public void gets(Bean st) {

ResultSet resultSet=null;

PreparedStatement preparedStatement = null;

Connection connection = DBUtil.getConnection();

String sql = "insert into t_class(classname,classteacher,classspace) values(?,?,?)";

try {

preparedStatement = connection.prepareStatement(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

preparedStatement.setString(1, st.getClassname());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

preparedStatement.setString(2, st.getClassteacher());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

preparedStatement.setString(3, st.getClassspace());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

preparedStatement.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

DBUtil.close(resultSet);

DBUtil.close(preparedStatement);

DBUtil.close(connection);

}

package com.jaovo.msg.Util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBUtil {

public static Connection getConnection() {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String username = "root";

String password = "LQYroot";

String url = "jdbc:mysql://localhost:3306/class";

Connection connection = null;

try {

connection = DriverManager.getConnection(username,password,url);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return connection;

}

public static void close(Connection connection ) {

try {

if (connection != null) {

connection.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public static void close(PreparedStatement preparedStatement ) {

try {

if (preparedStatement != null) {

preparedStatement.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public static void close(ResultSet resultSet ) {

try {

if (resultSet != null) {

resultSet.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

package com.jaovo.msg.Util;

public class UserException extends RuntimeException{

public UserException() {

super();