techmanager.java

精品课程的java源码

package com.zzx.manager;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

import com.zzx.bean.Teacher;
import com.zzx.bean.Users;
import com.zzx.util.DataConn;

public class TechManager{
  
	 Connection conn = null;
	 PreparedStatement psmt = null;
	
    
	
	 // 对老师信息插入的操作
	public void insert(Teacher tech) {
		String sql = "insert into teacher (name,sex,zhichen,fangxiang,renwu) values(?,?,?,?,?);";
		
		try {
			conn = new DataConn().getConn();
			psmt = conn.prepareStatement(sql);
			psmt.setString(1, tech.getName());
			psmt.setString(2, tech.getSex());
			psmt.setString(3, tech.getZhichen());
			psmt.setString(4, tech.getFangxiang());
			psmt.setString(5, tech.getRenwu());
			psmt.executeUpdate();
			psmt.close();
			System.out.println("teacher insert successfully!");
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}

    // 对老师信息进行删除的操作
	public void delete(int id) throws Exception {

		String sql = "delete from teacher where id=?";
		try {
			conn = new DataConn().getConn();
			psmt = conn.prepareStatement(sql);
			psmt.setInt(1, id);
			psmt.executeUpdate();
			psmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}


  // 对消息进行更新的操作
    public void updateTeacher(Teacher tech){
   	     
    	String sql = "UPDATE teacher SET name=?,sex=?,zhichen=? fangxiang=? renwu=? WHERE id=?" ;		 	 
		 try {
			    conn = new DataConn().getConn();
				psmt = conn.prepareStatement(sql);					
				psmt.setString(1, tech.getName());
				psmt.setString(2, tech.getSex());
				psmt.setString(3, tech.getZhichen());
				psmt.setString(4, tech.getFangxiang());
				psmt.setString(5, tech.getRenwu());	
				psmt.setInt(6, tech.getId());	
				psmt.executeUpdate();
				psmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}			 
    }

//对老师信息查询的操作
	public List queryUser() {

		String sql = "select * from teacher";
		List all = new ArrayList();
		ResultSet rs = null;
		try {
			conn = new DataConn().getConn();
			psmt = conn.prepareStatement(sql);
			rs = psmt.executeQuery();

			while (rs.next()) {
				Teacher teacher = new Teacher();
				teacher.setName(rs.getString(1));
				teacher.setSex(rs.getString(2));
				teacher.setZhichen(rs.getString(3));
				teacher.setFangxiang(rs.getString(4));
				teacher.setRenwu(rs.getString(5));
				
				all.add(teacher);
			}
			rs.close();
			psmt.close();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return all;

	}

	// 对老师信息进行分页查询的操作
	public List queryTeacher(int currentPage, int lineSize) {

		int count = currentPage*lineSize;
		String sql  = "select TOP "+lineSize+" * FROM ( SELECT TOP "+count+"  * from teacher  ORDER BY id ASC ) as aSysTable ORDER BY id DESC";
		
		//String sql = "select * from teacher limit " +(currentPage-1)*lineSize+"," +lineSize ;
		
		List all = new LinkedList();
		ResultSet rs = null;
		try {
			conn = new DataConn().getConn();
			psmt = conn.prepareStatement(sql);
			rs = psmt.executeQuery();


			while (rs.next()) {
				Teacher tech = new Teacher();
                tech.setId(rs.getInt(1));
				tech.setName(rs.getString(2));
				tech.setSex(rs.getString(3));
				tech.setZhichen(rs.getString(4));
				tech.setFangxiang(rs.getString(5));
				tech.setRenwu(rs.getString(6));
				all.add(tech);
			}
			rs.close();
			psmt.close();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return all;

	}

	
	
	//// 根据老师姓名进行查询的操作
	public Teacher queryByName(String name) {
		
		String sql = "SELECT id,name,sex, zhichen,fangxiang,renwu from teacher WHERE username=?";	
		ResultSet rs = null;
		Teacher tech = new Teacher();
		try {
			conn = new DataConn().getConn();
			psmt = conn.prepareStatement(sql);
			psmt.setString(1, name);
			rs = psmt.executeQuery();
			
			if(rs.next()){
				tech.setId(rs.getInt(1));
				tech.setName(rs.getString(2));
				tech.setSex(rs.getString(3));
				tech.setZhichen(rs.getString(4));
				tech.setFangxiang(rs.getString(5));
				tech.setRenwu(rs.getString(6));
				}
			rs.close();
			psmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return  tech;
	}
	
	
	// 查询消息的总数
	public int queryCount() {
		int count = 0;
		ResultSet rs = null;
		String sql = "SELECT count(*) FROM teacher";
		try {
			conn = new DataConn().getConn();
			psmt = conn.prepareStatement(sql);
			rs = psmt.executeQuery();
			while (rs.next()) {
				count = rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		//System.out.println(count);
		return count;
	}
    
    
//	public static void main(String[] args){
//		
//		TechManager um =new TechManager();		
//		Teacher tech = new Teacher();
//		
//
//	}
}