userquerycmd.java

oracle数据库课程设计:公司人事管理系统,用Oracle存储数据

package ycy.cmd;

import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JOptionPane;

import ycy.EmpDao;



public class UserQueryCmd extends Command{
	public void execute(){
		try {
			String comm = JOptionPane.showInputDialog("请选择要查询的对象:");
			ResultSet result;
			result = EmpDao.queryUser(comm);
			while (result.next()) {
				System.out.println(result.getString("id") + "\t|\t"
						+ result.getString("username") + "\t|\t"
						+ result.getString("password") + "\t|\t"
						+ result.getString("truename") + "\t|\t"
						+ result.getString("gender") + "\t|\t");
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}
}