public static String url = null;public static String username = null;public static String password = null;public staticConnection conn;public staticStatement stmt;public staticResultSet rs;public static String fileName = null;public static List lists = newArrayList();public static String PATH = "/dbconfig.properties";private staticProperties properties;static{try{
InputStream is= DBlUtils.class.getResourceAsStream(PATH);
properties= newProperties();
properties.load(is);
url= properties.getProperty("jdbc.url");
username= properties.getProperty("jdbc.username");
password= properties.getProperty("jdbc.password");
fileName= properties.getProperty("fileName");
System.out.println("fileName:" +fileName);if (is != null)
is.close();
}catch(IOException e) {
e.printStackTrace();
}
}public voidcloseConnection(Connection conn) {if (conn != null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}/*** 查询mysql 数据库数据,并获得内容
*
*@paramsql*/
public static voidqueryDatas(String sql) {
try{
conn=DriverManager.getConnection(url, username, password);
conn.setAutoCommit(false);
stmt= conn.prepareStatement("load data local infile '' " + "into table loadtest fields terminated by ','");
StringBuilder sb= newStringBuilder();
InputStream is= newByteArrayInputStream(sb.toString().getBytes());
((com.mysql.jdbc.Statement) stmt).setLocalInfileInputStream(is);
ResultSet rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd=rs.getMetaData();int columnCount =rsmd.getColumnCount();//输出列名
for (int i = 1; i <= columnCount; i++) {
System.out.print(rsmd.getColumnName(i));
System.out.print("(" + rsmd.getColumnTypeName(i) + ")");
System.out.print(" | ");
}
System.out.println();//输出数据
while(rs.next()) {for (int i = 1; i <= columnCount; i++) {
System.out.print(rs.getString(i)+ " | ");
}
System.out.println();
}//conn.commit();
} catch(SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String sql = "select * from tablename";
queryDatas(sql);
}