power.java

来自「文件的上传和下载的实现,用JAva编写,非常简单」· Java 代码 · 共 73 行

/**
 * 
 */
package edu.whut.cwts.maintain.bean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import edu.whut.cwts.datasource.DBConnect;

/**
 * @author dwr
 *
 */

public class Power {

	/**
	 * @param args
	 */
	private String qxdm;
	private String qxmc;
	
	

	public String getQxdm() {
		return qxdm;
	}

	public void setQxdm(String qxdm) {
		this.qxdm = qxdm;
	}

	public String getQxmc() {
		return qxmc;
	}

	public void setQxmc(String qxmc) {
		this.qxmc = qxmc;
	}
	public ArrayList queryPower() throws SQLException{
		
			ArrayList powerlist=new ArrayList();
			String sqlhyzdj="select *from qxxxb";//营运机动船舶;
			
			//System.out.println("111111111");
			
			DBConnect conn=new DBConnect();
			ResultSet rs=conn.executeQuery(sqlhyzdj);
			
			while(rs.next()){
				Power power=new Power();
				//System.out.println("111111111");
				power.setQxdm(rs.getString(1));
				power.setQxmc(rs.getString(2));
				
				
				
				powerlist.add(power);
				
			}
			return powerlist;
		
	} 
	
	public static void main(String[] args) {
		// TODO 自动生成方法存根

	}

}