<%
//ArrayList list = new ArrayList();
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection(
"jdbc:sqlserver:/.......);
CallableStatement cs = con.prepareCall("call dbo.[HJ4-Worktime](?,?,?)");
cs.setString(1, "C0");
cs.setString(2, "20130806");
cs.setString(3, "20130809");
ResultSet rs = cs.executeQuery();
if(rs.next())
{
%>
<%rs.getString("NUMBER"); %>
<%
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
%>