updatesomethingserviceimp.java

基本分数查询功能,自己的毕业设计作品!希望能给大家一点帮助!

package org.xk.service.imp;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.xk.dbutil.Opendb;
import org.xk.po.AdminUser;
import org.xk.po.ClassUser;
import org.xk.po.ScoreUser;
import org.xk.po.StudentUser;
import org.xk.po.TeacherUser;
import org.xk.service.interfaces.UpdateSomethingService;

public class UpdateSomethingServiceImp implements UpdateSomethingService {
	static Opendb db = null;

	public static Opendb getDB() {
		if (db == null) {
			db = new Opendb();
		}
		return db;
	}

	public boolean addClass(String class_name, String class_property,
			int port_id, int teacher_id) {

		boolean flag = false;
		String sql = "insert into class(class_name,class_property,port_id,teacher_id) values('"
				+ class_name
				+ "','"
				+ class_property
				+ "','"
				+ port_id
				+ "','"
				+ teacher_id + "')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;

	}

	public ClassUser getClassInfo(String class_name) {
		return null;
	}

	public boolean addStudent(String stu_user, String stu_password,
			String stu_name, String stu_sex, String stu_number, String stu_age,
			int class_id, int port_id) {

		boolean flag = false;
		String sql = "insert into student(stu_user,stu_password,stu_name,stu_sex,stu_number,stu_age,class_id,port_id) values('"
				+ stu_user
				+ "','"
				+ stu_password
				+ "','"
				+ stu_name
				+ "','"
				+ stu_sex
				+ "','"
				+ stu_number
				+ "','"
				+ stu_age
				+ "','"
				+ class_id + "','" + port_id + "')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;

	}

	public boolean addSubject(String subject_name, int year_id, int class_id,
			int port_id) {

		boolean flag = false;
		String sql = "insert into subject(subject_name,year_id,class_id,port_id) values('"
				+ subject_name
				+ "','"
				+ year_id
				+ "','"
				+ class_id
				+ "','"
				+ port_id + "')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean updateStudent(String stu_user, String stu_password,
			String stu_name, String stu_sex, String stu_number, String stu_age,
			int class_id, int port_id) {

		boolean flag = false;
		String sql = "update student set stu_user='" + stu_user
				+ "',stu_password='" + stu_password + "',stu_name='" + stu_name
				+ "',stu_sex='" + stu_sex + "',stu_number='" + stu_number
				+ "',stu_age='" + stu_age + "' where stu_number='" + stu_number
				+ "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean deleteStudent(String stu_number) {
		boolean flag = false;
		String sql = "delete from student where stu_number = '" + stu_number
				+ "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean deleteClass(int class_id) {
		boolean flag = false;
		String sql = "delete from class where class_id = '" + class_id + "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean addScore(ScoreUser su) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "insert into score(score_name,score_number,score_sex,score_subject,score_score,year_id,class_id,port_id,state) values('"
				+ su.getScore_name()
				+ "','"
				+ su.getScore_number()
				+ "','"
				+ su.getScore_sex()
				+ "','"
				+ su.getScore_subject()
				+ "','"
				+ su.getScore_score()
				+ "','"
				+ su.getYear_id()
				+ "','"
				+ su.getClass_id() + "','" + su.getPort_id() + "','1')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;

	}

	public boolean updateTeacher(TeacherUser tu) {
		boolean flag = false;
		String sql = "update teacher set teacher_name='" + tu.getTeacher_name()
				+ "',teacher_sex='" + tu.getTeacher_sex() + "',teacher_age='"
				+ tu.getTeacher_age() + "',teacher_teach='"
				+ tu.getTeacher_teach() + "' where teacher_id ="
				+ tu.getTeacher_id();
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;

	}

	public boolean updatePassword(TeacherUser tu) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "update teacher set teacher_password='"
				+ tu.getTeacher_password() + "'where teacher_id ="
				+ tu.getTeacher_id();
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean updateStudentInfo(StudentUser su) {
		boolean flag = false;
		String sql = "update student set stu_name='" + su.getStu_name()
				+ "',stu_sex='" + su.getStu_sex() + "',stu_number='"
				+ su.getStu_number() + "',stu_age='" + su.getStu_age()
				+ "' where stu_id=" + su.getStu_id();
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean updateStuPassword(StudentUser su) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "update student set stu_password='" + su.getStu_password()
				+ "'where stu_id =" + su.getStu_id();
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean deleteTeacher(int teacher_id) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "delete from teacher where teacher_id = '" + teacher_id
				+ "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean deleteYear(int year_id) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "delete from years where year_id = '" + year_id + "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean addYear(String year_name) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "insert into years(year_name) values('" + year_name + "')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean deletePort(int port_id) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "delete from port where port_id = '" + port_id + "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean addPort(String port_number, String port_department) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "insert into port(port_number,port_department) values('"
				+ port_number + "','" + port_department + "')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean addTeacher(TeacherUser tu) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "insert into teacher(teacher_user,teacher_password,teacher_name,teacher_sex,teacher_age,teacher_teach,teacher_zhicheng,port_id) "
				+ "values('"
				+ tu.getTeacher_user()
				+ "','"
				+ tu.getTeacher_password()
				+ "','"
				+ tu.getTeacher_name()
				+ "','"
				+ tu.getTeacher_sex()
				+ "','"
				+ tu.getTeacher_age()
				+ "','"
				+ tu.getTeacher_teach()
				+ "','"
				+ tu.getTeacher_zhicheng() + "'," + tu.getPort_id() + ")";
		System.out.println(sql);
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean deleteAdmin(int admin_id) {
		boolean flag = false;
		String sql = "delete from admin where admin_id = '" + admin_id + "'";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean addAdmin(String admin_user, String admin_password) {
		boolean flag = false;
		String sql = "insert into admin(admin_user,admin_password) values('"
				+ admin_user + "','" + admin_password + "')";
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

	public boolean updateAdminPassword(AdminUser au) {
		// TODO Auto-generated method stub
		boolean flag = false;
		String sql = "update admin set admin_password='"
				+ au.getAdmin_password() + "'where admin_id ="
				+ au.getAdmin_id();
		if (getDB().executeUpdate(sql) > 0) {
			flag = true;
		}
		getDB().Close();
		return flag;
	}

}