databasebean.java

来自「我自己写的javabean+jsp+servlet」· Java 代码 · 共 55 行

package com.gke;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;



public class DatabaseBean {
	
	Connection conn;
	
	private String sql = "select * from memo";
	private Vector memoVector;
	ResultSet rs = null;
	
	
	public DatabaseBean(){
		try {
			conn = DBUtil.getConnection();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public void dbQuerymemo(){
		memoVector = new Vector();
		try {
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				MemoBean temp = new MemoBean();
				temp.setUsername(rs.getString(1));
				temp.setContent(rs.getString(2));
				memoVector.add(temp);
			}
			
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	
	public Vector getMemoVector(){
		return memoVector;
	}

	
}