新课程添加
(1)题目要求
1.新课程信息必须唯一，如有重复，提示用户“课程名称重复，重新录入”；
2.要求判断任课教师为王建民、刘立嘉、刘丹、杨子光、张云霞、武勇亮、高飞七位教师的其中一位。
3.要求上课地点开头为“一教、二教、三教、基教”中的一种；
4.将新课程信息添加入库。
(2)源代码
com.Bean
package com.Bean; public class Userbean { private String teachername; private String place; private String classname; public String getTeachername() { return teachername; } public void setTeachername(String teachername) { this.teachername = teachername; } public String getPlace() { return place; } public void setPlace(String place) { this.place = place; } public String getClassname() { return classname; } public void setClassname(String classname) { this.classname = classname; } }
com.Dao
package com.Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.Util.Userutil; import com.Bean.Userbean; public class Userdao { public void add(Userbean claz) throws ClassNotFoundException, SQLException { //获得链接对象 Connection connection = Userutil.getConnection(); //准备sql语句 String sql = "insert into course(teachername,classname,place) values(?,?,?)"; PreparedStatement preparedStatement = null; try { //创建语句传输对象 preparedStatement = connection.prepareStatement(sql); // preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, claz.getTeachername()); preparedStatement.setString(2, claz.getClassname()); preparedStatement.setString(3, claz.getPlace()); preparedStatement.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { //关闭资源 //DBUtil.close(preparedStatement); //DBUtil.close(connection); } } }
com.Util
package com.Util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Userutil { public static Connection getConnection() throws ClassNotFoundException, SQLException { Connection connection = null;//连接数据库 Statement stmt = null;//Statement 对象用于将 SQL 语句发送到数据库中。 ResultSet rs = null; //1. 导入驱动jar包 //2.注册驱动 Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db3", "root", "mysqlmima"); 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(); } } }
add.jsp
<%@page import="com.Bean.Userbean"%> <%@page import="com.Dao.Userdao"%> <%@ 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> <% //接收客户端传递过来的参数 String teachername = request.getParameter("teachername"); String classname = request.getParameter("classname"); String place = request.getParameter("place"); //try{ if(!teachername.trim().equals("王建民")&&!teachername.trim().equals("刘立嘉")&&!teachername.trim().equals("刘丹")&&!teachername.trim().equals("王辉")&&!teachername.trim().equals("杨子光")) { //throw new ClassException("不能输入规定之外的老师名称"); } else if(!place.trim().startsWith("基教")&&!place.trim().startsWith("一教")&&!place.trim().startsWith("二教")&&!place.trim().startsWith("三教")) { // throw new ClassException("不能输入规定之外的地点名称！"); } else { Userbean A = new Userbean(); A.setTeachername(teachername); A.setClassname(classname); A.setPlace(place); Userdao Dao = new Userdao(); Dao.add(A); } %> </html>
jiemian.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>
<title>课程添加页面</title>
</head>
<body>
<form action="add.jsp" method="get">
<table align="center" border="1" width="500">
<tr>
<td>课程名称 : </td>
<td>
<input type="text" name="classname" />
</td>
</tr>
<tr>
<td>任课教师:</td>
<td>
<input type="text" name="teachername" />
</td>
</tr>
<tr>
<td>上课地点:</td>
<td>
<input type="text" name="place" />
</td>
</tr>
<tr align="center">
<td colspan="2">
<input type="submit" value="提交" />
<input type="reset" value="重置" />
</td>
</tr>
</table>
</form>
</body>
</html>
