jsp 连接access数据库问题
我连接access 数据库是通过odbc的系统dsn连接的数据远xs
连接代码:
<%
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
//String strdbFile = "D:\\Tomcat 5.0\\webapps\\ROOT\\db.mdb";
//String strConn = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};db=" + strdbFile+";DriverID=22;READONLY=TRUE";
try {
Class.forName(DBDriver);
}
catch(ClassNotFoundException e)
{
out.println("失败");
}
try{
Connection con = DriverManager.getConnection("jdbc:odbc:xs","","");
}
catch(SQLException e)
{
out.println("连接失败");
}
Statement stmt=con.createStatement();
%>
连接提示总是在提示con 好象是不可以用。An error occurred at line: 10 in the jsp file: /jdbc.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\jdbc_jsp.java:71: cannot resolve symbol
symbol : variable con
location: class org.apache.jsp.jdbc_jsp
Statement stmt=con.createStatement();
^
1 error
但是我把Statement stmt=con.createStatement(); 这句删除上面的连接也没有问题啊。!!
请问各位大侠我该怎么办!!!!?我研究了一个月了,哭!!!