【Java开源代码栏目提醒】:网学会员--在 Java开源代码编辑为广大网友搜集整理了:ysfLogin.java绩等信息,祝愿广大网友取得需要的信息,参考学习。
package flashRemoting.ysf;
import java.sql.*;
import java.io.Serializable;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
public class ysfLogin
implements Serializable {
public static boolean logined;
public static boolean login(String userName, String userPass) {
String sql = "select * from myUsers WHERE userID=? AND userPass=?";
Connection connection = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
Context ctx = (Context) new InitialContext().lookup("java:comp/env");
DataSource ds = (DataSource) ctx.lookup("ysfDb");
System.out.println("在这里我们使用JDBC连接的JNDI名");
System.out.println("在前面一章,我们创建名为ysfDb的JNDI名");
connection = ds.getConnection();
stmt = connection.prepareStatement(
sql);
stmt.setObject(1, userName);
stmt.setObject(2, userPass);
rs = stmt.executeQuery();
System.out.println("先设定返回的值为false");
logined = false;
while (rs.next()) {
logined = true;
}
}
catch (Exception e) {
System.out.println(e);
}
finally {
try {
rs.close();
stmt.close();
connection.close();
}
catch (Exception e) {}
}
return logined;
}
public String loginFMS(String userName, String userPass) {
String sql = "select roles from myUsers WHERE userID=? AND userPass=?";
Connection connection = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String returned = "false";
try {
Context ctx = (Context) new InitialContext().lookup("java:comp/env");
DataSource ds = (DataSource) ctx.lookup("ysfDb");
System.out.println("在这里我们使用JDBC连接的JNDI名");
System.out.println("在前面一章,我们创建名为ysfDb的JNDI名");
connection = ds.getConnection();
stmt = connection.prepareStatement(sql);
stmt.setObject(1, userName);
stmt.setObject(2, userPass);
rs = stmt.executeQuery();
while (rs.next()) {
returned = rs.getString("roles");
}
}
catch (Exception e) {
System.out.println(e);
}
finally {
try {
rs.close();
stmt.close();
connection.close();
}
catch (Exception e) {}
}
System.out.println(returned);
return returned;
}
}