SQLDML

//执行查询脚本并返回数据
package cn.iszt.test.services;


import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


import org.testng.annotations.Test;


import cn.iszt.test.model.SqlModel;




public class SqlDML extends JDBC {


PreparedStatement ps = null;
ResultSet rs = null;
private int A;


public  SqlModel sqlget(SqlModel sqlmodel) throws Exception {
 
 
// ps = conn.prepareStatement("select a.order_status from iszt_order_qq a where a.order_no='2016042800007304'"); 
ps = conn.prepareStatement(sqlmodel.getsql());
  
      rs = ps.executeQuery();
     
      while(rs.next()){
     A = rs.getInt("A");
     System.out.println("A的结果："+A);
     
      }
      sqlmodel.setA(A);


return sqlmodel; 








}
}