<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.util.*,org.spring.dao.factory.DaoFactory"%>
<%@page import="com.web.dao.*"%>
<%@page import="com.web.deal.*"%>
<%@page import="com.web.manager.*"%>
<%@page import="com.web.defince.*,org.spring.jdbc.core.DateAccessException" %>
<%@ include file="../checkLock.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<jsp:useBean id="ConfigUtils" class="com.web.pub.ConfigUtils" scope="page" />
<title>鉴定报告书打印</title>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<style media=print>
.NOPRINT{display:none;}
.PageNext{page-break-after: always;}
</style>
<style type="text/css">
<!--
.STYLE4 {
font-size: 50px;
font-weight: bold;
font-family: "隶书";
}
-->
</style>
</head><body>
<OBJECT classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 id=WB width=0 VIEWASTEXT></OBJECT>
<div class="NOPRINT">
<table width="400" border="0" align="center" cellspacing="0">
<tr>
<td><div align="center">
<input name="Submit" type="button" class="but4_bg" value="页面设置" onClick="document.all.WB.ExecWB(8,1)">
<input name="Submit2" type="button" class="but4_bg" value="打印预览" onClick="document.all.WB.ExecWB(7,1)">
<input name="Submit3" type="button" class="but4_bg" value="打印...." onClick="document.all.WB.ExecWB(6,1)">
</div></td>
</tr>
<tr>
<td class="chinesefont105pt">打印设置如下:<BR>
1、纸张格式:鉴定报告书打印<br>
2、纸张大小:宽24.00cm,高27.94cm<br>
3、方向:纵向<br>
4、页边距(mm) 左:3.25 右:40 上:4.25 下:14.11</td>
</tr>
</table>
</div>
<%
String id=request.getParameter("id");
Contman deal=new Contman();
content bk4=deal.getOneCsej(id);
%>
<table width="800" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="100" align="center" valign="middle" class="STYLE4"></td>
</tr>
<tr>
<td height="100" align="left" valign="top">1111111111111<%=bk4.getEjbac1()%</td>
</tr>
<tr>
<td height="50" align="left" valign="top">当前状况:</td>
</tr>
<tr>
<td height="50"> </td>
</tr>
<tr>
<td height="200"> </td>
</tr>
</table>
</body>
</html>上面是单条数据打印的,怎么取不到数据库的数据???
<%@page import="java.util.*,org.spring.dao.factory.DaoFactory"%>
<%@page import="com.web.dao.*"%>
<%@page import="com.web.deal.*"%>
<%@page import="com.web.manager.*"%>
<%@page import="com.web.defince.*,org.spring.jdbc.core.DateAccessException" %>
<%@ include file="../checkLock.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<jsp:useBean id="ConfigUtils" class="com.web.pub.ConfigUtils" scope="page" />
<title>鉴定报告书打印</title>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<style media=print>
.NOPRINT{display:none;}
.PageNext{page-break-after: always;}
</style>
<style type="text/css">
<!--
.STYLE4 {
font-size: 50px;
font-weight: bold;
font-family: "隶书";
}
-->
</style>
</head><body>
<OBJECT classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 id=WB width=0 VIEWASTEXT></OBJECT>
<div class="NOPRINT">
<table width="400" border="0" align="center" cellspacing="0">
<tr>
<td><div align="center">
<input name="Submit" type="button" class="but4_bg" value="页面设置" onClick="document.all.WB.ExecWB(8,1)">
<input name="Submit2" type="button" class="but4_bg" value="打印预览" onClick="document.all.WB.ExecWB(7,1)">
<input name="Submit3" type="button" class="but4_bg" value="打印...." onClick="document.all.WB.ExecWB(6,1)">
</div></td>
</tr>
<tr>
<td class="chinesefont105pt">打印设置如下:<BR>
1、纸张格式:鉴定报告书打印<br>
2、纸张大小:宽24.00cm,高27.94cm<br>
3、方向:纵向<br>
4、页边距(mm) 左:3.25 右:40 上:4.25 下:14.11</td>
</tr>
</table>
</div>
<%
String id=request.getParameter("id");
Contman deal=new Contman();
content bk4=deal.getOneCsej(id);
%>
<table width="800" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="100" align="center" valign="middle" class="STYLE4"></td>
</tr>
<tr>
<td height="100" align="left" valign="top">1111111111111<%=bk4.getEjbac1()%</td>
</tr>
<tr>
<td height="50" align="left" valign="top">当前状况:</td>
</tr>
<tr>
<td height="50"> </td>
</tr>
<tr>
<td height="200"> </td>
</tr>
</table>
</body>
</html>上面是单条数据打印的,怎么取不到数据库的数据???
上面打错了!!!
Contman deal=new Contman();
这个类 代码呢
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.List;import org.spring.jdbc.core.DateAccessException;
import org.spring.jdbc.core.JdbcTemplate;
import org.spring.jdbc.core.PreparedStatementSetter;
import org.spring.jdbc.core.ResultSetter;
import org.spring.jdbc.datasource.DatasourceTransactionManager;import com.web.dao.AppraisalDao;
import com.web.defince.Condition;
import com.web.defince.Csej;
import com.web.defince.content;
import com.web.pub.ConfigUtils;
import com.web.pub.PageControl;public class Contman {
public content getOneCsej(String id) throws DateAccessException {
final Hashtable ht=new Hashtable();
jdbcFactory().qusery("SELECT content.* FROM content",new ResultSetter(){ public void processRow(ResultSet rs) throws SQLException {
// TODO 自动生成方法存根
while(rs.next()){
content list_ok=new content();
list_ok.setJdid(rs.getString("jdid"));
list_ok.setEjbac1(rs.getString("ejbac1"));
list_ok.setEjnum1(rs.getString("ejnum1"));
list_ok.setEjmod1(rs.getString("ejmod1"));
list_ok.setEjkhmc(rs.getString("ejkhmc"));
list_ok.setEjkhjc(rs.getString("ejkhjc"));
list_ok.setEjcype(rs.getString("ejcype"));
list_ok.setEjptn1(rs.getString("ejptn1"));
list_ok.setEjptn2(rs.getString("ejptn2"));
list_ok.setEjptn3(rs.getString("ejptn3"));
list_ok.setEjbac2(rs.getString("ejbac2"));
list_ok.setEjnum2(rs.getString("ejnum2"));
list_ok.setEjdat2(rs.getString("ejdat2"));
list_ok.setEjmod2(rs.getString("ejmod2"));
list_ok.setEjdat3(rs.getString("ejdat3"));
list_ok.setEjbeizhu(ConfigUtils.getBytes(rs.getObject("ejbeizhu").toString()));
}
}
});
if(ht.get("content")==null) ht.put("content",new content());
return (content)ht.get("content");
} public String getUserName(String userid) throws DateAccessException {
// TODO 自动生成方法存根
return null;
} public int insertCsej(Csej csej) throws DateAccessException {
// TODO 自动生成方法存根
return 0;
} public int updateCsej(Csej csej) throws DateAccessException {
// TODO 自动生成方法存根
return 0;
} private static JdbcTemplate jdbcFactory(){
return new JdbcTemplate(DatasourceTransactionManager.Create());
}
private content initialize(content content) {
// TODO 自动生成方法存根
return null;
}
public int insertcontent(final content Content) throws DateAccessException {
// TODO 自动生成方法存根
//final content Content1=Content;
int i=jdbcFactory().update("INSERT INTO content (jdid, ejbac1, ejnum1, ejmod1, ejkhmc, Submit5, ejkhjc, ejcype, ejptn1, ejptn2, ejptn3, ejbac2, ejnum2, ejdat2, ejmod2, ejdat3, ejbeizhu)" +
" VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",new PreparedStatementSetter(){ public void setValues(PreparedStatement ps) throws SQLException {
// TODO 自动生成方法存根 ps.setString(1,Content.getJdid().toUpperCase());
ps.setString(2,ConfigUtils.getBytes(Content.getEjbac1()));
ps.setString(3,ConfigUtils.getBytes(Content.getEjnum1()));
ps.setString(4,ConfigUtils.getBytes(Content.getEjmod1()));
ps.setString(5,ConfigUtils.getBytes(Content.getEjkhmc()));
ps.setString(6,ConfigUtils.getBytes(Content.getSubmit5()));
ps.setString(7,ConfigUtils.getBytes(Content.getEjkhjc()));
ps.setString(8,ConfigUtils.getBytes(Content.getEjcype()));
ps.setString(9,ConfigUtils.getBytes(Content.getEjptn1()));
ps.setString(10,ConfigUtils.getBytes(Content.getEjptn2()));
ps.setString(11,ConfigUtils.getBytes(Content.getEjptn3()));
ps.setString(12,ConfigUtils.getBytes(Content.getEjbac2()));
ps.setString(13,ConfigUtils.getBytes(Content.getEjnum2()));
ps.setString(14,ConfigUtils.getBytes(Content.getEjdat2()));
ps.setString(15,ConfigUtils.getBytes(Content.getEjmod2()));
ps.setString(16,ConfigUtils.getBytes(Content.getEjdat3()));
ps.setString(17,ConfigUtils.getBytes(Content.getEjbeizhu())); }
});
return i;
}
public List getlist(String par1,String par2) throws DateAccessException
{
final List data=new ArrayList();
String sql="SELECT * FROM content ";
jdbcFactory().qusery("SELECT * FROM content ",new ResultSetter(){ public void processRow(ResultSet rs) throws SQLException {
// TODO 自动生成方法存根
while(rs.next()){
content list_ok=new content();
list_ok.setJdid(rs.getString("jdid"));
list_ok.setEjbac1(rs.getString("ejbac1"));
list_ok.setEjnum1(rs.getString("ejnum1"));
list_ok.setEjmod1(rs.getString("ejmod1"));
list_ok.setEjkhmc(rs.getString("ejkhmc"));
list_ok.setEjkhjc(rs.getString("ejkhjc"));
list_ok.setEjcype(rs.getString("ejcype"));
list_ok.setEjptn1(rs.getString("ejptn1"));
list_ok.setEjptn2(rs.getString("ejptn2"));
list_ok.setEjptn3(rs.getString("ejptn3"));
list_ok.setEjbac2(rs.getString("ejbac2"));
list_ok.setEjnum2(rs.getString("ejnum2"));
list_ok.setEjdat2(rs.getString("ejdat2"));
list_ok.setEjmod2(rs.getString("ejmod2"));
list_ok.setEjdat3(rs.getString("ejdat3"));
list_ok.setEjbeizhu(ConfigUtils.getByte(rs.getObject("ejbeizhu").toString()));
data.add(list_ok);
}
}
});
return data;
}
protected Object clone() throws CloneNotSupportedException {
// TODO 自动生成方法存根
return super.clone();
} public boolean equals(Object obj) {
// TODO 自动生成方法存根
return super.equals(obj);
} protected void finalize() throws Throwable {
// TODO 自动生成方法存根
super.finalize();
} public int hashCode() {
// TODO 自动生成方法存根
return super.hashCode();
} public String toString() {
// TODO 自动生成方法存根
return super.toString();
} public int insertCsej(content obj) throws DateAccessException {
// TODO 自动生成方法存根
String sql="INSERT INTO content (jdid, ejbac1, ejnum1, ejmod1, ejkhmc, Submit5, ejkhjc, ejcype, ejptn1, ejptn2, ejptn3, ejbac2, ejnum2, ejdat2, ejmod2, ejdat3, ejbeizhu) "+
" VALUES ('"+obj.getJdid()+"','"+obj.getEjbac1()+"','"+obj.getEjnum1()+"','"+obj.getEjmod1()+"','"+obj.getEjkhmc()+"','"+obj.getSubmit5()+"','"+obj.getEjkhjc()+"','"+obj.getEjcype()+"','"+obj.getEjptn1()+"','"+obj.getEjptn2()+"','"+obj.getEjptn3()+"','"+obj.getEjbac2()+"','"+obj.getEjnum2()+"','"+obj.getEjdat2()+"','"+obj.getEjmod2()+"','"+obj.getEjdat3()+"','"+obj.getEjbeizhu()+"')";
int i=jdbcFactory().update(sql);
return i;
} public int updateCsej(content obj) throws DateAccessException {
// TODO 自动生成方法存根
String sql="UPDATE content (jdid, ejbac1, ejnum1, ejmod1, ejkhmc, Submit5, ejkhjc, ejcype, ejptn1, ejptn2, ejptn3, ejbac2, ejnum2, ejdat2, ejmod2, ejdat3, ejbeizhu) "+
" VALUES ('"+obj.getJdid()+"','"+obj.getEjbac1()+"','"+obj.getEjnum1()+"','"+obj.getEjmod1()+"','"+obj.getEjkhmc()+"','"+obj.getSubmit5()+"','"+obj.getEjkhjc()+"','"+obj.getEjcype()+"','"+obj.getEjptn1()+"','"+obj.getEjptn2()+"','"+obj.getEjptn3()+"','"+obj.getEjbac2()+"','"+obj.getEjnum2()+"','"+obj.getEjdat2()+"','"+obj.getEjmod2()+"','"+obj.getEjdat3()+"','"+obj.getEjbeizhu()+"')";
int i=jdbcFactory().update(sql);
return i;
}
}我用Eclipse的