我的源代码:
<%@ page contentType="text/html;chareset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="sun.jdbc.odbc.JdbcOdbcDriver"%>
<html>
<body>
<%
Connection con=null;
Statement stat=null;
ResultSet res=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){ System.err.println( e );}
try{
con=DriverManager.getConnection("jdbc:odbc:exec","","");
stat=con.createStatement();
String sql="SELECT * FROM [Sheet1$] where subString(CardID,1,2)='M'";
res=stat.executeQuery(sql);
%>
<table>
<tr>
<td bgcolor="#CCCCFF">
<div align="center"><b>VisitNo</b></div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">CardID</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">name</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">type</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">dept</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">VsitTime</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">Passed</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">libplace</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">gateno</div>
</td>
</tr>
<% while(res.next()){ %>
<tr>
<td>
<div align="center"><%=res.getString(1)%></div>
</td>
<td>
<div align="center"><%=res.getString(2)%></div>
</td>
<td>
<div align="center"><%=res.getString(3)%></div>
</td>
<td>
<div align="center"><%=res.getString(4)%></div>
</td>
<td>
<div align="center"><%=res.getString(5)%></div>
</td>
<td>
<div align="center"><%=res.getString(6)%></div>
</td>
<td>
<div align="center"><%=res.getString(7)%></div>
</td>
<td>
<div align="center"><%=res.getString(8)%></div>
</td>
<td>
<div align="center"><%=res.getString(9)%></div>
</td>
</tr>
<%
}
res.close();
stat.close();
con.close();
}
catch(SQLException e1){}
%>
</table>
</body>
</html>
<%@ page contentType="text/html;chareset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="sun.jdbc.odbc.JdbcOdbcDriver"%>
<html>
<body>
<%
Connection con=null;
Statement stat=null;
ResultSet res=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){ System.err.println( e );}
try{
con=DriverManager.getConnection("jdbc:odbc:exec","","");
stat=con.createStatement();
String sql="SELECT * FROM [Sheet1$] where subString(CardID,1,2)='M'";
res=stat.executeQuery(sql);
%>
<table>
<tr>
<td bgcolor="#CCCCFF">
<div align="center"><b>VisitNo</b></div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">CardID</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">name</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">type</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">dept</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">VsitTime</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">Passed</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">libplace</div>
</td>
<td bgcolor="#CCCCFF">
<div align="center">gateno</div>
</td>
</tr>
<% while(res.next()){ %>
<tr>
<td>
<div align="center"><%=res.getString(1)%></div>
</td>
<td>
<div align="center"><%=res.getString(2)%></div>
</td>
<td>
<div align="center"><%=res.getString(3)%></div>
</td>
<td>
<div align="center"><%=res.getString(4)%></div>
</td>
<td>
<div align="center"><%=res.getString(5)%></div>
</td>
<td>
<div align="center"><%=res.getString(6)%></div>
</td>
<td>
<div align="center"><%=res.getString(7)%></div>
</td>
<td>
<div align="center"><%=res.getString(8)%></div>
</td>
<td>
<div align="center"><%=res.getString(9)%></div>
</td>
</tr>
<%
}
res.close();
stat.close();
con.close();
}
catch(SQLException e1){}
%>
</table>
</body>
</html>
怎么改呢?java.sql.SQLException: General error
java.lang.NullPointerException