executeQuery() 和 select

最新推荐文章于 2021-08-09 19:27:43 发布

weixin_34303897

最新推荐文章于 2021-08-09 19:27:43 发布

阅读量241

点赞数

CC 4.0 BY-SA版权

文章标签： java 数据库

原文链接：http://www.cnblogs.com/duantl/archive/2011/04/22/2025341.html

本文介绍如何使用Java语言通过JDBC技术连接SQL Server数据库，并演示了如何执行SQL查询语句来获取学生的基本信息。

package com.wangguan;

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

public class Test2Jdbc {
    public static void main(String[] args) {
        Connection con = null;
        Statement  sta = null;
        ResultSet     rs = null;
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String url = "jdbc:sqlserver://127.0.1:1433;databaseName=studentManager";
            con = DriverManager.getConnection(url, "sa", "wangguan");
            sta = con.createStatement();
            String sql = "select " +
                        "    stuId, stuName, address, stuTel, age " +
                        "from " +
                        "    student";
            rs = sta.executeQuery(sql);
            while (rs.next()) {
                int i = 1;
                int stuId = rs.getInt(i ++);
                String stuName = rs.getString(i ++);
                String address = rs.getString(i ++);
                String stuTel = rs.getString(i ++);
                int age = rs.getInt(i ++);
                System.out.println(stuId + " " +stuName + " " + address + " " + stuTel + " " +age);
            }

            rs.close();
            sta.close();
            con.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if(rs != null) {
                    rs.close();
                    rs = null;
                }
                if(sta != null) {
                    sta.close();
                    sta = null;
                }
                if(con != null) {
                    con.close();
                    con = null;
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

转载于:https://www.cnblogs.com/duantl/archive/2011/04/22/2025341.html