db.java

我实习时候的设计

package cn.yangyulong.teacher;



import java.sql.*;//引用数据库操作包

import cn.yxh.util.DBConn;




public class DB {

	private Connection conn = null;//建立数据库连接对象

	private PreparedStatement stmt = null;//建立数据库操作对象

	private ResultSet rs = null;//建立结果集（用来接收从数据库中查询出来的数据）
	
	private Statement st=null;

	
	public  void updateteacher(String teacherid,String password,String teachername,String sex,String zhicheng,String department)
	{
		conn=DBConn.getConn();
		try {
			stmt=conn.prepareStatement("update teacher set password=?,teachername=?,sex=?,zhicheng=?,department=? where teacherid=? ");
			stmt.setString(1,password);
			stmt.setString(2, teachername);
			stmt.setString(3, sex);
			stmt.setString(4, zhicheng);
			stmt.setString(5, department);
			stmt.setString(6,teacherid);
			stmt.execute();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void saveteacher(String teacherid,String password,String teachername,String sex,String zhicheng,String department)
	{
		conn=DBConn.getConn();
		try {
			stmt=conn.prepareStatement("insert into teacher (teacherid,password,teachername,sex,zhicheng,department) values(?,?,?,?,?,?)"); 
			stmt.setString(1, teacherid);
			stmt.setString(2, password);
			stmt.setString(3, teachername);
			stmt.setString(4, sex);
			stmt.setString(5,zhicheng);
			stmt.setString(6, department);		
			stmt.execute();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
	}

	public ResultSet showteacher(String teachername)//进行模糊查询
	{
		conn=DBConn.getConn();
		try {
			stmt=conn.prepareStatement("select * from teacher where teachername like ?");
			stmt.setString(1, "%"+teachername+"%");
			rs=stmt.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
		
	}
	  public ResultSet showallteacher()//显示所有老师信息
	    {
	    	
	    	conn=DBConn.getConn();
	    	try {
				stmt=conn.prepareStatement("select * from teacher");
				rs=stmt.executeQuery();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return rs;
	    }
	    public ResultSet showsteacher(String teacherid)//以教师编号为关键字返回老师信息
	    {
	    	conn=DBConn.getConn();
	    	try {
				stmt=conn.prepareStatement("select * from teacher where teacherid=?");
			    stmt.setString(1,teacherid);
			    rs=stmt.executeQuery();
	    	} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return rs;
	    }
	    public void delteacher(String teacherid)//删除教师信息
	    {
	 	   conn=DBConn.getConn();
	 	   try {
	 		stmt=conn.prepareStatement("delete from teacher where teacherid=?");
	 		stmt.setString(1,teacherid);
	 		stmt.execute();
	 	} catch (SQLException e) {
	 		// TODO Auto-generated catch block
	 		e.printStackTrace();
	 	}
	    }



}