jstl 模糊比较_javaweb之模糊查询

packagedao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;//import com.mysql.cj.protocol.ResultBuilder;

importBean.Course;importutil.DBUtil;public classdaoCourse {public booleanadd(Course n)

{boolean f=false;int a=0;

String sql="insert submitcourse(classname,teachername,place) values(?,?,?)";try{

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1,n.getClassname());

pstmt.setString(2,n.getTeachername());

pstmt.setString(3,n.getPlace());

a=pstmt.executeUpdate();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}if(a>0) f=true;returnf;

}public booleandelete(Course n) {boolean f=false;int a=0;

String sql="delete from submitcourse where teachername=?";try{

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1,n.getTeachername());

a=pstmt.executeUpdate();

System.out.println("fuck you");

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}if(a>0) f=true;returnf;

}public Listlist(){

String sql="select * from submitcourse";

List list=new ArrayList<>();

ResultSet rs=null;

Course ns=newCourse();try{

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt=conn.prepareStatement(sql);//pstmt.setString(1,n.getTeachername());

rs=pstmt.executeQuery();while(rs.next())

{

ns=new Course(rs.getString(1),rs.getString(2),rs.getString(3));

list.add(ns);

}//System.out.println(rs);

System.out.println(rs);

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnlist;

}public booleanupdate(Course n,String old_teachername){boolean f=false;int a=0;

String sql= "update submitcourse set classname='"+n.getClassname()+"',teachername='"+n.getTeachername()+"',place='"+n.getPlace()+"' where teachername='"+old_teachername+"'";try{

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt=conn.prepareStatement(sql);

a=pstmt.executeUpdate();

System.out.println(a);

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}if(a>0) f=true;returnf;

}publicCourse queryByTeachername(String teachername) {

String sql="select * from submitcourse where teachername=?";

Course n=newCourse();try{

ResultSet rs=null;

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1,teachername);

rs=pstmt.executeQuery();while(rs.next()) {

n=new Course(rs.getString(1), rs.getString(2),rs.getString(3));

}

System.out.println("fuck you");

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnn ;

}public ListsearchByTeachername(String teachername){//模糊查询

List ns=new ArrayList();

String sql="select * from submitcourse where teachername like ?";

ResultSet rs=null;try{

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1, "%"+teachername+"%");

rs=pstmt.executeQuery();while(rs.next())

{

Course n=new Course(rs.getString(1),rs.getString(2),rs.getString(3));

ns.add(n);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnns;

}

}