teacher_manager.java

来自「java语言编写的程序」· Java 代码 · 共 178 行

package cn.lab.business;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import cn.lab.dbquery.DataProcess;
import cn.lab.object.Teacher;

public class Teacher_Manager {
	public static void Add_Teacher(String name,String sex,
			String zhicheng,String image,String info)
	{
		String xingbie="";
		if(sex.equals("male"))
		{
			xingbie="男";
		}
		else
		{
			xingbie="女";
		}
		try
		{
			name = new String(name.getBytes("ISO8859_1"));
			zhicheng = new String(zhicheng.getBytes("ISO8859_1"));
			image = new String(image.getBytes("ISO8859_1"));
			info = new String(info.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query= "insert into teacher(name,sex,zhicheng,image,info)values('"+name+
			"','"+xingbie+"','"+zhicheng+"','"+image+"','"+info+"')";
		
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void Edit_Teacher(String name,String sex,
			String zhicheng,String image,String info,int id)
	{
		String xingbie="";
		if(sex.equals("male"))
		{
			xingbie="男";
		}
		else
		{
			xingbie="女";
		}
	
		try
		{
			name = new String(name.getBytes("ISO8859_1"));
			zhicheng = new String(zhicheng.getBytes("ISO8859_1"));
			image = new String(image.getBytes("ISO8859_1"));
			info = new String(info.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	
		String query= "update teacher set name='"+name+"',sex='"+xingbie+
			"',zhicheng='"+zhicheng+"',image='"+image+"',info='"+info+
				"' where id="+id;
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public static void Delete_Teacher(int id)
	{
		String query="delete from teacher where id="+id;
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}	
	public static Teacher getTeacher(int ID)
	{
		String selectStr = "Select * from teacher where id="+ID;
		Connection con =DataProcess.getConnection();
		Teacher teacher = Teacher.getInstance();
		
		try
		{
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(selectStr);
			if(rs.next())
			{
				String name=rs.getString("name");
				String sex=rs.getString("sex");
				String zhicheng=rs.getString("zhicheng");
				String image=rs.getString("image");
				String info=rs.getString("info");
				
				teacher.setId(ID);
				teacher.setName(name);
				teacher.setSex(sex);
				teacher.setZhicheng(zhicheng);
				teacher.setImage(image);
				teacher.setInfo(info);
			}
			rs.close();
			stmt.close();
			con.close();
			return teacher;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
	
	public static ArrayList getTeacherList()
	{
		String query="select * from teacher ";
		Connection con =DataProcess.getConnection();
		ArrayList tl = new ArrayList();
		
		try
		{
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{
				int ID = rs.getInt("id");
				String name = rs.getString("name");
				String info = rs.getString("info");
				String sex = rs.getString("sex");
				String zhicheng = rs.getString("zhicheng");
				String image = rs.getString("image");
				
				
				
				Teacher teacher = Teacher.getInstance();
				
				teacher.setId(ID);
				teacher.setName(name);
				teacher.setSex(sex);
				teacher.setZhicheng(zhicheng);
				teacher.setImage(image);
				teacher.setInfo(info);
				
				tl.add(teacher);
			}
			
			rs.close();
			stmt.close();
			con.close();
			return tl;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}

	
}