String getString(String columnLabel)
package mysql_jdbc;
import utils.MySQLtool;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBCtext6 {
public static void main(String[] args) throws Exception{
Connection conn = MySQLtool.init();
Statement stat = conn.createStatement();
//查询 用executeQuery()方法
ResultSet resultSet = stat.executeQuery("select l1,l2,l3,l4,l5 from free");
//resultSet.next()取出每一行,用While是循环取出,直到光标移动至没有数据那一行为止
while (resultSet.next()){
//String getString(String columnLabel)获取列名得到那一列的值
String l1 = resultSet.getString("l1");
String l2 = resultSet.getString("l2");
String l3 = resultSet.getString("l3");
String l4 = resultSet.getString("l4");
String l5 =