logon.java

jsp范例宝典

package com.safe.SQL;

import java.sql.*;
public class Logon {
	private String username;
	private String mark="yes";
	private Checkstr check=new Checkstr();
	public Logon(){}
	public void setUsername(String username){
		if(mark.equals("yes"))
			this.username=check.dostring(username);
		else
			this.username=username;
	}
	public String getUsername(){
		return this.username;
	}
	public void setMark(String mark){
		this.mark=mark;
	}
    public String checklogon(){
    	String backmess="";
    	boolean mark=true;
    	if(this.username.equals("")){
    		mark=false;
    		backmess+="<li>请输入<b>用户名！</b></li><br>";
    	}
    	if(!mark){
    		return backmess;
    	}
    	String sql="select * from tb_userlogon where user_name='"+this.username+"'";
    	DB db=new DB();
    	ResultSet rs=db.search(sql);
    	try{
    		if(rs.next()){
    			backmess="登录成功！<br>输入的用户名：<br>"+this.username;
    		}
    		else{
    			backmess="登录失败！<br>输入的<b>用户名</b>不存在！<br>输入："+this.username;
 	  		}
    	}
    	catch(Exception e){
    		e.printStackTrace();
    		backmess="操作失败！<br>输入的用户名：<br>"+this.username;
    	}
    	db.closed();
    	return backmess;
    } 
}