adminbean.java

学生档案管理系统 eclipse开发 数据库用的是SQL Sever 详细见里面的说明

package Beans;

import java.sql.*;

public class AdminBean implements java.io.Serializable {
	//private String name;
	private int id=-1;
	private String name="";
	public int getId(){
		return id;
	}
	public void setId(int id){
		System.out.println("OK");
		this.id=id;
	}
	public String getName()
	{
		return name;
	}

	public void setName(String name)
	{
		this.name=name;
		
	}
	public ResultSet getrs()
	{
		String sql="Select * from Tb_Users_Info where 1=1";
		if (id>=0) sql=sql+"and Users_ID="+String.valueOf(id);
		if (!name.equals("")) sql=sql+"and Users_name='"+name+"'";
		dbAccess.Conn Conner=new dbAccess.Conn();
		ResultSet rs=null;
		Conner.connectdb(sql);
		rs=Conner.getrs();
		return(rs);

	}
	public boolean del_user(String id)
	{
		String sql="delete from Tb_Users_Info where Users_ID="+id;
		dbAccess.Conn Conner=new dbAccess.Conn();
		return(Conner.connectdb(sql));
	}

}