UC知道jsp连接数据库的问题
来源：百度知道 编辑：UC知道 时间：2024/06/08 18:15:54
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<html>
<body>
<table border="2" align="center">
<%
String driver_type="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:testBean";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url,"","");
}
catch(ClassNotFoundException e){cannotConnect=1;}
catch(SQLException e){cannotConnect=2;}
Statement stmt=conn.createStatement();
String sql="select * from titles";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%=rs.getString("title_id")%></td>
<td><%=rs.getString("title")%></td>
<td><%=rs.getString("type")%&
<html>
<body>
<table border="2" align="center">
<%
String driver_type="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:testBean";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url,"","");
}
catch(ClassNotFoundException e){cannotConnect=1;}
catch(SQLException e){cannotConnect=2;}
Statement stmt=conn.createStatement();
String sql="select * from titles";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%=rs.getString("title_id")%></td>
<td><%=rs.getString("title")%></td>
<td><%=rs.getString("type")%&
<%system.out.println("....")%>出毛病是不是语句结束你没加分号?
将连接数据库的jar包拷到tomcat\webapps\lib目录下
odbc的驱动装了么？
你的System的S有没有大写？