procedure_user.java

java做的 公交车查询系统....毕业设计

package gongjiaochexitong.renyuan;

import java.sql.*;

public class procedure_user {
	
	//检验登录用户
	public static boolean checkUser(conn_User db,String userName,
			String userPassword,String userPower) throws Exception{
		ResultSet rs;
		boolean result=false;
		String sql="select * from user where userName= '"+userName+"' and "
		           +"userPassword= '"+userPassword+"' and "
		           +"userPower= '"+userPower+"'";
		rs=db.exeQuery(sql);
		
		if(rs.next()) result=true;  //返回值不为空,用户存在
		else result=false;
		
		return result;
	}
	
	//注册用户(0:插入失败;1:插入成功)
	public static int registUser(conn_User db,String userName,
			String userPassword,String phoneNo,String email) throws Exception{
		int result=0;
		String sql="insert into user values('"+userName+"','"+userPassword
		        +"','0','"+phoneNo+"','"+email+"')";
		result=db.exeUpdate(sql);
		
		return result;
	}

}