addadmingo.java

NTsky新闻发布v1.0(提供JavaBean)

package ntsky.admin.usr;

import java.sql.*;
import javax.servlet.http.*;
import ntsky.database.*;

public class AddAdminGo{
	private String username = null;
	private int purview;
	private int admin_total;

	//用户名
	public String getUsername(HttpServletRequest request,String username){
		try{
			username = request.getParameter(username);
		}
		catch(Exception e){
			System.out.print("getUsername "+e.getMessage());
		}
		return username;
	}
	//用户等级
	public int getPurview(HttpServletRequest request,String Spurview){
		try{
			purview = Integer.parseInt(request.getParameter(Spurview));
		}
		catch(Exception e){
			System.out.print("getPurview "+e.getMessage());
		}
		return purview;
	}
	//判断数据库是否有此用户
	public int jerqueAdmin(String username){
		try{
			String sql = "select count(*) as t from admin where username='"+username+"'";
			DBConnect dbc = new DBConnect();
			ResultSet rs = dbc.executeQuery(sql);
			rs.next();
			admin_total =  rs.getInt("t");
			rs.close();
			rs = null;
		}
		catch(Exception e){
			System.out.print("jerqueAdmin "+e.getMessage());
		}
		return admin_total;
	}
	//执行插入数据
	public void insAdmin(String username,int purview){
		try{
			String password = "ntsky";
			String sql = "insert into admin(username,password,purview) values('"+username+"','"+password+"','"+purview+"')";
			DBConnect dbc = new DBConnect();
			dbc.executeUpdate(sql);
		}
		catch(Exception e){
			System.out.print("insAdmin() "+e.getMessage());
		}
	}
	//转移页面
	public void resaddadmin(HttpServletResponse response,String url){
		try{
			response.sendRedirect(url);
		}
		catch(Exception e){
			System.out.print("resaddadmin() "+e.getMessage());
		}
	}
}