查询数据库中的满足特定条件的数据

---

//本地数据库已有的数据，要从这个表中过滤出Id为1的行，然后把该ProductName和Inventory输出

 1 import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


/**
 * @author 神余健芝
 * @date 创建时间：2017年5月18日 下午6:11:07
 */
public class MySQLDemo {
    
    static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost/shen_db?useUnicode=true&characterEncoding=utf-8&useSSL=false";
    static final String DB_USER_NAME = "root";
    static final String DB_PASSWORD = "123456";
    
    public static void main(String[] args) throws ClassNotFoundException {
        helloworld();
    }

    public static void helloworld() throws ClassNotFoundException {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        // 1、装载驱动程序
        Class.forName(DRIVER_NAME);
        // 2、建立数据库链接
        try {
            connection = DriverManager.getConnection(DB_URL, DB_USER_NAME,DB_PASSWORD);
            // 3、执行SQL语句
            statement = connection.createStatement();
            resultSet = statement.executeQuery("select * from test where Id=1");
            // 4、获取结果
            while (resultSet.next()) {
                System.out.println("ProductName:" + resultSet.getString("ProductName"));
                System.out.println("Inventory:"+resultSet.getString("Inventory"));
            }
        } catch (SQLException e) {
            // 异常处理
            e.printStackTrace();
        } finally {
            //清理资源
            try {
                if (connection != null) {
                    connection.close();
                }
                if (statement != null) {
                    statement.close();
                }
                if (resultSet != null) {
                    resultSet.close();
                }
            } catch (SQLException e) {
                // 忽略
            }
        }
    }
}