maven工程中如何引入sql server 2008 驱动jar包

最新推荐文章于 2024-10-01 18:51:18 发布

不净之心

最新推荐文章于 2024-10-01 18:51:18 发布

阅读量423

点赞数

分类专栏： Hibernate&MyBatis Database 文章标签： java 数据库

本文链接：https://blog.csdn.net/pyzheng/article/details/84398675

版权

Hibernate&MyBatis 同时被 2 个专栏收录

115 篇文章 0 订阅

订阅专栏

Database

104 篇文章 0 订阅

订阅专栏

[url]http://www.blogjava.net/bang/archive/2012/08/02/384617.html[/url]

用jTDS通过JDBC连：

<dependency>
  <groupId>net.sourceforge.jtds</groupId>
  <artifactId>jtds</artifactId>
  <version>1.2.4</version>
</dependency>

public static List<String> executeQuery(String sql,String columns) {

        try {
            Connection conn = getConnection();
            Statement st = conn.createStatement();
            ResultSet set = st.executeQuery(sql);
            List<String> result = new ArrayList<String>();
            while (set.next()) {
                String[] columnList = columns.split(",");
                for(String str:columnList){
                    result.add(set.getString(str));
                }

            }
            set.close();
            st.close();
            conn.close();
            return result;
        } catch (SQLException e) {
            throw new IllegalArgumentException(e);
        }
    }

    public static Connection getConnection() {
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            String url = "jdbc:jtds:sqlserver://localhost:1433;DatabaseName=jdl";
            String username = "sa";
            String password = "";
            Connection conn = DriverManager.getConnection(url, username,
            password);
            return conn;
        } catch (Exception e) {
            throw new IllegalArgumentException(e);
        }
    }