<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:mysql","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM Course");
%>
<Table Border bgcolor="#CCFFFF">
<TR>
<TH width=100>课程序号 </font>
<TH width=100>课程名 </font>
<TH width=50>学分</font></TR>
<%
while(rs.next()){
%>
<TR>
<TD ><div align="center"><%=rs.getString(1)%></div></TD>
<TD ><div align="center"><%=rs.getString(2)%></div></TD>
<TD ><div align="center"><%=rs.getInt(3)%></div></TD>
</TR>
<% }%>
</Table>
<% con.close();
}
catch(SQLException e1) {}
%>
</BODY>
</HTML>
数据库链接什么的都已经弄好了,可是在浏览器输入地址的时候却是空白?各位大侠,救救小弟啊
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:mysql","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM Course");
%>
<Table Border bgcolor="#CCFFFF">
<TR>
<TH width=100>课程序号 </font>
<TH width=100>课程名 </font>
<TH width=50>学分</font></TR>
<%
while(rs.next()){
%>
<TR>
<TD ><div align="center"><%=rs.getString(1)%></div></TD>
<TD ><div align="center"><%=rs.getString(2)%></div></TD>
<TD ><div align="center"><%=rs.getInt(3)%></div></TD>
</TR>
<% }%>
</Table>
<% con.close();
}
catch(SQLException e1) {}
%>
</BODY>
</HTML>
数据库链接什么的都已经弄好了,可是在浏览器输入地址的时候却是空白?各位大侠,救救小弟啊
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:mysql","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM Course");
%>
<Table Border bgcolor="#CCFFFF">
<TR>
<TH width=100>课程序号 </font>
<TH width=100>课程名 </font>
<TH width=50>学分 </font> </TR>
<%
while(rs.next()){
%>
<TR>
<TD > <div align="center"> <%=rs.getString(1)%> </div> </TD>
<TD > <div align="center"> <%=rs.getString(2)%> </div> </TD>
<TD > <div align="center"> <%=rs.getInt(3)%> </div> </TD>
</TR>
<% }%>
</Table>
<% con.close();
}
catch(SQLException e1) { e1.printStackTrace();}
%>
</BODY>
</HTML>
<TH width=100>课程序号 </font>
<TH width=100>课程名 </font>
<TH width=50>学分 </font> </TR>
都不能显示?
课程序号
课程名
学分
我想请大家可以自己建个表,看看结果
org.apache.jasper.JasperException: An exception occurred processing JSP page /chap3-1.jsp at line 1411: }
12: catch(ClassNotFoundException e){}
13:
14: con=DriverManager.getConnection("jdbc:odbc:mysql","sa","");
15: sql=con.createStatement();
16: rs=sql.executeQuery("SELECT * FROM Course");
17: %>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.chap3_002d1_jsp._jspService(chap3_002d1_jsp.java:109)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.chap3_002d1_jsp._jspService(chap3_002d1_jsp.java:67)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)难道我的数据源不对??我懵了
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序找不到驱动,嘎嘎
<TH width=100>课程名 </font>
<TH width=50>学分 </font>
怎么这样写?
是不是你配数据源时没有选数据库