数据的查询(数据库中日期存储是长整型,查询出来时时间转换日期格式s):
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class DBsearch {
public static void main(String[] args) throws SQLException{
String sql = " sql语句";
//时间字段名称
String str="timestamp";
DBconnection dbconn=new DBconnection();
Connection conn = DBconnection.getConn();
Statement st=dbconn.newStatement(conn);
ResultSet rs=dbconn.newResultSet(sql, st);
//取表中有多少个字段;
ResultSetMetaData rsmd=rs.getMetaData();
int coluNumb=rsmd.getColumnCount();
int i=1;
try {
while (rs.next()) {
System.out.println("第"+i+"条记录:");
for(int j=1;j<=coluNumb;j++)
{
//如果字段是时间类型转换成日期类型输出;
String str2=rsmd.getColumnName(j);
if(str.equals(str2))
{
System.out.print(" "+rsmd.getColumnName(j));
//changdate(rs.getLong(j));
changeDate dd=new changeDate();
dd.changedate1(rs.getLong(j));
}
else{
System.out.println(" "+rsmd.getColumnName(j)+" "+rs.getString(j));
}
}
i=i+1;
}
} catch (SQLException e) {
e.printStackTrace();
}
DBconnection.closeDB(rs,st, conn);
}
}