用XML配置JDBC的批处理-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_21104/article/details/82411190

本文介绍了一个使用Java实现的查询充值记录的程序，通过配置文件读取数据库连接信息，并执行SQL查询操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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<String,String> 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")+"\t"+
//					rs.getString("total_fee")+"\t"+
//					rs.getString("createdate")+"\t"+
//					rs.getString("ip")+"\t"+
//					rs.getString("buyer_email")+"\t"
//			);

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

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