Class.forName("net.sourceforge.jtds.jdbc.Driver");
String dsn="jdbc:jtds:sqlserver://localhost:1433/SZ_MOTION;user=sa;password=sa";
Connection conn=DriverManager.getConnection(dsn);
CallableStatement callstmt;
conn.setAutoCommit(false);
callstmt = conn.prepareCall("{call MOTION_Works_Get(?)}");
callstmt.setString(1,"80");
ResultSet rsCall = callstmt.executeQuery();
while (rsCall.next())
{out.println(rsCall.getString("oid") + "--" + rsCall.getString("Title") + "---" + rsCall.getString("Content") + "<br/>");}
rsCall.close();
conn.commit();
callstmt.close();
conn.close();