我这段代码希望实现不通过servlet层,直接在数据库中读取数据,并且绑定到页面上,实现如下的静态信息,但是小弟目前所做的项目都是通过servlet层,所以不知道如何操作,希望各位大虾可以帮助小弟,我弟在此拜求!!!
<li><a href="http://www.gzpg.com.cn/">贵州人民出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">明天出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">新蕾出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">海燕出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">人民教育出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">现代出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">漓江出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">光明出版社</a></li>service层
private Pagesinterface pages=new Pagesinterfaceimpl();
//读入出版社信息
public List<olinebookstoresdto> book_Press()
{
Connection conn=null;
List<olinebookstoresdto> pageRead=new ArrayList<olinebookstoresdto>();
try
{
conn=database.getConn();
pages.setconnection(conn);
pageRead=pages.book_Press();
}
catch(SQLException sql)
{
sql.printStackTrace();
}
finally
{
database.releaseConnection(conn);
}
return pageRead;
}DAO层
DAO接口类
public interface Pagesinterface { public List<olinebookstoresdto> book_Press();
public Connection getconnection();
public void setconnection(Connection connecion);
}
DAO实现接口类
//读取出版社信息
public List<olinebookstoresdto> book_Press() {
PreparedStatement ps=null;
ResultSet rs=null;
olinebookstoresdto press=null;
List<olinebookstoresdto> pageRead=new ArrayList<olinebookstoresdto>();
try
{
ps=conn.prepareStatement("select * from press");
rs=ps.executeQuery();
while(rs.next())
{
press=new olinebookstoresdto();
press.setPress(rs.getString("ps_name"));
pageRead.add(press);
}
}
catch(SQLException sql)
{
sql.printStackTrace();
}
finally
{
closeResultSet(rs);
closeStatement(ps);
}
return pageRead;
}
<li><a href="http://www.gzpg.com.cn/">贵州人民出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">明天出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">新蕾出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">海燕出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">人民教育出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">现代出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">漓江出版社</a></li>
<li><a href="http://www.gzpg.com.cn/">光明出版社</a></li>service层
private Pagesinterface pages=new Pagesinterfaceimpl();
//读入出版社信息
public List<olinebookstoresdto> book_Press()
{
Connection conn=null;
List<olinebookstoresdto> pageRead=new ArrayList<olinebookstoresdto>();
try
{
conn=database.getConn();
pages.setconnection(conn);
pageRead=pages.book_Press();
}
catch(SQLException sql)
{
sql.printStackTrace();
}
finally
{
database.releaseConnection(conn);
}
return pageRead;
}DAO层
DAO接口类
public interface Pagesinterface { public List<olinebookstoresdto> book_Press();
public Connection getconnection();
public void setconnection(Connection connecion);
}
DAO实现接口类
//读取出版社信息
public List<olinebookstoresdto> book_Press() {
PreparedStatement ps=null;
ResultSet rs=null;
olinebookstoresdto press=null;
List<olinebookstoresdto> pageRead=new ArrayList<olinebookstoresdto>();
try
{
ps=conn.prepareStatement("select * from press");
rs=ps.executeQuery();
while(rs.next())
{
press=new olinebookstoresdto();
press.setPress(rs.getString("ps_name"));
pageRead.add(press);
}
}
catch(SQLException sql)
{
sql.printStackTrace();
}
finally
{
closeResultSet(rs);
closeStatement(ps);
}
return pageRead;
}
解决方案 »
- java6.0 webservice tomcat 问题
- 判断是否安装了flash play
- spring连接数据源简历表,但在Oracle里select * from tab查不出
- forEach求助
- struts文件上传问题
- 按年份查询后在页面上列出数据,之后有按纽能导出个excel表!谁有代码~谢谢了,急~
- discuz 集成 javaee web项目,从discuz端修改密码同步
- 请问哪有WebLogic5.1的license?
- Spring初始化Map的问题
- no matching editors or conversion strategy found
- proxool和c3p0有什么区别
- &#后面是五位数字的编码问题
<%
pagesoperation page_press=new pagesoperation();
List<olinebookstoresdto> page_Read=new ArrayList<olinebookstoresdto>();
page_Read=page_press.book_Press();
olinebookstoresdto press=new olinebookstoresdto();
%>
</head>
<body>
<%
for(int i=0;i<page_Read.size();i++){
press=(olinebookstoresdto)page_Read.get(i);
%>
<li><a href="#"><%=press.getPress()%></a></li>
<%} %>
</body>
但是显示是确报错type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionorg.apache.jasper.JasperException: /text.jsp(3,0) Page directive has invalid attribute: improt
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:198)
org.apache.jasper.compiler.JspUtil.checkAttributes(JspUtil.java:311)
org.apache.jasper.compiler.Validator$DirectiveVisitor.visit(Validator.java:106)
org.apache.jasper.compiler.Node$PageDirective.accept(Node.java:590)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2336)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2386)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2392)
org.apache.jasper.compiler.Node$Root.accept(Node.java:489)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2336)
org.apache.jasper.compiler.Validator.validate(Validator.java:1700)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:178)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:306)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.OlineBookStores.Filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
(引入包的部分)