UC知道怎么样子用jsp连接excel表格
来源：百度知道 编辑：UC知道 时间：2024/06/02 17:56:44
<%@ 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");
String url="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=F:/apache-tomcat-5.5/Tomcat 5.5/webapps/jdbc/Book1.xls";
out.print(url+"\n");
con =DriverManager.getConnection(url);
/* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Microsoft Excel Driver (*.xls)");*/
sql=con.createStatement();
rs=sql.executeQuery("select * from 品名");
out.print(rs.next());
out.print("<table border=10>");
out.print("<tr>");
out.print("<th width=100>&q
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=F:/apache-tomcat-5.5/Tomcat 5.5/webapps/jdbc/Book1.xls";
out.print(url+"\n");
con =DriverManager.getConnection(url);
/* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Microsoft Excel Driver (*.xls)");*/
sql=con.createStatement();
rs=sql.executeQuery("select * from 品名");
out.print(rs.next());
out.print("<table border=10>");
out.print("<tr>");
out.print("<th width=100>&q
呵呵，我咕噜寡闻了。
以前都是用程序操作excel的，今儿还看到用这样的方式。
加油。
select * from 品名
表格的名字不是book1吗，怎么变成品名了