doperation.java

来自「利用Struts的MVC写的WEB开发程序」· Java 代码 · 共 78 行

/****************************
****************************/
package dlayer;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


import bean.UserBean;


public class DOperation extends DConnet {	
	
	private Connection con;
	
	private ResultSet rs;
	
	private Statement stmt;
	
	public void DOperation() {
		
	}

	public UserBean getUserResultSet(String userID) throws SQLException {
	
		//this.Connect();
		
		con = super.Connect();

		stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
				ResultSet.CONCUR_READ_ONLY);
		
		StringBuffer buffer = new StringBuffer();
		
		UserBean userBean = new UserBean();
		
		userBean = null;
	
		if(!userID.equals("")) {
		
			buffer.append("select * from USER_MENU where USER_ID = '");
			
			buffer.append(userID);
			
			buffer.append("'");
		
		}else{
		
			
			buffer.append("select * from USER_MENU");
		
		}
		
		String sql = buffer.toString();
	
			rs = stmt.executeQuery(sql);
			
			while (rs.next()) {
				
				userBean = new UserBean();
		
				userBean.setUserID(userID);
		
				userBean.setUsername(rs.getString("USER_NAME"));
	
			}			
				
		return userBean;
	
	}

}