usermessagedb.java

本系统完成简单的图书管理系统

/***********************************************************************
*                          湖南大学图书管理系统
* @author Administrator                                                         
* @since 2008.06                                                  
* @version 1.0                                                           															  
* @category 用户信息查看数据库操作
*************************************************************************/

package library.DBaccess;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Hashtable;
import java.util.Vector;

import library.DBBase.JDBC;

public class UserMessageDB {

	public UserMessageDB() {
		// TODO Auto-generated constructor stub
		super();
	}

	public Vector getUserMessage(String userName) {

		Hashtable hs = new Hashtable();
		Vector v = new Vector();
		JDBC jdbc = new JDBC();
		Connection con = jdbc.getConnection();

		String sql = "select NAME, SEX,COLLEGE,PROFESSION,GRADE from user where USERNAME = '"
				+ userName + "'";

		try {
			PreparedStatement ps = con.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				hs = new Hashtable();
				ResultSetMetaData rsmd = rs.getMetaData();
				for (int i = 0; i < rsmd.getColumnCount(); i++) {
					hs.put(rsmd.getColumnName(i + 1), rs.getObject(i + 1));
				}
				v.add(hs);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		jdbc.closeConnection(con);
		return v;

	}

	/**
	 * @param args
	 */
	/*public static void main(String[] args) {

		UserMessageDB umdb = new UserMessageDB();

		Vector v = umdb.getUserMessage("caohao");
		for (int i = 0; i < v.size(); i++) {
			// System.out.println(((Hashtable)vv.get(i)).get("AUTHOR"));
			System.out.println(v.get(i));
		}
	}
*/
}