Java ResultSet.next方法代码示例

import java.sql.ResultSet; //导入方法依赖的package包/类
public Hero findHeroesById(String term) throws SQLException {

		String query = "SELECT h.id, h.name, h.sex, i.name AS real_name, m.name AS movies_name, t.team_name AS team_name, h.picture, h.abilities, h.history, t.picture "
				+ "FROM heroes h LEFT JOIN movie_hero mh ON h.id = mh.id_hero "
				+ "LEFT JOIN movie m ON mh.id_movie = m.id " + "LEFT JOIN team_hero th ON th.hero_id = h.id "
				+ "LEFT JOIN team t ON t.team_id = th.team_id " + "LEFT JOIN irl i ON i.hero_id = h.id "
				+ "WHERE h.id='"+term +"'";

		Connection connect = connectToMySQL();
		Statement statement = connect.createStatement();
		ResultSet resultSet = statement.executeQuery(query);
		if (resultSet.next()){
			Hero hero = resultSetToHero(resultSet);
			connect.close();
			return hero;
		}
		else{
			connect.close();
			return null;
		}


	}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
public static ArrayList<EntradaItem> retreaveByEntrada(int entradaId) throws SQLException {
    Statement stm
            = Database.createConnection().
                    createStatement();
    String sql = "SELECT * FROM entrada_itens where entrada = " + entradaId;
    ResultSet rs = stm.executeQuery(sql);
    ArrayList<EntradaItem> entrada = new ArrayList<>();
    while (rs.next()) {
        entrada.add(new EntradaItem(
                rs.getInt("id"),
                ProdutoDAO.retreave(rs.getInt("produto")),
                rs.getInt("entrada"),
                rs.getDouble("quantidade"),
                rs.getTimestamp("validade"),
                rs.getString("lote"),
                rs.getDouble("valor_unitario")));
    }
    rs.next();
    return entrada;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
/**
 * 获得Template配置文件信息
 * 
 * @return
 * @throws Exception
 */
public static TemplateConfig getTemplateConfig(String name) throws Exception {
	Connection conn = null;
	Statement stat = null;
	ResultSet rs = null;
	try {
		conn = getConnection();
		stat = conn.createStatement();
		String sql = String.format("select * from TemplateConfig where name='%s'", name);
		ResultSet resultSet = stat.executeQuery(sql);
		while (resultSet.next()) {
			TemplateConfig result = JSON.parseObject(resultSet.getString("value"), TemplateConfig.class);
			return result;
		}
	} finally {
		if (rs != null)
			rs.close();
		if (stat != null)
			stat.close();
		if (conn != null)
			conn.close();
	}
	return null;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
/**
 * 从数据库查询结果中获取product
 * @param rs 查询结果集
 * @return 返回查询到的产品，否则返回null
 */
private Product getOneProduct(ResultSet rs) {
    Product product = null;
    try {
        if(rs.next()) {
            product = new Product();
            product.setProductId(rs.getInt("pid"));
            product.setProductName(rs.getString("pname"));
            product.setProductPrice(rs.getInt("pprice"));
            product.setNumber(rs.getInt("pnumber"));
            product.setProductTime(rs.getTime("producttime"));
            product.setId(rs.getInt("id"));
            ProductType productType = productTypeDao.queryProductTypeByTypeId(rs.getInt("ptype"));
            product.setProductType(productType);
            product.setFileName(rs.getString("filename"));
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        super.closeAll();
    }
    return product;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
/**
 * 封装实体
 * 
 * @param cls
 *            实体类
 * @param list
 *            数据查询结果集
 * @return
 */
public static final <E> List<E> getInstanceList(Class<E> cls, ResultSet rs) {
	List<E> resultList = newArrayList();
	try {
		E object = cls.newInstance();
		Field[] fields = cls.getDeclaredFields();
		while (rs.next()) {
			object = cls.newInstance();
			for (int i = 0; i < fields.length; i++) {
				String fieldName = fields[i].getName();
				PropertyUtils.setProperty(object, fieldName, rs.getObject(fieldName));
			}
			resultList.add(object);
		}
	} catch (Exception e) {
		throw new InstanceException(e);
	}
	return resultList;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
public DefaultComboBoxModel getValue(){
    DefaultComboBoxModel modelo = new DefaultComboBoxModel();
    modelo.addElement("Selecciona Proyecto");
    String sql_select;
    sql_select="SELECT nombre_proyecto FROM  proyectos";// Where nombre_equipo LIKE '" + indi + "%'";
   
     try{
        Connection conn= fachada.getConnetion();
        System.out.println("consultando en la bd");
        Statement sentencia = conn.createStatement();
        ResultSet tabla = sentencia.executeQuery(sql_select);
        while(tabla.next()){
            modelo.addElement(tabla.getString(1));
        }
        tabla.close();
        sentencia.close();
      
     }
     catch(Exception e){ System.out.println(e);}
     return modelo;     
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
@Override
public boolean checkNameAndPwd(String name, String password)
{
	try
	{
		ResultSet rs = con.query("select * from users where u_name=? and u_pwd=? ",
				new String[] { name,password});
		if(rs.next())
			return true;
		else
			return false;
	}
	catch (Exception e)
	{
		e.printStackTrace();
		return false;
	}
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
private String getColumnRemarks(String tableName,String columnName,DatabaseMetaData databaseMetaData) throws SQLException{
	String remarks=null;
	ResultSet rs=null;
	try{
		rs=databaseMetaData.getColumns(null, null, tableName,"%");
		while(rs.next()){
			String colName=rs.getString("COLUMN_NAME");
			if(columnName.equals(colName)){
				remarks=rs.getString("REMARKS");
				break;
			}
		}
	}finally{
		if(rs!=null)rs.close();
	}
	return remarks;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
public int getPandoraLog(String itemid) {
Connection con1 = DatabaseConnection.getConnection();
try {
int ret_count = 0;
PreparedStatement ps;
ps = con1.prepareStatement("select count(*) from pandoralog where characterid = ? and itemid = ? and lastattempt >= subtime(current_timestamp, '1 0:0:0.0')");
ps.setInt(1, id);
ps.setString(2, itemid);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
ret_count = rs.getInt(1);
} else {
ret_count = -1;
}
rs.close();
ps.close();
return ret_count;
} catch (Exception Ex) {
	System.out.print("Error reading Pandora Log.");
return -1;
}
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
@Override
public List<Integer> getUnavailableNumbers(UUID driverid, String classcode)
{
    List<Integer> ret = new ArrayList<Integer>();
    try
    {
        boolean superunique = Integer.parseInt(getSetting("superuniquenumbers")) != 0;
        ResultSet rs;

        if (superunique) {
            rs = executeSelect("select distinct number from cars where number not in (select number from cars where driverid=?)", newList(driverid));
        } else {
            rs = executeSelect("select distinct number from cars where classcode=? and number not in (select number from cars where classcode=? and driverid=?)", newList(classcode, classcode, driverid));
        }

        while (rs.next())
            ret.add(rs.getInt(1));
    }
    catch (Exception e)
    {
        logError("getUnavailableNumbers", e);
    }

    return ret;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
public void displayAllUsers() throws SQLException {

		ResultSet result = null;

		ps = conn
				.prepareStatement("select * from test.users");
		result = ps.executeQuery();

		int i = 0;
		while (result.next()) {
			System.out.println(++i + " -> " + result.getString(1) + " "
					+ result.getString(2) + " " + result.getString(3));
		}

		System.out.println("Select SQL executed successfully ");
	}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
/**
 * Get block position in blockchain
 *
 * @param db data connection
 * @param id block id
 * @return block height or -1 if block not exist
 * @throws DataAccessException problems with the DB
 */
public static int getHeight(ConnectionProxy db, final long id) {
	try {

		PreparedStatement statement = db.prepareStatement("SELECT \"height\" FROM \"block\" where \"id\" = ?");
		int h = -1;
		synchronized (statement) {

			statement.setLong(1, id);

			ResultSet set = statement.executeQuery();
			while (set.next()) {
				h = set.getInt(1);
			}
			set.close();

		}

		return h;

	} catch (Exception e) {
		throw new DataAccessException(e);
	}
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
@NonNull
protected ResultSet performQuery(MariaDBContainer containerRule, String sql) throws SQLException {
    HikariConfig hikariConfig = new HikariConfig();
    hikariConfig.setJdbcUrl(containerRule.getJdbcUrl());
    hikariConfig.setUsername(containerRule.getUsername());
    hikariConfig.setPassword(containerRule.getPassword());

    HikariDataSource ds = new HikariDataSource(hikariConfig);
    Statement statement = ds.getConnection().createStatement();
    statement.execute(sql);
    ResultSet resultSet = statement.getResultSet();

    resultSet.next();
    return resultSet;
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
protected int getRowCount(String tableName) throws SQLException {
    ResultSet countRs = null;

    try {
        countRs = this.stmt.executeQuery("SELECT COUNT(*) FROM " + tableName);

        countRs.next();

        return countRs.getInt(1);
    } finally {
        if (countRs != null) {
            countRs.close();
        }
    }
}
 

import java.sql.ResultSet; //导入方法依赖的package包/类
/**
 * Tests that streaming result sets are registered correctly.
 * 
 * @throws Exception
 *             if any errors occur
 */
public void testClobberStreamingRS() throws Exception {
    try {
        Properties props = new Properties();
        props.setProperty("clobberStreamingResults", "true");

        Connection clobberConn = getConnectionWithProps(props);

        Statement clobberStmt = clobberConn.createStatement();

        clobberStmt.executeUpdate("DROP TABLE IF EXISTS StreamingClobber");
        clobberStmt.executeUpdate("CREATE TABLE StreamingClobber ( DUMMYID INTEGER NOT NULL, DUMMYNAME VARCHAR(32),PRIMARY KEY (DUMMYID) )");
        clobberStmt.executeUpdate("INSERT INTO StreamingClobber (DUMMYID, DUMMYNAME) VALUES (0, NULL)");
        clobberStmt.executeUpdate("INSERT INTO StreamingClobber (DUMMYID, DUMMYNAME) VALUES (1, 'nro 1')");
        clobberStmt.executeUpdate("INSERT INTO StreamingClobber (DUMMYID, DUMMYNAME) VALUES (2, 'nro 2')");
        clobberStmt.executeUpdate("INSERT INTO StreamingClobber (DUMMYID, DUMMYNAME) VALUES (3, 'nro 3')");

        Statement streamStmt = null;

        try {
            streamStmt = clobberConn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
            streamStmt.setFetchSize(Integer.MIN_VALUE);

            this.rs = streamStmt.executeQuery("SELECT DUMMYID, DUMMYNAME FROM StreamingClobber ORDER BY DUMMYID");

            this.rs.next();

            // This should proceed normally, after the driver clears the input stream
            ResultSet rs2 = clobberStmt.executeQuery("SHOW VARIABLES");
            rs2.next();
            this.rs.close();
        } finally {
            if (streamStmt != null) {
                streamStmt.close();
            }
        }
    } finally {
        this.stmt.executeUpdate("DROP TABLE IF EXISTS StreamingClobber");
    }
}