以下简单地给出了使用的范例,请参考: <%@ page contentType="text/html" import="operate_db.*,java.sql.*" %>
<jsp:useBean id="querybean" scope="request"
class="operate_db.QueryBean" />
<%
String prm1,prm2,prm3;
ResultSet rst=null;
prm1 = ...;
prm2 = ...;
prm3 = ...;
querybean.setConnection("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:数据源名","sa","");
try{ String[] param = {prm1,prm2,prm3};
/*设置select语句*/
querybean.setQuerystatement("Select * from table where field1
= ? and field2=? and field3=?");
querybean.setParam(param);
rst=querybean.getResult();
}catch(Exception e){System.out.println(e); }
while (rst.next()){ %><%=rst.getString(1)%> <%}%>
<jsp:useBean id="querybean" scope="request"
class="operate_db.QueryBean" />
<%
String prm1,prm2,prm3;
ResultSet rst=null;
prm1 = ...;
prm2 = ...;
prm3 = ...;
querybean.setConnection("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:数据源名","sa","");
try{ String[] param = {prm1,prm2,prm3};
/*设置select语句*/
querybean.setQuerystatement("Select * from table where field1
= ? and field2=? and field3=?");
querybean.setParam(param);
rst=querybean.getResult();
}catch(Exception e){System.out.println(e); }
while (rst.next()){ %><%=rst.getString(1)%> <%}%>
解决方案 »
- jsp 中的JavaScript怎么不运行呢????
- 一个校园社交论坛的问题~~
- 用servlet如何实现对分割文件后重新合并
- request.getSession()总是获得唯一对象吗?
- Axis2客户端链接超时、并发的请求控制如何处理?
- MyEclipse 怎么样 run as 运行tomcat 不显示WEB 网页画面!
- 我找到两本好书,大家快来下啊
- 求助各位大神 S2SH实现文件上传下载时遇到的问题
- freemarker的数据表现
- 关于中文文件的下载问题......
- 不知道该用什么服务器?***********
- 怎样配置poolman连接池,运行环境windows 2000server,mysql,resin;测试时报错!在线等!!!
在bean里写:
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
String url = "jdbc:db2:test" ;
String username = "db2admin" ;
String password = "111" ;
Connection con = DriverManager.getConnection(url ,username ,password );
把数据连接和sql的执行封装在里面,
如果我在其他bean中要用到连接和执行sql语句,
怎样调用里面的方法呢(在bean中调用)。//sql_data.javapackage DBBeans;
import java.sql.*;
public class sql_data
{ String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://psupport:1433;DatabaseName=Develop";
String user="sa";
String password="";
Connection conn=null;
ResultSet rs=null;
ResultSet rs1=null; public sql_data()
{
try
{
//Class.forName(sDBDriver).newInstance();
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("sql_data():" + e.getMessage());
} }
public void executeUpdate(String sql)
{
try
{
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeUpdate:" + ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
ResultSet rs=null;
try
{
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeQuery:" + ex.getMessage());
}
return rs;
} public void executeQuery1(String sql)
{
executeUpdate(sql);
}}