studentio.java

成绩查询系统（学校期末的作业） Struts+jdbc+mysql+tomcat 开发工具为BEA WORKSHOP 功能无非就是增删查改加用户权限判断

package sfs.entity.io;

import java.lang.reflect.InvocationTargetException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import sfs.connection.ConnIO;
import sfs.connection.ResToObj;
import sfs.entity.Student;

public class StudentIo extends ConnIO{
	public StudentIo() throws ClassNotFoundException, SQLException {
		
	}
	
	/*******************查询***********************/
	public  List query() throws SQLException{
		String sql="select * from user_student";
		return super.Query(sql,"user_student");		
	}
	
	public  List queryByid(int id) throws SQLException, NumberFormatException, IllegalAccessException, InvocationTargetException, NoSuchMethodException{
		String sql="select * from user_student where id="+id;
		return super.Query(sql,"user_student");
	}
	
	public  List queryBynumber(Student st) throws SQLException, NumberFormatException, IllegalAccessException, InvocationTargetException, NoSuchMethodException{
		return super.QueryByNumber("user_student",st);
	}
	
	public Student queryByLoginnameAndPswd(String number,String password) throws SQLException{
		String sql="select * from user_student where number="+"\""+number+"\""+" and password="+"\""+password+"\"";
		ResultSet res=conn.createStatement().executeQuery(sql);		
		if(res.next()){
			Student st=(Student)ResToObj.excute("user_student",res);
			return st;	
		}
		return null;
		
	}
	
	public Student queryByLoginname(String number) throws SQLException{
		String sql="select * from user_student where number="+"\""+number+"\"";
		ResultSet res=conn.createStatement().executeQuery(sql);
		System.err.println(sql);
		if(res.next()){
			Student st=(Student)ResToObj.excute("user_student",res);
			System.err.println(st);
			return st;
		}
		return null;
	}
	/**************************删除****************************/
	public  boolean deletByid(Student st) throws SQLException, IllegalAccessException, InvocationTargetException, NoSuchMethodException{
		super.DeletById("user_student",st);
		return true;
	}
	public  boolean deletBynumber(Student st) throws SQLException, IllegalAccessException, InvocationTargetException, NoSuchMethodException{
		super.DeletByNumber("user_student",st);
		return true;
	}
	
	/***********************增加或修改*************************/
	public  boolean saveorupdata(Student st) throws SQLException, NumberFormatException, IllegalAccessException, InvocationTargetException, NoSuchMethodException{
		//查询对象，如果为空则增加，不为空则更新
		if(this.QueryById("user_student",st)==null){			
			//增加记录
			System.out.print("增加记录");               
			String sql="insert  user_student (number,password,department,realname,classname,authority) values (?,?,?,?,?,?)";
			PreparedStatement prepar = conn.prepareStatement(sql);
			prepar.setString(1,st.getNumber());
			prepar.setString(2,st.getPassword());
			prepar.setString(3,st.getDepartment());
			prepar.setString(4,st.getRealname());
			prepar.setString(5,st.getClassname());
			prepar.setString(6,st.getAuthority());
			prepar.executeUpdate();
			prepar.close();	
			return true;
		}else{
			//更新			
			System.out.print("更新");               
			//是否需要按照用户名修改更新??
			Student temp=(Student)this.QueryByNumber("user_student",st).get(0);
			String sql="update user_student set number=? ,password=? ,department=? ,realname=? ,classname=? ,authority=? where id=?";
			PreparedStatement prepar = conn.prepareStatement(sql);
			prepar.setString(1,st.getNumber());
			prepar.setString(2,st.getPassword());
			prepar.setString(3,st.getDepartment());
			prepar.setString(4,st.getRealname());
			prepar.setString(5,st.getClassname());
			prepar.setString(6,st.getAuthority());
			prepar.setInt(7,temp.getId());
			prepar.execute();
			prepar.close();	
			return true;
		}

	}
	public void updatePassword(String password,int id) throws SQLException{
		String sql="update user_student set password="+"\""+password+"\""+" where id="+"\""+id+"\"";
		conn.createStatement().executeUpdate(sql);
	}
}