login.java

JSP简单的OA系统_非常不错的一个系统

package com.zh.util;
import com.zh.conpool.Condata;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import javax.servlet.http.HttpServletResponse;
import com.bwm.string.Str;
public class login{
	private String button1;
	private String button2;
	String sqlstr;
	Str str=new Str();
	Condata con=new Condata();
	Connection conn=con.getConnection();
		
	public static void main(String[] args){
	}
	public login()throws Exception{
		button1="";
		button2="";
		
	}
	public String getUsername(){
		return button1;
	}
	public void setUsername(String newusername){
		button1=newusername;	
	}
	public String getPassword(){
		return button2;	
	}
	public void setPassword(String newpassword){
		button2=newpassword;
	}
	public String getSql(){
		sqlstr="select * from tb_person where Name='"+button1+"' and Password='"+str.toChinese(button2)+"'";
		return sqlstr;
	}
	public boolean execute()throws Exception{
		boolean flag=false;
		ResultSet rs=con.executeQuery(getSql());
		if(rs.next()){
			flag=true;
		}
		
		conn.close();
		con.close();
		rs.close();
		return flag;
	}
	
}