HTTP/2 302 server: nginx date: Sun, 03 Aug 2025 14:20:41 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100117134401 location: https://web.archive.org/web/20100117134401/https://answers.oreilly.com/topic/844-jdbc-sql-question server-timing: captures_list;dur=0.437584, exclusion.robots;dur=0.017792, exclusion.robots.policy;dur=0.008276, esindex;dur=0.008695, cdx.remote;dur=72.515314, LoadShardBlock;dur=756.805209, PetaboxLoader3.resolve;dur=520.469340, PetaboxLoader3.datanode;dur=110.453892 x-app-server: wwwb-app222 x-ts: 302 x-tr: 864 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app222; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Sun, 03 Aug 2025 14:20:42 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Sun, 17 Jan 2010 13:44:02 GMT x-archive-orig-server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8 x-archive-orig-x-powered-by: PHP/5.2.8 x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sat, 17-Jan-2009 13:44:01 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sat, 17-Jan-2009 13:44:01 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_modpids=deleted; expires=Sat, 17-Jan-2009 13:44:01 GMT; path=/; domain=.oreilly.com x-archive-orig-cache-control: ,no-cachemust-revalidate, max-age=0 x-archive-orig-expires: 0 x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Sun, 17 Jan 2010 13:44:01 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sun, 13 Dec 2009 02:56:34 GMT", ; rel="prev memento"; datetime="Tue, 05 Jan 2010 18:54:55 GMT", ; rel="memento"; datetime="Sun, 17 Jan 2010 13:44:01 GMT", ; rel="next memento"; datetime="Sat, 13 Feb 2010 08:59:44 GMT", ; rel="last memento"; datetime="Tue, 23 Jul 2013 14:28:33 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 51_13_20100117100644_crawl101-c/51_13_20100117134257_crawl100.arc.gz server-timing: captures_list;dur=0.502124, exclusion.robots;dur=0.019416, exclusion.robots.policy;dur=0.010520, esindex;dur=0.011053, cdx.remote;dur=25.431195, LoadShardBlock;dur=219.565909, PetaboxLoader3.resolve;dur=262.737496, PetaboxLoader3.datanode;dur=125.382379, load_resource;dur=451.772766 x-app-server: wwwb-app222 x-ts: 200 x-tr: 783 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip

Jump to content

• Home
  • Community
  • Events
  • Webcasts
  • Newsletters
• Books & Videos
  • New
  • Upcoming
  • Bestselling
  • Complete List
  • By Publisher
  • Rough Cuts
  • Ebooks
  • Videos
  • Order Info
• Answers
• News & Commentary
  • Most Recent
  • Audio
  • Video
  • Popular Tags
• Safari Books Online
  • Safari Home
  • Subscribe
  • Free Trial
  • Books
  • Videos
• Conferences
• Training
• School of Technology
  • Enroll
  • Your Career
  • Why OST
  • Courses & Certificates
  • Contact
  • Student Sign In

• My Account
• View Cart

O'Reilly Answers

Clever Hacks. Creative Ideas. Innovative Solutions.

• Trending Topics:
• linux
• iphone
• javascript
• java
• dns
• html
• web
• search
• SEO
• android
• More...

Share your knowledge

Welcome

---

• Sign In

• Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback
O'Reilly Answers Feed
@oreillyanswers

Related Questions

• Is there an easy way to get the results of a SQL query into a new table?

• H.264 video streaming/seeking via Java servlet

• streaming video online - j2ee

• GData Error: Intermittent “Invalid root element”

• xml processing

Related Posts

• Ten Tips for Android Application Development

• How to compute the distance between two points, given longitude and latitude

• How to Install Java in Ubuntu

• Reacting to Wave Conversations and Inserting Wave Gadgets with a Wave Robot

• How to Create a New Maven Project from the Command Line

Recommended for You

jdbc sql question?

VOTE

0

• 
• 

Please sign in or register to vote.

Voting for yourself is not allowed.

  Submitted by xiaofanku
Posted Dec 06 2009 04:54 PM

---

i has sql statement:

SELECT COUNT(*) FROM angle_dispatchemployee d INNER JOIN angle_comtract c ON d.deid=c.dispatchemployee_deid WHERE c.rstate=? AND d.state=? AND c.company_acid IN(?)

c.rstate=0(or 1) //Constant
d.state=0(or 1) //Constant
c.company_acid used method(getSpecialDispatch) argument: int[] clientIDs.i want know used java.sql.PreparedStatement.how write ps.set(3,???) //case clientIds array=[1,2,3,4]

i used mssql 2000 database.thanks answers!!

---

Tags:

• java
• jdbc
• sql

Share

Delicious

• 

Please sign in or register to comment.

Please sign in or register to post your answer.

0 Alternative Solutions | 1 Comment

• Date Posted
• Answers
• Comments

filter by: 

xiaofanku  : Dec 06 2009 05:29 PM

i used mssqlserver.jar :
Manifest-Version: 1.0
Created-By: 1.2.2 (Sun Microsystems Inc.)

• ← Previous Topic
• O'Reilly Answers Home
• Next Topic →

©2009, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.

About O'Reilly Academic Solutions Authors Contacts Customer Service Jobs Newsletters O'Reilly Labs Press Room Privacy Policy RSS Feeds Terms of Service User Groups Writing for O'Reilly

Content Archive Business Technology Computer Technology Google Microsoft Mobile Network Operating System Digital Photography Programming Software Web Web Design

More O'Reilly Sites O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone makezine.com craftzine.com hackszine.com perl.com xml.com Partner Sites InsideRIA java.net O'Reilly Insights on Forbes.com