软件工程概论

1、设计思想

在mysql中建立一个数据库，并在其中建立相应的表。建立一个类，将表中的基本属性设为该类的私有成员变量，编写连接数据库的方法，向表中插入数据（即添加课程信息）。编写一个方法，

其可判断输入的信息与表中的信息是否相等来完成对课程信息的查询，创建相应的jsp或html文件，完成相应的界面跳转与显示。

2、源程序

package bean;

public class Userbean {

private String coursename;

private String teacher;

private String local;

public String getcoursename() {

return coursename;

}

public void setcoursename(String username) {

this.coursename = username;

}

public String getteacher() {

return teacher;

}

public void setteacher(String teacher) {

this.teacher = teacher;

}

public String getlocal() {

return local;

}

public void setlocal(String local) {

this.local = local;

}

package dao;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import DUBtil.DBUtil;

import bean.Userbean;

public class Userdao {

public boolean register(Userbean userbean)

{

boolean flag=false;

Connection conn=DBUtil.getConn();

Statement state=null; //Statement对象，用于执行不带参数的简单SQL语句

String sql="insert into course(coursename,teacher,local) values('"+userbean.getcoursename()+"','"+userbean.getteacher()+"','"+userbean.getlocal()+"')";

try

{

state=conn.createStatement();

state.executeUpdate(sql);

flag=true;

}

catch(Exception e)

{

e.printStackTrace();

flag=false;

}

finally

{

DBUtil.close(state,conn);

}

return flag;

}

public boolean Checklogin(String coursename,String teacher)

{

boolean flag=false;

Connection conn=DBUtil.getConn();

Statement state=null;

ResultSet rs=null; //ResultSet是数据库结果集的数据表

try

{

state=conn.createStatement();

rs=state.executeQuery("select * from course where coursename='"+coursename+"'");

if(rs.next())

{

if(rs.getString("teacher").equals(teacher))

{

flag=true;

}

catch(Exception e)

{

e.printStackTrace();

}

finally

{

DBUtil.close(rs,state,conn);

}

return flag;

}

package DUBtil;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DBUtil

{

public static String db_url="jdbc:mysql://localhost:3306/Lvyouba?uerUnicode=true&characterEncoding=UTF-8";

public static String db_user="root";

public static String db_password="root";

public static Connection getConn()

{

Connection conn=null;

try

{

Class.forName("com.mysql.jdbc.Driver"); //加载数据库驱动

conn=DriverManager.getConnection(db_url,db_user,db_password);

}

catch(Exception e)

{

e.printStackTrace();

}

return conn;

}

public static void close(Statement state,Connection conn)//关闭

{

if(state!=null)//判断

{

try

{

state.close();

}

catch(SQLException e)

{

e.printStackTrace();

}

if(conn!=null)

{

try

{

conn.close();

}

catch(SQLException e)

{

e.printStackTrace();

}

public static void close(ResultSet rs,Statement state,Connection conn)

{

if(rs!=null)

{

try

{

rs.close();

}

catch(SQLException e)

{

e.printStackTrace();

}

if(state!=null)

{

try

{

state.close();

}

catch(SQLException e)

{

e.printStackTrace();

}

if(conn!=null)

{

try

{

conn.close();

}

catch(SQLException e)

{

e.printStackTrace();

}

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.lang.reflect.InvocationTargetException;

import java.lang.reflect.Method;

public class BaseServlet extends HttpServlet {

private static final long serialVersionUID = -7039609732089204655L;

@Override

protected void service(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding("utf-8");

// TODO Auto-generated method stub

try {

String method=request.getParameter("method");

Method m=this.getClass().getMethod(method, HttpServletRequest.class,HttpServletResponse.class);

m.invoke(this, request,response);

} catch (SecurityException e) {