userquery.java

这是一个用java语言开发的运动员成绩统计系统

package com.userManager;

import com.DBManager.MyDB;
import com.MainFrame;
import com.component.MyFrame;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.Rectangle;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

/**
 * @author  Laiger
 */
public class UserQuery extends MyFrame {

	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JLabel jLabel = null;
    MyDB db=new MyDB();
	
	public UserQuery(MainFrame m) {
		super(m);
		db.connectDB();
		initialize();
		db.close();
	}

	 
	private void initialize() {
        jLabel = new JLabel();
        jLabel.setBounds(new Rectangle(156, 32, 196, 33));
        jLabel.setText("所查询出的用户信息");
        jLabel.setFont(new Font("黑体",Font.BOLD,20));
        jLabel.setForeground(Color.blue);
        this.setSize(new Dimension(496, 296));
        this.setTitle("用户信息查询");
        this.add(getJScrollPane(), null);
        this.add(jLabel, null);
			
	}

	 
	/**
	 * @return  the jScrollPane
	 * @uml.property  name="jScrollPane"
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(41, 71, 438, 197));
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * @return  the jTable
	 * @uml.property  name="jTable"
	 */
	private JTable getJTable() {
		if (jTable == null) {

			jTable = new JTable();
			ResultSet rs;
			Vector row=new Vector();
			Vector col=new Vector();
			String sql="select * from user";
			rs=db.executeQuery(sql);
			try {
				while(rs.next()){
					Vector v=new Vector();
					v.add(rs.getString("UserId"));
					v.add(rs.getString("power"));
					v.add(rs.getString("name"));
					v.add(rs.getString("sex"));
					 row.add(v);	 
				}
			} catch (SQLException e1) {
				
				e1.printStackTrace();
			}
			
		col.add("帐号");	col.add("权限");	col.add("姓名"); col.add("性别");
			jTable=new JTable(row,col);
			jScrollPane.setViewportView(jTable);	
		
		}
		return jTable;
	}
}