数据库连接到ireport简单示例

1.myeclipse建立web项目

2.建立实体类

package com.icss.demo.entity;


public class TBook {
private String lsbzdw_dwbh;
private String lsbzdw_dwmc;
public String getLsbzdw_dwbh() {
return lsbzdw_dwbh;
}
public void setLsbzdw_dwbh(String lsbzdw_dwbh) {
this.lsbzdw_dwbh = lsbzdw_dwbh;
}
public String getLsbzdw_dwmc() {
return lsbzdw_dwmc;
}
public void setLsbzdw_dwmc(String lsbzdw_dwmc) {
this.lsbzdw_dwmc = lsbzdw_dwmc;
}


}

3.建立jdbc

package com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap; 
import java.util.List;
import java.util.Map;
import com.icss.demo.entity.*;


public class JdbcUtils {
// 定义数据库的用户名
private final String USERNAME = "l8**";
// 定义数据库的密码
private final String PASSWORD = "8*9";
// 定义数据库的驱动信息
private final String DRIVER = "oracle.jdbc.driver.OracleDriver";
// 定义访问数据库的地址
private final String URL = "jdbc:oracle:thin:@//133.33.33.3/gs";
private Connection connection;
// 定义sql语句的执行对象
private PreparedStatement pstmt;
// 定义查询返回的结果集合
private ResultSet resultSet;
// 实现批处理的功能
private Statement stmt;

public JdbcUtils() {
try {
Class.forName(DRIVER);


System.out.println("注册驱动成功！！");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("注册驱动失败");
}

}
// 定义获得数据库的连接
public Connection getConnection() {

System.out.println("getConnection!");


try {
System.out.println("connnn");
connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);


} catch (Exception e) {
// TODO: handle exception
System.out.println("Connection exception !");
}
return connection;


}


public List<TBook> StSelect() {
List<TBook> list = new ArrayList<TBook>();

try {


String sql = "select * from LSBZDW";

this.getConnection();
PreparedStatement ps = this.connection.prepareStatement(sql);
ResultSet resultSet = ps.executeQuery(); // 返回查询结果
while (resultSet.next()) {

String lsbzdw_dwbh = resultSet.getString("lsbzdw_dwbh");
String lsbzdw_dwmc = resultSet.getString("lsbzdw_dwmc");
System.out.println(lsbzdw_dwmc);
TBook book = new TBook();
book.setLsbzdw_dwbh(lsbzdw_dwbh);
book.setLsbzdw_dwmc(lsbzdw_dwmc);
    list.add(book);
}
} catch (SQLException e) {


e.printStackTrace();
}
return list;
}




public void releaseConn(){
if (resultSet!=null) {
try {
resultSet.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}

}
if(stmt!=null){

try {
stmt.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
if (pstmt!=null) {
try {
pstmt.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
if (connection!=null) {
try {
connection.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}

}

4.servlet

package serv;


import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;


import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;




import com.icss.demo.entity.TBook;


import com.jdbc.JdbcUtils;


public class servbook extends HttpServlet {


public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {


ServletOutputStream servletOutputStream = response.getOutputStream();
InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("myreport004.jasper");

JdbcUtils studao = new JdbcUtils();
try {


List<TBook> books = studao.StSelect();

JRBeanCollectionDataSource DataSource = new JRBeanCollectionDataSource(books);
JasperRunManager.runReportToPdfStream(reportStream,servletOutputStream,null,DataSource);
response.setContentType("applicationf");
servletOutputStream.flush();
servletOutputStream.close();

} catch (JRException e) {


}
}


}