CSV JDBC 数据库Parameter Junit

运行代码如下 @Test        public void test2() throws SQLException{            String url="jdbc:mysql://localhost:3306/test";            String user="root";            String pwd="";            List<String[]> result=jdbcDriver(url,user,pwd);        }        其中url的test为数据库名

这里直接运行代码@RunWith(Parameterized.class)public class TestParameter {    private String name;    private String passwd;    public  TestParameter(String name,String passwd){        this.name=name;        this.passwd=passwd;    }    @Parameters    public static Collection<String[]> getData() throws FileNotFoundException{//      return Arrays.asList(new //              String[][]{{"ray","ray"},{"cll","cll"}});        return DButil.csvDriver("D:\\Mars_WorkSpace\\webdrivertest\\userinfo.csv");    }    @Test    public void testparameter(){        System.out.println(name+"===="+passwd);    }}数据库以及CSV方法调用如下public class DButil {    public static List<String[]> csvDriver(String filepath) throws FileNotFoundException{        List<String[]> list=new ArrayList<String[]>();        InputStream in=new FileInputStream(filepath);        BufferedReader buf=null;        buf=new BufferedReader(new InputStreamReader(in));        try {            String temp=null;            while(buf.readLine()!= null){                temp=buf.readLine();                String user[]=temp.split(",");                list.add(user);            }            buf.close();            in.close();        } catch (IOException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return list;    }    public static List<String[]> jdbcDriver(String url,String user,String pwd) throws SQLException{        //需要mysql-connection-java.jar        List<String[]> list=new ArrayList<String[]>();        Connection con=null;        PreparedStatement ps=null;        ResultSet rs=null;        String sql="select * from test";        try {            Class.forName("com.mysql.jdbc.Driver");            //注意这个是mysql数据库        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        //三个变量分别是jdbc:mysql://localhost:3306/test root root        con=DriverManager.getConnection(url,user,pwd);        ps=con.prepareStatement(sql);        rs=ps.executeQuery();        while(rs.next()){            String[] users=new String[2];            users[0]=rs.getString(0);            users[1]=rs.getString(1);            list.add(users);        }        rs.close();        ps.close();        con.close();        return list;    }}以上的csv会出现每两行只读取一行的效果，未知原因所以改进如下，但是会出现测试时最后一行报错，但是能够实现的情况，暂时代码如下public class CSVReader {    public static List<String[]> ReaderCSV(String filepath) throws IOException{    List<String[]> list=new ArrayList<String[]>();    //String path="D:\\Mars_WorkSpace\\webdrivertest\\userinfo.csv";    FileInputStream fin = new FileInputStream(filepath);     BufferedReader buffReader=new BufferedReader(new InputStreamReader(fin));    String lineInfo=buffReader.readLine();    while(lineInfo!= null)    {    String user[]=lineInfo.split(",");    list.add(user);    lineInfo = buffReader.readLine();    }    return list;    }}