user.java

java 项目

package com.customer;

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

import com.dbconn.DbConn;

public class User {

	private int id;
	private String name;
	private String pwd;
	private String sex;
	private String xueli;
	private String tujing;
	private String header;
	private String admin;
	
	private DbConn db=new DbConn();
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getXueli() {
		return xueli;
	}
	public void setXueli(String xueli) {
		this.xueli = xueli;
	}
	public String getTujing() {
		return tujing;
	}
	public void setTujing(String tujing) {
		this.tujing = tujing;
	}
	public String getHeader() {
		return header;
	}
	public void setHeader(String header) {
		this.header = header;
	}
	
	
	
	public String getAdmin() {
		return admin;
	}
	public void setAdmin(String admin) {
		this.admin = admin;
	}
	public boolean exits(String name){
		
		String sql="select * from user where name='"+name+"'";
		ResultSet rs=db.query(sql);
		if(rs!=null){
			try {
				while(rs.next()){
					return true;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return false;

	}
	
}