userserviceimp.java

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

package org.xk.service.imp;

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

import org.xk.dbutil.Opendb;
import org.xk.po.*;
import org.xk.service.interfaces.UserService;

public class UserServiceImp implements UserService{
    static Opendb db = null;
	
	public static Opendb getDB(){
		if(db == null){
			db = new Opendb();
		}
		return db;
	}
	

	public boolean isStudentLogin(String stu_user,String stu_password){
		boolean flag=false;
		String sql="select * from student where stu_user= ? and stu_password= ?";
		String[] obj={stu_user,stu_password};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("this isStudentLogin have err  %%% "+e.getMessage());
		}
		getDB().Close();
		return flag;
	}


	public AdminUser getAdminInfo(String admin_user, String admin_password) {
		// TODO Auto-generated method stub
		AdminUser au = new AdminUser();
		String sql = "select * from admin where admin_user= ? and admin_password= ? ";
		String[] obj = {admin_user,admin_password};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				au.setAdmin_id(rs.getInt("admin_id"));
				au.setAdmin_user(rs.getString("admin_user"));
				au.setAdmin_password(rs.getString("admin_password"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return au;
	}


	public StudentUser getStudentInfo(String stu_user, String stu_password) {
		// TODO Auto-generated method stub
		StudentUser su = new StudentUser();
		String sql = "select * from student where stu_user= ? and stu_password= ? ";
		String[] obj = {stu_user,stu_password};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				su.setStu_id(rs.getInt("stu_id"));
				su.setStu_name(rs.getString("stu_name"));
				su.setStu_sex(rs.getString("stu_sex"));
				su.setStu_number(rs.getString("stu_number"));
				su.setStu_age(rs.getString("stu_age"));
				su.setClass_id(rs.getInt("class_id"));
				su.setPort_id(rs.getInt("port_id"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return su;
	}


	public TeacherUser getTeacherInfo(String teacher_user,String teacher_password) {
		// TODO Auto-generated method stub
		TeacherUser tu = new TeacherUser();
		String sql="select * from teacher where teacher_user= ? and teacher_password= ?";
		String[] obj = {teacher_user,teacher_password};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				tu.setTeacher_id(rs.getInt("teacher_id"));
				tu.setTeacher_user(rs.getString("teacher_user"));
				tu.setTeacher_password(rs.getString("teacher_password"));
				tu.setTeacher_name(rs.getString("teacher_name"));
				tu.setTeacher_sex(rs.getString("teacher_sex"));
				tu.setTeacher_age(rs.getString("teacher_age"));
				tu.setTeacher_teach(rs.getString("teacher_teach"));
				tu.setTeacher_zhicheng(rs.getString("teacher_zhicheng"));
				tu.setPort_id(rs.getInt("port_id"));
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return tu;
	}


	public boolean isAdminLogin(String admin_user, String admin_password) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="select * from admin where admin_user= ? and admin_password= ?";
		String[] obj={admin_user,admin_password};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				flag = true;
			}
		} catch (SQLException e) {
			System.out.println("this isAdminLogin have err  %%% "+e.getMessage());
		}
		getDB().Close();
		return flag;
	}


	public boolean isTeacherLogin(String teacher_user, String teacher_password,int port_id) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="select * from teacher where teacher_user='"+teacher_user+"' and teacher_password='"+teacher_password+"' and port_id='"+port_id+"'";
		
		ResultSet rs=getDB().executeQuery(sql);
		try {
			if(rs.next()){
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("this isTeacherLogin have err  %%% "+e.getMessage());
		}
		getDB().Close();
		return flag;
		
	}


	public PortUser getPortInfo(String port_number) {
		// TODO Auto-generated method stub
		PortUser pu = new PortUser();
		String sql = "select * from port where port_number= ?";
		String[] obj = {port_number};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				pu.setPort_id(rs.getString("port_id"));
				pu.setPort_number(rs.getString("port_number"));
				pu.setPort_department(rs.getString("port_department"));
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return pu;
	
	}


	public boolean isPortLogin(String port_number) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="select * from port where port_number= ? ";
		String[] obj={port_number};
		ResultSet rs=getDB().executeQuery(sql, obj);
		try {
			if(rs.next()){
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("this isPortLogin have err  %%% "+e.getMessage());
		}
		getDB().Close();
		return flag;
		
	}


	
	
	

	
}