java 课程管理系统_javaweb课程信息管理系统

packagedao;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;importutil.Util;importbin.Course;/*** 课程Dao

* Dao层操作数据

*@authorYP*/

public classCourseDao {/*** 添加

*@paramcourse

*@return

*/

public booleanadd(Course course) {

String sql= "insert into course(name, teach, local) values('" + course.getName() + "','" + course.getTeach() + "','" + course.getLocal() + "')";//创建数据库链接

Connection conn =Util.getConn();

Statement state= null;boolean f = false;int a = 0;try{

state=conn.createStatement();

state.executeUpdate(sql);

}catch(Exception e) {

e.printStackTrace();

}finally{//关闭连接

Util.close(state, conn);

}if (a > 0) {

f= true;

}returnf;

}/*** 删除

*

*@paramid

*@return

*/

public boolean delete (intid) {boolean f = false;

String sql= "delete from course where id='" + id + "'";

Connection conn=Util.getConn();

Statement state= null;int a = 0;try{

state=conn.createStatement();

a=state.executeUpdate(sql);

}catch(SQLException e) {

e.printStackTrace();

}finally{

Util.close(state, conn);

}if (a > 0) {

f= true;

}returnf;

}/*** 修改

*@paramname

*@parampass*/

public booleanupdate(Course course) {

String sql= "update course set name='" + course.getName() + "', teach='" + course.getTeach() + "', local='" +course.getLocal()+ "' where id='" + course.getId() + "'";

Connection conn=Util.getConn();

Statement state= null;boolean f = false;int a = 0;try{

state=conn.createStatement();

a=state.executeUpdate(sql);

}catch(SQLException e) {

e.printStackTrace();

}finally{

Util.close(state, conn);

}if (a > 0) {

f= true;

}returnf;

}/*** 验证课程名称是否唯一

* true --- 不唯一

*@paramname

*@return

*/

public booleanname(String name) {boolean flag = false;

String sql= "select name from course where name = '" + name + "'";

Connection conn=Util.getConn();

Statement state= null;

ResultSet rs= null;try{

state=conn.createStatement();

rs=state.executeQuery(sql);while(rs.next()) {

flag= true;

}

}catch(SQLException e) {

e.printStackTrace();

}finally{

Util.close(rs, state, conn);

}returnflag;

}/*** 通过ID得到课程信息

*@paramid

*@return

*/

public Course getCourseById(intid) {

String sql= "select * from course where id ='" + id + "'";

Connection conn=Util.getConn();

Statement state= null;

ResultSet rs= null;

Course course= null;try{

state=conn.createStatement();

rs=state.executeQuery(sql);while(rs.next()) {

String name= rs.getString("name");

String teach= rs.getString("teach");

String local= rs.getString("local");

course= newCourse(id, name, teach, local);

}

}catch(Exception e) {

e.printStackTrace();

}finally{

Util.close(rs, state, conn);

}returncourse;

}/*** 通过name得到Course

*@paramname

*@return

*/

publicCourse getCourseByName(String name) {

String sql= "select * from course where name ='" + name + "'";

Connection conn=Util.getConn();

Statement state= null;

ResultSet rs= null;

Course course= null;try{

state=conn.createStatement();

rs=state.executeQuery(sql);while(rs.next()) {int id = rs.getInt("id");

String teach= rs.getString("teach");

String local= rs.getString("local");

course= newCourse(id, name, teach, local);

}

}catch(Exception e) {

e.printStackTrace();

}finally{

Util.close(rs, state, conn);

}returncourse;

}/*** 查找

*@paramname

*@paramteach

*@paramlocal

*@return

*/

public Listfind(String name, String teach, String local) {

String sql= "select * from course where ";if (name != "") {

sql+= "name like '%" + name + "%'";

}if (teach != "") {

sql+= "teach like '%" + teach + "%'";

}if (local != "") {

sql+= "local like '%" + local + "%'";

}

List list = new ArrayList<>();

Connection conn=Util.getConn();

Statement state= null;

ResultSet rs= null;try{

state=conn.createStatement();

rs=state.executeQuery(sql);

Course bean= null;while(rs.next()) {int id = rs.getInt("id");

String name2= rs.getString("name");

String teach2= rs.getString("teach");

String local2= rs.getString("local");

bean= newCourse(id, name2, teach2, local2);

list.add(bean);

}

}catch(SQLException e) {

e.printStackTrace();

}finally{

Util.close(rs, state, conn);

}returnlist;

}/*** 全部数据

*@paramname

*@paramteach

*@paramlocal

*@return

*/

public Listlist() {

String sql= "select * from course";

List list = new ArrayList<>();

Connection conn=Util.getConn();

Statement state= null;

ResultSet rs= null;try{

state=conn.createStatement();

rs=state.executeQuery(sql);

Course bean= null;while(rs.next()) {int id = rs.getInt("id");

String name2= rs.getString("name");

String teach2= rs.getString("teach");

String local2= rs.getString("local");

bean= newCourse(id, name2, teach2, local2);

list.add(bean);

}

}catch(SQLException e) {

e.printStackTrace();

}finally{

Util.close(rs, state, conn);

}returnlist;

}

}