loginmanager.java

java oracle 示例 prefirst.rar

package cn.com.freeborders.sys;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;


import cn.com.freeborders.dataconn.DataProcess;

public class LoginManager {
	public static ArrayList getSysuser(String username, String password){
		ArrayList sysusers = new ArrayList();
		String sql = "select * from sysuser where username = '" + username + "' and password = '" + password +"'";
		Connection conn = DataProcess.getConnection();
		ResultSet rs = DataProcess.getResult(sql,conn);
		try {
			if (rs.next()) {
				Sysuser sysuser = new Sysuser();
				String rid = rs.getString("id");
				String rusername = rs.getString("username");
				String rpassword = rs.getString("password");
				String rlevels = rs.getString("levels");
				sysuser.setId(rid);
				sysuser.setUsername(rusername);
				sysuser.setPassword(rpassword);
				sysuser.setLeves(rlevels);
				sysusers.add(sysuser);
			}
			DataProcess.closeResult(rs);
			DataProcess.closeConnection(conn);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return sysusers;
	}

}