</p> public static void main(String[] args) throws ClassNotFoundException {
1 P! a) ]2 D( u; t8 w5 s$ i // TODO Auto-generated method stub6 \' [2 I+ m# R5 d2 N1 X$ F
Class.forName("net.sourceforge.jtds.jdbc.Driver");
; o8 g3 v9 r! I% k( v; D: J; e String url="jdbc:jtds:sqlserver://192.168.1.181:1433/JPPic;user=sa;password=1234";, V5 X: x5 l. @9 E$ z+ d1 W4 g
String sql = "{ call InsertUser(?,?)}";3 d9 N. B0 p+ `) O
Connection cn = null;
; f E, g8 l {+ n! l CallableStatement cmd = null;
+ E3 h2 X6 Y1 @9 n- \3 r; H try
* C1 F0 J8 p! \7 |7 z4 l k, M: a {
5 h2 c' d C7 C4 d5 H cn = DriverManager.getConnection(url);# F( D" f; i q, m& B
// PreparedStatement pre =cn.prepareStatement("Exec InsertUser ?,?");
+ ?6 g" w1 _" }+ t- |& a // pre.setString(1, "renyiyong");. a) F2 k+ K) J
// pre.setString(2, "liuguanzhang");
# H, U3 m9 q% g' M& S // pre.execute();! P+ v7 J8 \. r2 Q# O! d9 P
cmd = cn.prepareCall(sql);
7 } O9 U, H9 x& n cmd.setString(1, "zhongguo");8 x3 r- Q1 ]* [. L' H
cmd.setString(2, "meiguo");- s; f6 R4 n4 o9 I2 e9 {
cmd.execute();" @( e! W, S2 G! ^* S; g7 u$ b
}catch(Exception ex)
9 K: j! _) |/ Y; T8 |% v {+ N/ K+ b, ~0 n+ p. F! O
System.out.println(ex.getLocalizedMessage());
+ ]9 C8 b( o/ y% Z }finally z5 {6 f$ a+ L" Z) A
{; F( w7 o/ e. E- @3 ~0 S
try
/ G: ?# {% Y+ d. t {/ v7 q, G0 W, J7 s) j$ U
if(cn != null)% x6 q8 j9 b# J' j2 q
{& t3 Z, a, h4 f' _4 D9 q+ G
cn.close();. Q" Q( t! Y* j9 {) t
cn = null;
$ L( X$ q; L5 r- r6 l8 _- o }; j! F7 H/ y2 @8 g5 ~
}catch(Exception e){}* s2 E2 y8 j2 _ [8 b
}4 q, I% q" d3 j' H0 t
}% G1 V$ ~! H3 b& t% {( I
} |