java servlet mysql_Servlet+纯java+MySQL实现课程信息的增删改查

packagecom.zh.dao;import java.util.*;import java.sql.*;import com.zh.entity.*;import com.zh.util.*;import java.sql.*;public classdata_dao {/*增加

**/

public voidadd(bean Bean) {

String sql="insert into class_message values('"+Bean.get_place()+"','"+Bean.get_teacher_name()+"','"+Bean.get_class_name()+"')";

Connection conn=DButil.getConnection();

Statement state= null;try{

state=conn.createStatement();

state.executeUpdate(sql);

}catch(Exception e) {

e.printStackTrace();

}

}/*删除

**/

public voiddeleteByteacher_name(String teacher_name) {boolean f=false;

String sql="delete from class_message where teacher_name='"+teacher_name+"'";

Connection conn=DButil.getConnection();

Statement state= null;try{

state=conn.createStatement();

state.executeUpdate(sql);

}catch(SQLException e) {

e.printStackTrace();

}

}/*修改

**/

public voidupdata(bean b) {

String sql="updata class_message set place='"+b.get_place()+"', teacher_name='"+b.get_teacher_name()+"',class_name='"+b.get_class_name()+"' where teacher_name='"+b.get_teacher_name()+"'";

Connection conn=DButil.getConnection();

Statement state= null;try{

state=conn.createStatement();

state.executeUpdate(sql);

}catch(SQLException e) {

e.printStackTrace();

}

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

public ListisOnly_class_name(String class_name) {

List list=new ArrayList();

String sql="select name from class_message where class_name='"+class_name+"'";

Connection conn=DButil.getConnection();

Statement state=null;

ResultSet rs= null;try{

state=conn.createStatement();

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

String class_name1=rs.getString("class_name");

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

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

bean b=newbean(place,teacher_name,class_name1);

list.add(b);

}

}catch(SQLException e) {

e.printStackTrace();

}returnlist;

}/*** 通过teacher_name获得一个bean对象*/

publicbean findByteacher_name(String teacher_name) {

Connection conn=null;

Statement state=null;try{

conn=DButil.getConnection();

String sql="select*from class_message where teacher_name='"+teacher_name+"'";

state=conn.createStatement();

ResultSet rs=state.executeQuery(sql);

bean u=newbean();;while(rs.next()) {

String t_name=rs.getString("teacher_name");

String c_name=rs.getString("class_name");

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

u.set_class_name(c_name);

u.set_place(place);

u.set_teacher_name(t_name);returnu;

}

}catch(Exception e) {

e.printStackTrace();

}return null;

}/** 显示全部*/

public ListfindAll(){

Connection conn=DButil.getConnection();

List list=new ArrayList();

bean b=null;try{

Statement sta=conn.createStatement();

String sql="select * from class_message";

ResultSet rs=sta.executeQuery(sql);while(rs.next()) {

b=newbean();

String t_name,c_name,place;

t_name=rs.getString("teacher_name");

c_name=rs.getString("c_name");

place=rs.getString("place");

b.set_class_name(c_name);

b.set_place(place);

b.set_teacher_name(t_name);

list.add(b);

}

}catch(Exception e) {

e.printStackTrace();

}for(int i=0;i

bean br=(bean)list.get(i);

System.out.println(br.get_teacher_name());

}returnlist;

}

}