php读取网页中表格数据库,网页中读取excel显示表格数据库-利用EXCEL表格为数据库制作查询网页...

做一个网页 网页上有一个功能是直接将excel表直接...

如果要了php输出excel格式文件就必须利用header content-type:application/vnd.ms-excel来实现。如下

$filename = name .'.xls';

header("content-type:application/vnd.ms-excel");

header("content-disposition:attachment;filename=$filename");

?>

再看一php输出excel实例

header("content-type:application/vnd.ms-excel");

header("content-disposition:filename=test.xls");

echo "a1tb1tc1tna2ta3ta4tn";//r t单元格,n新一行

?>

require_once("../../config/sys_config.php"); //配置文件

require_once("../../include/db_class.php");

header("content-type: text/html; charset=$page_code"); //页面编码

header("content-type:application/vnd.ms-excel");

header("content-disposition:attachment;filename=".mb_convert_encoding("客户报表","gbk",$page_code).".xls");

header("pragma:no-cache");

header("expires:0");

//$usersid = intval( $_get['uid'] ); //用户id

//输出内容如下：

// 输出表头

echo iconv("utf-8", "gb2312", "客户名称")."t";

echo iconv("utf-8", "gb2312", "电话")."t";

echo iconv("utf-8", "gb2312", "地址")."t";

echo iconv("utf-8", "gb2312", "添加日期")."t";

echo "n"; //换行

$sqlstr = "select * from clients where usersid=32 order by clientsid desc";

$rows = $db -> select($sqlstr);

$num = count($rows); //客户总数

for( $i = 0; $i < $num; $i )

{

echo iconv("utf-8", "gb2312",$rows[$i][clientsname])."t";

echo iconv("utf-8", "gb2312",$rows[$i][clientsphone])."t";

echo iconv("utf-8", "gb2312",$rows[$i][clientsaddress])."t";

echo iconv("utf-8", "gb2312",$rows[$i][clientstime])."t";

echo "n"; //换行

}

?>

利用EXCEL表格为数据库制作查询网页

如果你用的ORACLE数据库

1.打开PL/SQL dev

2.File—New——Report Window，在中间输入你的SELECT语句，得到你表或视图

3.在点击"Save as excel"或者"Save as HTML"就可以了！非常方便

希望能帮到你！

C#语言在网页上将excel中的内容导入到SQL数据库表中

Resource resource = new ClassPathResource("/applicationContext.xml");

BeanFactory factory = new XmlBeanFactory(resource);

SessionFactory sessionFactory = (SessionFactory) factory

.getBean("sessionFactory");

Session session = sessionFactory.openSession();

File excelfile = new File(ServletActionContext.getRequest()

.getRealPath("/upload")

"/" filepath);

Workbook book = null;

int rownum;

String mname = null;

try {

book = Workbook.getWorkbook(excelfile);

Sheet sheet = book.getSheet(0);// 工作簿是从0开始

for (rownum = 1; rownum < sheet.getRows(); rownum ) {

mname = sheet.getCell(0, rownum).getContents().trim();

String sql = "insert into media values (seq_media.nextval,?,?,?,?,?,?)";

Query query = session.createSQLQuery(sql);

query.setString(0, mname);

query.executeUpdate();

session.beginTransaction().commit();

}

} catch (Exception e) {

e.printStackTrace();

} finally {

book.close();

}

这个是我的代码 希望帮到你 采纳我 谢谢

如何把从数据库读出来的数据以excel格式显示到网页

Resource resource = new ClassPathResource("/applicationContext.xml");

BeanFactory factory = new XmlBeanFactory(resource);

SessionFactory sessionFactory = (SessionFactory) factory

.getBean("sessionFactory");

Session session = sessionFactory.openSession();

File excelfile = new File(ServletActionContext.getRequest()

.getRealPath("/upload")

"/" filepath);

Workbook book = null;

int rownum;

String mname = null;

try {

book = Workbook.getWorkbook(excelfile);

Sheet sheet = book.getSheet(0);// 工作簿是从0开始

for (rownum = 1; rownum < sheet.getRows(); rownum ) {

mname = sheet.getCell(0, rownum).getContents().trim();

String sql = "insert into media values (seq_media.nextval,?,?,?,?,?,?)";

Query query = session.createSQLQuery(sql);

query.setString(0, mname);

query.executeUpdate();

session.beginTransaction().commit();

}

} catch (Exception e) {

e.printStackTrace();

} finally {

book.close();

}

这个是我的代码 希望帮到你 采纳我 谢谢

你好！ 请教你个问题 java web程序如何将读取的exc...

就不上嘞太多。。。而且这东过一次就好嘞。。。

给你个思路。。。首先分解问题

1.java要读取excel，就需要用到 上传功能 怎么传搜度娘

2.java读取excel 我用的是jxl这个jar 怎么用搜度娘

3.插入数据库 insert就好 考虑性能和效率 建议用批量

4.显示在jsp select就好

关键的代码 网上都有 复制改就好 但是规则一定要自己想好