usertable.java

类似于csdn的上传下载系统

package org.adam.bean;

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

public class Usertable {
	public static boolean flag=false;
	public static int user_id=0;
	private int usertable_id;
	private String username;
	private String password;
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public int getUsertable_id() {
		return usertable_id;
	}
	public void setUsertable_id(int usertable_id) {
		this.usertable_id = usertable_id;
	}
	public static void Login(String username,String password,DB db){
		String sql="select * from usertable where username='"+username+"' and password='"+password+"'";
		//System.out.println(sql);
		ResultSet rs=db.getData(sql);
		try {
			if(rs.next()){
				user_id=rs.getInt("usertable_id");
				flag=true;
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closed();
	}
}