student_manager.java

java语言编写的程序

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.Student;

public class Student_Manager {
	public static void Add_Student(String name,int grade_id,
			String image,String sex)
	{
		String xingbie="";
		if(sex.equals("male"))
		{
			xingbie="男";
		}
		else
		{
			xingbie="女";
		}
		try
		{
			name = new String(name.getBytes("ISO8859_1"));
			image = new String(image.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query= "insert into student(name,grade_id,image,sex)values('"+name+
			"','"+grade_id+"','"+image+"','"+xingbie+"')";
		
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	
	public static void Edit_Student(int id,String name,int grade_id,
			String image,String sex)
	{
		String xingbie="";
		if(sex.equals("male"))
		{
			xingbie="男";
		}
		else
		{
			xingbie="女";
		}
	
		try
		{
			name = new String(name.getBytes("ISO8859_1"));
			image = new String(image.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	
		String query= "update student set name='"+name+
		"',grade_id='"+grade_id+"',image='"+image+
		"',sex='"+xingbie+"' where id="+id;
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void Delete_Student(int id)
	{
		String query="delete from student where id="+id;
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	
	public static Student getStudent(int ID)
	{
		String selectStr = "Select * from student where id="+ID;
		Connection con =DataProcess.getConnection();
		Student student = Student.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 image=rs.getString("image");
				int  grade_id=rs.getInt("grade_id");
				
				
				student.setId(ID);
				student.setName(name);
				student.setSex(sex);				
				student.setImage(image);
				student.setGrade_id(grade_id);				
			}
			rs.close();
			stmt.close();
			con.close();
			return student;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
	
	public static ArrayList getStudentList()
	{
		String query="select * from student ";
		Connection con =DataProcess.getConnection();
		ArrayList sl = 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 sex = rs.getString("sex");				
				String image = rs.getString("image");
				int grade_id=rs.getInt("grade_id");
				
				
				Student student = Student.getInstance();
				
				student.setId(ID);
				student.setName(name);
				student.setSex(sex);
				student.setImage(image);
				student.setGrade_id(grade_id);
				
				sl.add(student);
			}
			
			rs.close();
			stmt.close();
			con.close();
			return sl;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
}