程序设计思想：
在Input.jsp中创建一个表格里边分别是课程名称，任课老师，教学地点，并分别用三个文本框来接受输入的三个属性，
并传到另外的Jsp页面中，又来接受三个数据，并判断传来的教师，与教室地点是否符合题目要求，若不符合，则设置
一个Error，返回到第一个JSP中，并显示在JSP中，允许重新输入，若符合要求，就想数据库中保存输入的是三个属性。
程序源代码：
连接数据库的源代码：
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.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } String user = "sa"; String password = "123456"; String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jaovo_msg"; Connection connection = null; try { connection = DriverManager.getConnection(url,user,password); } 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.model; public class User { private String name; private String teacher; private String place; 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 getPlace() { return place; } public void setPlace(String place) { this.place = place; } }
向数据库添加数据的源代码：
import com.jaovo.msg.Util.DBUtil; //import com.jaovo.msg.Util.UserException; import com.jaovo.msg.model.User; public class UserDaoImpl { public void add(User user) { Connection connection = DBUtil.getConnection(); PreparedStatement preparedStatement = null; try{ String sql = "insert into t_teacher(name,teacher,place) values (?,?,?)"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getName()); preparedStatement.setString(2, user.getTeacher()); preparedStatement.setString(3, user.getPlace()); preparedStatement.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { //DBUtil.close(resultSet); DBUtil.close(preparedStatement); DBUtil.close(connection); } } }
刚开始输入时的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> <% String s=(String)request.getAttribute("Error"); if("".equals(s)||s==null) { s=""; } %> <%=s %> <form action="LoginInput.jsp" method="get"> <table align="center" border="1"> <tr> <td colspan="2"> 课程名称 <input type="text" name="name"/> </td> </tr> <tr> <td colspan="2"> 任课教师 <input type="text" name="teacher"/> </td> </tr> <tr> <td colspan="2"> 上课地点 <input type="text" name="place"/> </td> </tr> <tr> <td align="center" colspan="2"> <input type="submit" value="保存"/></td> </tr> </table> </form> </body> </html>
结束数据并判断是否符合要求的JSP:
<%@page import="com.jaovo.msg.dao.UserDaoImpl"%> <%@page import="com.jaovo.msg.model.User"%> <%@ 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"> <% int i=0; boolean flag=true; boolean flag1=true; String s[]={"王建民","刘丹","刘立嘉","杨子光","王辉"}; String s1[]={"基教","一教","二教","三教"}; String name=request.getParameter("name"); String teacher=request.getParameter("teacher"); String place=request.getParameter("place"); while(i<s.length) { if(!s[i].equals(teacher)) { flag=false; } else { flag=true; break; } i++; }%> <% if(!flag) { request.setAttribute("Error", "老师不对"); %> <jsp:forward page="Login.jsp"></jsp:forward> <% } i=0; String s3=place.substring(0,2); while(flag==true&&i<s1.length) { if(!s1[i].equals(s3)) { flag1=false; } else { flag1=true; break; } i++; } if(!flag1) { request.setAttribute("Error", "教室不对"); %> <jsp:forward page="Login.jsp"></jsp:forward> <% } UserDaoImpl userdao=new UserDaoImpl(); User user=new User(); user.setName(name); user.setTeacher(teacher); user.setPlace(place); userdao.add(user); System.out.println(teacher); %> <<jsp:forward page="Login.jsp"></jsp:forward>
源程序截图：
