try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
java.sql.Connection conn;
conn = DriverManager.getConnection(
"jdbc:mysql://localhost/test?user=root");
ps=conn.createStatement();
rs=ps.executeQuery("select top 20 * from news");
while(rs.next()){
System.out.println(rs.getString(1));
}
}
catch(Exception e){
e.printStackTrace();
}
Class.forName("com.mysql.jdbc.Driver").newInstance();
java.sql.Connection conn;
conn = DriverManager.getConnection(
"jdbc:mysql://localhost/test?user=root");
ps=conn.createStatement();
rs=ps.executeQuery("select top 20 * from news");
while(rs.next()){
System.out.println(rs.getString(1));
}
}
catch(Exception e){
e.printStackTrace();
}
SELECT * FROM news order by date desc LIMIT 0, 20
偶也蹭点分~