java驱动sql2008r要的jar包_maven工程中如何引入sql server 2008 驱动jar包

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

try {

Connection conn = getConnection();

Statement st = conn.createStatement();

ResultSet set = st.executeQuery(sql);

List result = new ArrayList();

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);

}

}

posted on 2012-08-02 15:55 邦 阅读(4626) 评论(0)  编辑  收藏 所属分类: JAVA