import java.sql.Connection
import java.sql.DriverManager
import java.sql.SQLException
public class Utilities {
public static Connection getConnection() {
Connection con = null
try {
Class.forNam("oracle.jdbc.driver.OracleDriver")
con = DriverManager.getConnection ("jdbc:mysql://localhost:8080/auction", "scott", "tiger")//这里是数据库连接主机的地址数据库端口库名，帐户密码
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace()
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace()
}
return con
}
public static void main(String[] args) {
// TODO Auto-generated method stub
}
}
然后通过这个连接来提取数据库中的数据 实现业务流程
package auction.dao.impl
import java.sql.Connection
import java.sql.PreparedStatement
import java.sql.ResultSet
import java.sql.SQLException
import java.util.ArrayList
import java.util.List
import auction.dao.AuctionUserDao
import auction.exception.AuctionException
import auction.model.AuctionUser
import auctionUtilities.Utilities
public class AuctionUserDaoJDBCImpl {
public void delete(AuctionUser user) {
Connection con = null
PreparedStatement ps = null
try {
con = Utilities.getConnection()
con.setAutoCommit(false)
ps = con.prepareStatement("delete from auction_user where user_id=?")
ps.setInt(1, user.getId())
ps.execute()
con.commit()
} catch (Exception e) {
e.printStackTrace()
try {
con.rollback()
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace()
}
} finally {
if(ps != null) {
try {
ps.close()
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace()
}
}
if(con != null) {
try {
con.close()
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace()
}
}
}
}
}
如果需要将数据库中的文件导入到电子表格，我也没做过，我引用一下别人的东西。如下
创建Excel 文档
示例1将演示如何利用Jakarta POI API 创建Excel 文档。
示例1程序如下：
import org.apache.poi.hssf.usermodel.HSSFWorkbook
import org.apache.poi.hssf.usermodel.HSSFSheet
import org.apache.poi.hssf.usermodel.HSSFRow
import org.apache.poi.hssf.usermodel.HSSFCell
import java.io.FileOutputStream
public class CreateXL {
/** Excel 文件要存放的位置，假定在D盘JTest目录下*/
public static String outputFile="D:/JTest/ gongye.xls"
public static void main(String argv[]){
try{
// 创建新的Excel 工作簿
HSSFWorkbook workbook = new HSSFWorkbook()
// 在Excel工作簿中建一工作表，其名为缺省值
// 如要新建一名为"效益指标"的工作表，其语句为：
// HSSFSheet sheet = workbook.createSheet("效益指标")
HSSFSheet sheet = workbook.createSheet()
// 在索引0的位置创建行（最顶端的行）
HSSFRow row = sheet.createRow((short)0)
//在索引0的位置创建单元格（左上端）
HSSFCell cell = row.createCell((short) 0)
// 定义单元格为字符串类型
cell.setCellType(HSSFCell.CELL_TYPE_STRING)
// 在单元格中输入一些内容
cell.setCellValue("增加值")
// 新建一输出文件流
FileOutputStream fOut = new FileOutputStream(outputFile)
// 把相应的Excel 工作簿存盘
workbook.write(fOut)
fOut.flush()
// *** 作结束，关闭文件
fOut.close()
System.out.println("文件生成...")
}catch(Exception e) {
System.out.println("已运行 xlCreate() : " + e )
}
}
}
读取Excel文档中的数据
示例2将演示如何读取Excel文档中的数据。假定在D盘JTest目录下有一个文件名为gongye.xls的Excel文件。
示例2程序如下：
import org.apache.poi.hssf.usermodel.HSSFWorkbook
import org.apache.poi.hssf.usermodel.HSSFSheet
import org.apache.poi.hssf.usermodel.HSSFRow
import org.apache.poi.hssf.usermodel.HSSFCell
import java.io.FileInputStream
public class ReadXL {
/** Excel文件的存放位置。注意是正斜线*/
public static String fileToBeRead="D:/JTest/ gongye.xls"
public static void main(String argv[]){
try{
// 创建对Excel工作簿文件的引用
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead))
// 创建对工作表的引用。
// 本例是按名引用（让我们假定那张表有着缺省名"Sheet1"）
HSSFSheet sheet = workbook.getSheet("Sheet1")
// 也可用getSheetAt(int index)按索引引用，
// 在Excel文档中，第一张工作表的缺省索引是0，
// 其语句为：HSSFSheet sheet = workbook.getSheetAt(0)
// 读取左上端单元
HSSFRow row = sheet.getRow(0)
HSSFCell cell = row.getCell((short)0)
// 输出单元内容，cell.getStringCellValue()就是取所在单元的值
System.out.println("左上端单元是： " + cell.getStringCellValue())
}catch(Exception e) {
System.out.println("已运行xlRead() : " + e )
}
}
}
设置单元格格式
在这里，我们将只介绍一些和格式设置有关的语句，我们假定workbook就是对一个工作簿的引用。在Java中，第一步要做的就是创建和设置字体和单元格的格式，然后再应用这些格式：
1、创建字体，设置其为红色、粗体：
HSSFFont font = workbook.createFont()
font.setColor(HSSFFont.COLOR_RED)
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD)
2、创建格式
HSSFCellStyle cellStyle= workbook.createCellStyle()
cellStyle.setFont(font)
3、应用格式
HSSFCell cell = row.createCell((short) 0)
cell.setCellStyle(cellStyle)
cell.setCellType(HSSFCell.CELL_TYPE_STRING)
cell.setCellValue("标题 ")
台风的编号和名称直接在源码中有，但时间和地理位置我只能跟踪到function totf(tfbh){
location.href( "Typhoon.aspx?id="+tfbh)
}
数据需要从aspx中拿到的，应该是存放到数据库的，页面上是拿不到的
我认为可以通过循环模拟发送请求Typhoon.aspx?id="+XXX，然后通过解析response包的方式可以获得详细的信息
下面一个页面是讲模拟发送请求的
http://tidus2005.javaeye.com/blog/195544
希望对你有帮助
我写了一段获得一组数据的代码
//get Typhoon content by param
public static String getTyphoon(String param) {
URL url = null
try {
url = new URL(param)
} catch (MalformedURLException e) {
e.printStackTrace()
}
HttpURLConnection connection = null
InputStream is = null
try {
connection = (HttpURLConnection) url.openConnection()
is = connection.getInputStream()
} catch (IOException e) {
e.printStackTrace()
}
BufferedInputStream bis = new BufferedInputStream(is)
int len = 0
byte[] buf_all = new byte[0]
try {
while (true) {
byte[] buf1 = new byte[4096]
byte[] buf2 = buf_all
len = bis.read(buf1)
if(len <= 0){
break
}
buf_all = new byte[len+buf2.length]
System.arraycopy(buf2, 0, buf_all, 0, buf2.length)
System.arraycopy(buf1, 0, buf_all, buf2.length, len)
}
} catch (IOException e) {
e.printStackTrace()
}
String content = null
try {
content = new String(buf_all, "utf-8")
} catch (UnsupportedEncodingException e) {
e.printStackTrace()
}
int startIndex = content.indexOf("var ary0=")+9
content = content.substring(startIndex)
int endIndex = content.indexOf("var aryyb0=")
content = content.substring(0, endIndex)
return content
}
得到的结果是这样的：
[['200906','2009-07-19 20:00:00','23.8','109.6','','15','','','260','','','54440','','莫拉菲','Molave','7'],
['200906','2009-07-19 15:00:00','23.5','111','993','15','25','西北西','260','','','54439','','莫拉菲','Molave','7'],
['200906','2009-07-19 14:00:00','23.3','111.2','','18','','','260','','','54438','','莫拉菲','Molave','8'],
['200906','2009-07-19 13:00:00','23.3','111.5','990','18','25','西北西','260','','','54437','','莫拉菲','Molave','8'],
['200906','2009-07-19 12:00:00','23.2','111.8','990','18','25','西北西','260','','','54436','','莫拉菲','Molave','8'],
['200906','2009-07-19 11:00:00','23.2','112.1','987','18','25','西北西','260','','','54435','','莫拉菲','Molave','8'],
['200906','2009-07-19 10:00:00','23.2','112.4','987','18','25','西北西','260','','','54434','','莫拉菲','Molave','8'],
['200906','2009-07-19 09:00:00','23','112.6','987','20','25','西北西','260','','','54433','','莫拉菲','Molave','8'],
['200906','2009-07-19 08:00:00','22.9','112.9','987','20','','','260','','','54432','','莫拉菲','Molave','8'],
['200906','2009-07-19 07:00:00','22.9','113.2','985','23','25','西北西','260','','','54431','','莫拉菲','Molave','9'],
['200906','2009-07-19 06:00:00','22.8','113.4','982','25','25','西北西','260','','','54430','','莫拉菲','Molave','10'],
['200906','2009-07-19 05:00:00','22.7','113.7','980','28','25','西北西','260','','','54429','','莫拉菲','Molave','10'],
['200906','2009-07-19 04:00:00','22.7','114','975','30','25','西北西','260','','','54428','','莫拉菲','Molave','11'],
['200906','2009-07-19 03:00:00','22.7','114.2','975','33','25','西北偏西','260','80','','54426','','莫拉菲','Molave','12'],
['200906','2009-07-19 02:00:00','22.6','114.5','','35','','','260','80','','54425','','莫拉菲','Molave','12'],
['200906','2009-07-19 01:00:00','22.5','114.5','970','35','28','西北西','260','80','','54424','','莫拉菲','Molave','12'],
['200906','2009-07-19 00:00:00','22.5','114.8','965','38','28','西北西','260','80','','54423','','莫拉菲','Molave','13'],
['200906','2009-07-18 23:00:00','22.4','115.1','','38','','','260','80','','54422','','莫拉菲','Molave','13'],
['200906','2009-07-18 22:00:00','22.3','115.5','965','38','25','西北西','260','80','','54421','','莫拉菲','Molave','13'],
['200906','2009-07-18 21:00:00','22.2','115.7','965','38','25','西北西','260','80','','54420','','莫拉菲','Molave','13'],
['200906','2009-07-18 20:00:00','22.2','116','','35','','','260','80','','54419','','莫拉菲','Molave','12'],
['200906','2009-07-18 19:00:00','22.2','116.2','970','35','25','西北偏西','260','80','','54418','','莫拉菲','Molave','12'],
['200906','2009-07-18 18:00:00','22.1','116.5','970','35','25','西北偏西','260','80','','54417','','莫拉菲','Molave','12'],
['200906','2009-07-18 17:00:00','22','116.7','970','35','25','西北西','260','80','','54416','','莫拉菲','Molave','12'],
['200906','2009-07-18 16:00:00','21.9','116.9','970','35','25','西北偏西','260','80','','54415','','莫拉菲','Molave','12'],
['200906','2009-07-18 15:00:00','21.8','117.1','970','35','25','西北偏西','260','80','','54414','','莫拉菲','Molave','12'],
['200906','2009-07-18 14:00:00','21.7','117.2','970','35','25','西北西','260','80','','54413','','莫拉菲','Molave','12'],
['200906','2009-07-18 13:00:00','21.7','117.4','970','35','25','西北西','260','80','','54412','','莫拉菲','Molave','12'],
['200906','2009-07-18 12:00:00','21.6','117.5','975','33','25','西北西','260','80','','54411','','莫拉菲','Molave','12'],
['200906','2009-07-18 11:00:00','21.6','117.7','975','33','25','西北西','260','80','','54410','','莫拉菲','Molave','12'],
['200906','2009-07-18 10:00:00','21.6','117.9','975','33','25','西北西','260','80','','54409','','莫拉菲','Molave','12'],
['200906','2009-07-18 09:00:00','21.5','118.2','975','33','25','西北西','260','80','','54408','','莫拉菲','Molave','12'],
['200906','2009-07-18 08:00:00','21.4','118.3','975','33','25','西北偏西','260','80','','54407','','莫拉菲','Molave','12'],
['200906','2009-07-18 07:00:00','21.4','118.5','975','33','25','西北西','260','80','','54406','','莫拉菲','Molave','12'],
['200906','2009-07-18 06:00:00','21.3','118.7','975','33','25','西北西','260','80','','54405','','莫拉菲','Molave','12'],
['200906','2009-07-18 05:00:00','21.2','119','975','33','','','260','60','','54404','','莫拉菲','Molave','12'],
['200906','2009-07-18 04:00:00','21.2','119.2','978','30','25','西北西','260','60','','54403','','莫拉菲','Molave','11'],
['200906','2009-07-18 03:00:00','21.1','119.4','978','30','25','西北偏西','260','60','','54402','','莫拉菲','Molave','11'],
['200906','2009-07-18 02:00:00','21','119.6','978','30','','','260','60','','54401','','莫拉菲','Molave','11'],
['200906','2009-07-18 01:00:00','21','120.1','978','30','25','西北偏西','260','60','','54400','','莫拉菲','Molave','11'],
['200906','2009-07-18 00:00:00','20.9','120.3','978','30','25','西北偏西','260','60','','54399','','莫拉菲','Molave','11'],
['200906','2009-07-17 23:00:00','20.8','120.5','978','30','20','西北偏西','260','60','','54398','','莫拉菲','Molave','11'],
['200906','2009-07-17 22:00:00','20.7','121','978','30','20','西北偏西','260','60','','54397','','莫拉菲','Molave','11'],
['200906','2009-07-17 21:00:00','20.7','121.2','978','30','20','西北偏西','260','60','','54396','','莫拉菲','Molave','11'],
['200906','2009-07-17 20:00:00','20.6','121.5','978','30','20','西北偏西','260','60','','54395','','莫拉菲','Molave','11'],
['200906','2009-07-17 19:00:00','20.4','121.8','980','28','20','西北西','260','60','','54394','','莫拉菲','Molave','10'],
['200906','2009-07-17 18:00:00','20.3','121.9','980','28','20','西北偏西','260','60','','54393','','莫拉菲','Molave','10'],
['200906','2009-07-17 17:00:00','20.2','122.1','980','28','20','西北偏西','200','50','','54392','','莫拉菲','Molave','10'],
['200906','2009-07-17 14:00:00','19.5','122.7','','25','','','200','50','','54391','','莫拉菲','Molave','10'],
['200906','2009-07-17 11:00:00','18.9','123.3','985','25','15','西北','200','50','','54390','','莫拉菲','Molave','10'],
['200906','2009-07-17 08:00:00','18.6','123.6','994','20','','','100','','','54389','','莫拉菲','Molave','8'],
['200906','2009-07-17 05:00:00','18.4','123.9','996','18','15','西北','100','','','54388','','莫拉菲','Molave','8'],
['200906','2009-07-17 02:00:00','17.9','124.1','996','18','15','西北','50','','','54387','','莫拉菲','Molave','8'],
['200906','2009-07-16 23:00:00','17.6','124.6','996','18','15','西北','','','','54386','','莫拉菲','Molave','8'],
['200906','2009-07-16 20:00:00','17.4','124.7','996','18','','','','','','54385','','莫拉菲','Molave','8']]
再下去字符串的拆分实在是太复杂了，不想写了
使用时只要参数为http://www.wztf121.com/Typhoon.aspx?id=
id后是台风的代码号，写一个循环就可以了
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）