RT
解决方案 »
- netbeans build时出问题了帮我看看
- 关于资源定位问题
- prototype_window模态窗口。
- Hibernate
- 编译MonitorDown出错 Need to specify class name in environment or system property,
- 配置好的struts几天后不能运行了,找不到action
- 如何生成这样的xml文件?
- 一个关于 :File "/WEB-INF/struts-logic.tld" not found的问题,请高手帮忙解答
- j2ee用什么开发工具比较好?
- pagehelper问题
- sessionFactory.getCurrentSession()为什么出这样的异常?
- struts2问题..请高手指教..<s:textfield>
package DAO;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;public class CSVTool {
private static Properties props;
public static void SetProps(String charset,String separator,String noHeader,String fileExtension )
{
props = new java.util.Properties();
if(!charset.isEmpty())
{
//System.out.println(charset);
props.put("charset",charset);
}
if(!separator.isEmpty())
{
// System.out.println("separator"+separator);
props.put("separator",separator);
}
if(!noHeader.isEmpty())
{
props.put("suppressHeaders",noHeader);
}
if(!fileExtension.isEmpty())
{
props.put("fileExtension",fileExtension);
}
}
public static Connection getConn(String dir)
{
Connection conn = null;
String driver ="org.relique.jdbc.csv.CsvDriver";
String url = "jdbc:relique:csv:"+dir; // jdbc:relique:csv:D:\\
try
{
Class.forName(driver);
conn = DriverManager.getConnection(url,props);
}
catch(Exception e)
{
e.printStackTrace();
}
return conn;
}
public static void closeConn(Connection conn)
{
try
{
if(conn !=null)
{
conn.close();
}
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void closeRS(ResultSet rs)
{
try {
if(rs !=null)
{
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void closeStatement(Statement state)
{
try {
if(state !=null)
{
state.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}