权限登陆

[color=blue][size=large]package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DengluDAO {

public boolean denglu8(String name, String password) {
try {
DBTools tools = new DBTools();
Connection conn = tools.getConnection();
String sql = "select flag from shop_user where username =? and password =?";
System.out.println(sql);
PreparedStatement state = conn.prepareStatement(sql);
state.setString(1, name);
state.setString(2, password);
ResultSet set = state.executeQuery();

System.out.println();
if (set.next()&& set.getInt(1)==8){
System.out.println("登陆经理"+set.getInt(1));
return true;}

} catch (SQLException e) {
e.printStackTrace();
}
return false;
}

public boolean denglu1(String name, String password) {
try {
DBTools tools = new DBTools();
Connection conn = tools.getConnection();
String sql = "select flag from shop_user where username =? and password =?";
System.out.println(sql);
PreparedStatement state = conn.prepareStatement(sql);
state.setString(1, name);
state.setString(2, password);
ResultSet set = state.executeQuery();

System.out.println( );
if (set.next() && set.getInt(1)==1) {
System.out.println("登陆出纳"+set.getInt(1));
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}[/size][/color]