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

灰太狼 2022-11-02 00:59 230阅读 0赞

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;

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关停车场信息管理系统（SqlServer数据库课程设计）

相关课程管理-在线考试系统

相关 JavaWeb：实现酒店管理系统（课程设计完整版）

相关 SCAU课程课设教务信息管理系统

相关基于Java的课程管理系统

相关操作系统课程设计-文件管理系统（JAVA)

相关《管理信息系统》课程笔记

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

相关汽车信息管理系统（课程设计））

相关 c++实现课程管理系统