该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
package com.service;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import com.bstek.dorado.annotation.DataProvider;
import com.entity.Shop;
import com.sun.javafx.collections.MappingChange.Map;
public class ShopService {
@DataProvider
public List getShopInfo(Map params){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLSeverDriver");//数据库驱动
String url = "jdbc:microsoft:sqlsever://localhost:1433;DatabaseName=zaizhipin";//数据库链接地址
String user = "sa";//用户名
String password = "wuxinyao";//密码
Connection conn = DriverManager.getConnection(url, user, password);//建立connection
Statement stmt = conn.createStatement();
conn.setAutoCommit(false);// 更改jdbc事务的默认提交方式
String sql = "select * from chejian";//查询语句
ResultSet rs = stmt.executeQuery(sql);//得到结果集
conn.commit();//事务提交
conn.setAutoCommit(true);// 更改jdbc事务的默认提交方式
List list=new ArrayList();//创建取结果的列表
while (rs.next()) {
Shop shop = new Shop();
shop.setId(rs.getString("id"));
shop.setPart(rs.getString("part"));
list.add(shop);
}
return list;
}catch(Exception e){
e.printStackTrace();
}
}
}