一种Java调用Sybase存储过程实现取前N条数据的方法
一.在Sybase中创建存储过程如下:
public class JdbcSybaseProcedure { public static void main(String[] args) { Connection conn = null; CallableStatement cs = null; try { Class.forName("net.sourceforge.jtds.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:jtds:sybase://192.9.190.98:4100/inner_dbs", "emp", "empemp"); //下面的意思要调用那个存储过程,存储过程名字是getPageWiseData; cs = conn.prepareCall("{call getPageWiseData(?,?,?)}"); cs.setString(1, "select * from lps_mst order by pan"); cs.setInt(2, 1); cs.setInt(3, 5); //执行存储过程 ResultSet rs = cs.executeQuery(); while(rs.next()) { System.out.println(rs.getString("pan")); } } catch (Exception e) { e.printStackTrace(); } finally { try { cs.close(); } catch (SQLException e) { e.printStackTrace(); }finally { cs = null; } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); }finally { conn = null; } } }}?