package com.solve.myjsp;
import java.sql.*;
public class connbean{
private String forname="sun.jdbc.odbc.JdbcOdbcDriver";
private String url="jdbc:odbc:solve";
String sql="select * from ZH_SZJZ";
public Statement stmt;
public Connection conn;
public ResultSet rs;
public void connbean(){
try{
Class.forName(forname);
conn= DriverManager.getConnection(url,"sa","da");
stmt=conn.createStatement();
}catch(ClassNotFoundException e){
}catch(SQLException e1){
}
}
public ResultSet getresult(){
try{rs=stmt.executeQuery(sql);}
catch(SQLException e){
}
return rs;
}
}
jsp里史<jsp:useBean id="conn1" class="com.solve.myjsp.connbean" />
<%ResultSet rs1=conn1.getresult();%>
import java.sql.*;
public class connbean{
private String forname="sun.jdbc.odbc.JdbcOdbcDriver";
private String url="jdbc:odbc:solve";
String sql="select * from ZH_SZJZ";
public Statement stmt;
public Connection conn;
public ResultSet rs;
public void connbean(){
try{
Class.forName(forname);
conn= DriverManager.getConnection(url,"sa","da");
stmt=conn.createStatement();
}catch(ClassNotFoundException e){
}catch(SQLException e1){
}
}
public ResultSet getresult(){
try{rs=stmt.executeQuery(sql);}
catch(SQLException e){
}
return rs;
}
}
jsp里史<jsp:useBean id="conn1" class="com.solve.myjsp.connbean" />
<%ResultSet rs1=conn1.getresult();%>
解决方案 »
- 在线等答案
- 缩放图片后,图片不完整问题,图片右边和下边一部分不显示.
- 如何知道session已经不可用了?
- tomcat服务器为什么Unable to compile class for JSP,环境变量配置有问题吗?
- 如何实现后台程序执行完毕之后,在前台jsp页面输出滚动文字或者提示框之类的提示
- 关于response.sendRedirect()传递多个参数的问题!
- 为什么我启动tomcat是窗口一晃而过,我没有自动开机加载他
- 今天非常不爽,散分
- 怎样用servlet实现数据库查询、修改功能??
- 100分求助:JSP试题求救
- 请问哪里有jsp论坛代码下载啊!
- 如何防止用户直接访问特定页面,而必须通过指定的Servlet来跳转???
去掉void
try{
Class.forName(forname);
conn= DriverManager.getConnection(url,"sa","da");
stmt=conn.createStatement();
}catch(ClassNotFoundException e){
}catch(SQLException e1){
}
}
jsp里试试<%java.sql.ResultSet rs1=conn1.getresult();%>