jdbc的简单使用

ResultSet result=null;
		Connection con=null;
		Statement sql=null;
		try{
			con = pfwClient.getDataSource().getConnection();
			sql = con.createStatement();
			result =  sql.executeQuery(sqlStatement);
			int cols = result.getMetaData().getColumnCount(); 
			if("Y".equals(type)){
				Vector rs = new Vector();
				int i;
				while(result.next()){
					RecordBean rb = new RecordBean();
					for(i=1;i<=cols;i++){
						rb.set(result.getMetaData().getColumnName(i),result.getString(i));
					}
					rs.add(rb);
				}
				if(null!=varName){
					map.put(varName[0], rs);
				}
			}else if("N".equals(type)){
				while(result.next()){
						for(int k=0;k<length;k++){
							if(!"".equals(tableColumn[k])){
							tableColumnValue[k] = result.getString(tableColumn[k]);
							map.put(varName[k],tableColumnValue[k]);
							}
						}
						break;
				}
			}
		}catch(SQLException e){
			System.out.println("Please check sql is correct in DataService");
			e.printStackTrace();
		}finally{
			try{
				if(sql != null)
					sql.close();
				if(con != null){
					con.close();
				}
				}catch(SQLException ex){
				ex.printStackTrace();
				}
		}