【学习】第1个JAVA

NO66781

于 2020-10-19 17:58:41 发布

阅读量165

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/NO66781/article/details/109165622

版权

JAVA 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

import java.sql.*;

public class DataConn {
    public static void main(String[] args) throws SQLException,ClassNotFoundException{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url ="jdbc:sqlserver://127.0.0.1:1433;databaseName=HSZX;user=sa;password=******";
        Connection conn = DriverManager.getConnection(url);
        String sql ="select top 100 spid,spbh,spmch,shpgg,jlgg,dw,pizhwh from spkfk";
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        while (rs.next()){
            System.out.println(rs.getString(1)
                                + " " + rs.getString(2)
                                + " " + rs.getString(3)
                                + " " + rs.getString(4)
                                + " " + rs.getString(5)
                                + " " + rs.getString(6)
                                + " " + rs.getString(7)
            );
        }
        rs.close();
        conn.close();;
    }

}

执行结果：