用XML配置JDBC的批处理

2019-04-15 16:08发布

站内文章 / PIC单片机
17046 0 1288
[img]http://dl.iteye.com/upload/picture/pic/118473/06589381-2c22-3f1e-baf0-4a2d90bf53e9.png[/img]
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Map;

import javax.xml.bind.JAXBException;


public class QueryBtwRecharge {

public void query() throws FileNotFoundException, JAXBException, ClassNotFoundException, SQLException{

ConnConfReader connConfReader=new ConnConfReader();
Map map=connConfReader.getConnConf();

String dbDriver=map.get("dbDriver");
String url=map.get("url");
String user=map.get("user");
String password=map.get("password");
String sql=map.get("sql");

Class.forName(dbDriver);
Connection conn=DriverManager.getConnection(url, user, password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){

// System.out.println(rs.getString("cardnum")+" "+
// rs.getString("total_fee")+" "+
// rs.getString("createdate")+" "+
// rs.getString("ip")+" "+
// rs.getString("buyer_email")+" "
// );

System.out.println(rs.getString(1)+" "+
rs.getString(2)+" "+
rs.getString(3)+" "+
rs.getString(4)+" "
);
}

if(rs!=null){rs.close();}
if(stmt!=null){stmt.close();}
if(conn!=null){conn.close();}
}
}

热门文章