1.设计思想
先写类DBUtil用来连接数据库。在UserDaoImpl2类中写在数据库中添加课程表信息的方法。然后定义类Calss2来写保存超级课表数据：课程名称，任课教师，上课地点的属性及其get和set方法。新建Calss.jsp文件来写保存功能的界面，doClass.jsp文件来接受Class.jsp文件传过来的参数，如果参数不正确，则给出提示并且依旧在保存功能页面，如果正确则跳转页面提示保存成功。新建ValidateUtil类，在类中的方法中判断三个参数是否正确，若不正确并返回错误信息。在doCalss类中调用此方法。
2.源程序代码
packagecom.jaovo.msg.Util;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;public classDBUtil {public staticConnection getConnection() {try{//1 加载驱动
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
}catch (InstantiationException | IllegalAccessException |ClassNotFoundException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
String user= “root”;
String password= “root”;
String url= “jdbc:mysql://localhost:3307/jaovo_msg”;//定义工具类
Connection connection = null;try{//2 创建链接对象connection
connection =DriverManager.getConnection(url,user,password);
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}returnconnection;
}//关闭资源的方法
public static voidclose(Connection connection ) {try{if (connection != null) {
connection.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}public static voidclose(PreparedStatement preparedStatement ) {try{if (preparedStatement != null) {
preparedStatement.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}public static voidclose(ResultSet resultSet ) {try{if (resultSet != null) {
resultSet.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}
}
packagecom.jaovo.msg.model;public classClass2 {privateString classname;privateString teacher;privateString address;publicString getClassname() {returnclassname;
}public voidsetClassname(String classname) {this.classname =classname;
}publicString getTeacher() {returnteacher;
}public voidsetTeacher(String teacher) {this.teacher =teacher;
}publicString getAddress() {returnaddress;
}public voidsetAddress(String address) {this.address =address;
}
}
packagecom.jaovo.msg.dao;import com.jaovo.msg.model.*;public interfaceIUserDao2 {public voidadd(Class2 class2);
}
packagecom.jaovo.msg.dao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importcom.jaovo.msg.Util.DBUtil;importcom.jaovo.msg.model.Class2;public class UserDaoImpl2 implementsIUserDao2{
@Overridepublic voidadd(Class2 class2) {//获得链接对象
Connection connection =DBUtil.getConnection();//准备sql语句
PreparedStatement preparedStatement= null;
ResultSet resultSet= null;try{
String sql= “insert into t_class(classname,teacher,address) value (?,?,?)”;
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1, class2.getClassname());
preparedStatement.setString(2,class2.getTeacher());
preparedStatement.setString(3,class2.getAddress());
preparedStatement.executeUpdate();
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}finally{//关闭资源
DBUtil.close(resultSet);
DBUtil.close(preparedStatement);
DBUtil.close(connection);
}
}
}
packagecom.jaovo.msg.Util;importjava.util.HashMap;importjava.util.Map;importjavax.servlet.http.HttpServletRequest;public classValidateUtil {public static booleanvalidateNull(HttpServletRequest request,String[] fileds) {boolean validate = true;//map对象用来装载不同的错误信息
Map errorMsg = newHashMap();for(int i=0;i<3;i++) {
String value=request.getParameter(fileds[i]);if(i==1) {if(value.equals(“王建民”)||value.equals(“刘立嘉”)||value.equals(“刘丹”)||value.equals(“王辉”)||value.equals(“杨子光”))
{
validate=true;
}else{
validate= false;
errorMsg.put(fileds[i],”教师不正确”);
}
}if(i==2) {boolean a[]=new boolean[4];
String[] sub={“一教”,”二教”,”三教”,”基教”};for(int j=0;j<4;j++) {
a[i]=value.startsWith(sub[j]);
}boolean is=false;for(int k=0;k<4;k++) {if(a[i]==true)
is=true;
}if(is==true)
{
validate=true;
}else{
validate= false;
errorMsg.put(fileds[i],”教室不正确”);
}if (!validate) {
request.setAttribute(“errormsg”, errorMsg);
}
}
}returnvalidate;
}public staticString showError(HttpServletRequest request , String filed) {
Map errorMsg = (Map)request.getAttribute(“errormsg”);if (errorMsg == null) {return “”;
}
String msg=errorMsg.get(filed);if (msg == null) {return “”;
}returnmsg;
}
}
Insert title here
errorMsg=(Map)request.getAttribute(“errormsg”);%>
课程名称 任课教师 上课地点Insert title here
//接收客户端传递过来的参数Stringclassname=request.getParameter(“classname”);Stringteacher=request.getParameter(“teacher”);Stringaddress=request.getParameter(“address”);booleanvalidate=ValidateUtil.validateNull(request,new String[]{“classname”,”teacher”,”address”});if(!validate){%>
Class2 class2= newClass2();
class2.setClassname(classname);
class2.setTeacher(teacher);
class2.setAddress(address);
UserDaoImpl2 userDao2= newUserDaoImpl2();
userDao2.add(class2);
out.println(“添加成功！！”);%>
