jdbc简单查询

#jdbc简单查询

package jdbc;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

public class jdbctest {
    public static void main(String[] args) throws Exception {
        jdbctest c1 = new jdbctest ();
        c1.getConnection2();
    }

    //连接数据库
    public void getConnection2() throws Exception {
        //1.创建数据库的4个字符串

        //2.创建Properties对象
        Properties pro = new Properties();
        //3.获取jdbc.pro对应的输入流
        InputStream in = this.getClass().getClassLoader().getResourceAsStream("jdbc.properties");
        //4.加载输入流
        pro.load(in);
        //5.具体决定4个字符串的值

//        String driver = "驱动连接";
//        String url = "数据库连接";
//        String userName = "用户";
//        String password = "密码";
        String driver = pro.getProperty("jdbc.driver");
        String jdbcUrl = pro.getProperty("jdbc.url");
        String user = pro.getProperty("jdbc.username");
        String password = pro.getProperty("jdbc.password");
        //6.加载数据库驱动程序
        Class.forName(driver);
        //7.通过DriverManager的getConnection()方法获取数据库连接
        Connection conn = DriverManager.getConnection(jdbcUrl, user, password);
        System.out.println(conn);

        //查询sql
        String sql = "select * from user";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()) {

            String id = rs.getString("id");
            System.out.println(id);
            String username = rs.getString("username");
            System.out.println(username);
        }

    }

}

C:\Developt\Java\jdk1.8.0_91\bin\java.exe "-javaagent:C:\Developt\IntelliJ IDEA 2020.3\lib\idea_rt.jar=49440:C:\Developt\IntelliJ IDEA 2020.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Developt\Java\jdk1.8.0_91\jre\lib\charsets.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\deploy.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\access-bridge-64.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\cldrdata.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\dnsns.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\jaccess.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\jfxrt.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\localedata.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\nashorn.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\sunec.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\sunjce_provider.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\sunmscapi.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\sunpkcs11.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\ext\zipfs.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\javaws.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\jce.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\jfr.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\jfxswt.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\jsse.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\management-agent.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\plugin.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\resources.jar;C:\Developt\Java\jdk1.8.0_91\jre\lib\rt.jar;C:\IDEA_workspace\laypageDemo\target\classes;C:\maven_repository\org\springframework\spring-context\4.1.3.RELEASE\spring-context-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-aop\4.1.3.RELEASE\spring-aop-4.1.3.RELEASE.jar;C:\maven_repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\maven_repository\org\springframework\spring-core\4.1.3.RELEASE\spring-core-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-expression\4.1.3.RELEASE\spring-expression-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-beans\4.1.3.RELEASE\spring-beans-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-webmvc\4.1.3.RELEASE\spring-webmvc-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-web\4.1.3.RELEASE\spring-web-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-jdbc\4.1.3.RELEASE\spring-jdbc-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-tx\4.1.3.RELEASE\spring-tx-4.1.3.RELEASE.jar;C:\maven_repository\org\springframework\spring-aspects\4.1.3.RELEASE\spring-aspects-4.1.3.RELEASE.jar;C:\maven_repository\org\aspectj\aspectjweaver\1.8.4\aspectjweaver-1.8.4.jar;C:\maven_repository\org\mybatis\mybatis\3.2.8\mybatis-3.2.8.jar;C:\maven_repository\org\mybatis\mybatis-spring\1.2.2\mybatis-spring-1.2.2.jar;C:\maven_repository\com\github\abel533\mapper\2.3.4\mapper-2.3.4.jar;C:\maven_repository\javax\persistence\persistence-api\1.0\persistence-api-1.0.jar;C:\maven_repository\commons-beanutils\commons-beanutils\1.9.2\commons-beanutils-1.9.2.jar;C:\maven_repository\commons-collections\commons-collections\3.2.1\commons-collections-3.2.1.jar;C:\maven_repository\com\github\pagehelper\pagehelper\3.7.5\pagehelper-3.7.5.jar;C:\maven_repository\com\github\jsqlparser\jsqlparser\0.9.1\jsqlparser-0.9.1.jar;C:\maven_repository\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;C:\maven_repository\com\google\protobuf\protobuf-java\3.11.4\protobuf-java-3.11.4.jar;C:\maven_repository\org\slf4j\slf4j-log4j12\1.6.4\slf4j-log4j12-1.6.4.jar;C:\maven_repository\org\slf4j\slf4j-api\1.6.4\slf4j-api-1.6.4.jar;C:\maven_repository\log4j\log4j\1.2.16\log4j-1.2.16.jar;C:\maven_repository\com\fasterxml\jackson\core\jackson-databind\2.4.2\jackson-databind-2.4.2.jar;C:\maven_repository\com\fasterxml\jackson\core\jackson-annotations\2.4.0\jackson-annotations-2.4.0.jar;C:\maven_repository\com\fasterxml\jackson\core\jackson-core\2.4.2\jackson-core-2.4.2.jar;C:\maven_repository\com\jolbox\bonecp-spring\0.8.0.RELEASE\bonecp-spring-0.8.0.RELEASE.jar;C:\maven_repository\com\jolbox\bonecp\0.8.0.RELEASE\bonecp-0.8.0.RELEASE.jar;C:\maven_repository\com\google\guava\guava\15.0\guava-15.0.jar;C:\maven_repository\org\apache\httpcomponents\httpclient\4.3.5\httpclient-4.3.5.jar;C:\maven_repository\org\apache\httpcomponents\httpcore\4.3.2\httpcore-4.3.2.jar;C:\maven_repository\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;C:\maven_repository\jstl\jstl\1.2\jstl-1.2.jar;C:\maven_repository\joda-time\joda-time\2.5\joda-time-2.5.jar;C:\maven_repository\org\apache\commons\commons-lang3\3.3.2\commons-lang3-3.3.2.jar;C:\maven_repository\commons-io\commons-io\1.3.2\commons-io-1.3.2.jar;C:\maven_repository\commons-codec\commons-codec\1.9\commons-codec-1.9.jar;C:\maven_repository\org\hibernate\hibernate-validator\5.1.3.Final\hibernate-validator-5.1.3.Final.jar;C:\maven_repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;C:\maven_repository\org\jboss\logging\jboss-logging\3.1.3.GA\jboss-logging-3.1.3.GA.jar;C:\maven_repository\com\fasterxml\classmate\1.0.0\classmate-1.0.0.jar;C:\maven_repository\commons-fileupload\commons-fileupload\1.3.1\commons-fileupload-1.3.1.jar;C:\maven_repository\org\junit\jupiter\junit-jupiter\5.7.0\junit-jupiter-5.7.0.jar;C:\maven_repository\org\junit\jupiter\junit-jupiter-api\5.7.0\junit-jupiter-api-5.7.0.jar;C:\maven_repository\org\apiguardian\apiguardian-api\1.1.0\apiguardian-api-1.1.0.jar;C:\maven_repository\org\opentest4j\opentest4j\1.2.0\opentest4j-1.2.0.jar;C:\maven_repository\org\junit\platform\junit-platform-commons\1.7.0\junit-platform-commons-1.7.0.jar;C:\maven_repository\org\junit\jupiter\junit-jupiter-params\5.7.0\junit-jupiter-params-5.7.0.jar;C:\maven_repository\org\junit\jupiter\junit-jupiter-engine\5.7.0\junit-jupiter-engine-5.7.0.jar;C:\maven_repository\org\junit\platform\junit-platform-engine\1.7.0\junit-platform-engine-1.7.0.jar jdbc.jdbctest
com.mysql.cj.jdbc.ConnectionImpl@c038203
1
zhangsan1
2
zhangsan2
3
zhangsan4
4