maven工程中如何引入sql server 2008 驱动jar包
http://www.blogjava.net/bang/archive/2012/08/02/384617.html
用jTDS通过JDBC连：
|
1 2 3 4 5 6 |
Xml代码 <dependency> <groupId>net.sourceforge.jtds</groupId> <artifactId>jtds</artifactId> <version>1.2.4</version> </dependency> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
Java代码 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); } } |
