为什么我的java程序能够联接数据库而jsp程序不能联接数据库? 你的oracle驱动装到tomcat的lib 目录下没有? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 java 文件如下:package all.foren.condb;import java.sql.DriverManager;import java.sql.SQLException;import com.inet.ora.*;public class conoracle{ private java.sql.Connection conOracle = null; public boolean iscon = false; public java.sql.Connection connectiondb(String host,String db,String uname,String pwd) { try { Class.forName("com.inet.ora.OraDriver").newInstance(); iscon = true; } catch (Exception e) { System.out.println("connection err!\n" + e); iscon = false; } try { String connDBParam = "jdbc:inetora:" + host + ":1521:" + db; conOracle = DriverManager.getConnection(connDBParam,uname,pwd); iscon = true; } catch (SQLException se) { System.out.println("connection err!" + se); iscon = false; } return conOracle; }}JSP如下:<%@ page import="java.sql.*"%><jsp:useBean id="cora" scope="page" class="all.foren.condb.conoracle"/><%java.sql.Connection connDB = null;java.sql.Statement stmt = null; try { connDB = cora.connectiondb("192.169.1.227","oracle8","tom","forentek"); stmt = connDB.createStatement(); } catch(Exception e) { out.println(cora.iscon); out.print(e); }ResultSet rs;%><HTML><HEAD><TITLE>POS</TITLE></HEAD><BODY><TABLE border="1" align="center"><TR> <Th>phone</Th> <Th>item</Th> <Th>temp</Th> <Th>status</Th> <Th>dtime</Th></TR><%rs = stmt.executeQuery("select * from system.tomtest1");while(rs.next()){%><TR> <TD><%=new String(rs.getString("a").getBytes("GBK"),"iso-8859-1")%></TD> <TD><%=rs.getString("b")%></TD></TR><%}rs.close();stmt.close();connDB.close();%></TABLE></BODY></HTML> 你把JAVA写成BEAN,然后在JSP中复用你那段代码不就行了?:) 驱动没放好同样是一段代码如果在JB中,JAVABEAN和JAVA代码如果都要运行成功驱动得分别放在工程属性和服务器属性中 RESTEasy的问题?请帮下忙 一个貌似是跳转问题。。。。。。 本人新手,求高手救命啊。。。。 web中实现打印,能否介绍几种方式? java的程序员请关注一下吧 急 ,解。。!!!!在线等待。。。。谢谢各位。。 在JSP页面提取数据库内容时在页面出现乱码? tomcat关闭延时问题,求各位大神指教 Jbuilder 7/8 和 Weblogic 7 整合问题 tomcat 项目war包移植weblogic 问题 关于BEANS引起的汉字问题,求救!!再次帖出 关于登录验证连接数据库的问题!
package all.foren.condb;import java.sql.DriverManager;
import java.sql.SQLException;
import com.inet.ora.*;public class conoracle
{
private java.sql.Connection conOracle = null;
public boolean iscon = false;
public java.sql.Connection connectiondb(String host,String db,String uname,String pwd)
{
try
{
Class.forName("com.inet.ora.OraDriver").newInstance();
iscon = true;
}
catch (Exception e)
{
System.out.println("connection err!\n" + e);
iscon = false;
}
try
{
String connDBParam = "jdbc:inetora:" + host + ":1521:" + db;
conOracle = DriverManager.getConnection(connDBParam,uname,pwd);
iscon = true;
}
catch (SQLException se)
{
System.out.println("connection err!" + se);
iscon = false;
}
return conOracle;
}}JSP如下:<%@ page import="java.sql.*"%>
<jsp:useBean id="cora" scope="page" class="all.foren.condb.conoracle"/>
<%
java.sql.Connection connDB = null;
java.sql.Statement stmt = null; try
{
connDB = cora.connectiondb("192.169.1.227","oracle8","tom","forentek");
stmt = connDB.createStatement();
}
catch(Exception e)
{
out.println(cora.iscon);
out.print(e);
}
ResultSet rs;
%><HTML>
<HEAD>
<TITLE>POS</TITLE>
</HEAD>
<BODY>
<TABLE border="1" align="center">
<TR>
<Th>phone</Th>
<Th>item</Th>
<Th>temp</Th>
<Th>status</Th>
<Th>dtime</Th>
</TR>
<%rs = stmt.executeQuery("select * from system.tomtest1");
while(rs.next())
{
%>
<TR>
<TD><%=new String(rs.getString("a").getBytes("GBK"),"iso-8859-1")%></TD>
<TD><%=rs.getString("b")%></TD>
</TR>
<%
}
rs.close();
stmt.close();
connDB.close();%>
</TABLE>
</BODY>
</HTML>
:)
同样是一段代码
如果在JB中,JAVABEAN和JAVA代码如果都要运行成功
驱动得分别放在工程属性和服务器属性中