import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class A{
public static void search1(){
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1/test", "root", "hy");
String sql=" select * from employee order by salary ";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
System.out.print(rs.getString("id")+"\t");
System.out.print(rs.getString("name")+"\t");
System.out.print(rs.getString("sex")+"\t");
System.out.print(rs.getInt("salary")+"\t");
System.out.println();
}
}
catch(SQLException se){
try{
conn.rollback();
}
catch(Exception ex){
ex.printStackTrace();
}
}
catch(Exception e){
try{
conn.rollback();
}
catch(Exception ex){
ex.printStackTrace();
}
}
finally{
try{
rs.close();
ps.close();
conn.close();
}
catch(Exception ex){
ex.printStackTrace();
}
}
}
}