会python真的可以为所欲为0(回)
335天前
这里还有人吗1(回)
520天前这里还有人吗0(回)
520天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
745天前到处都是羊，不想上班0(回)
825天前
鸽子
0(回)
829天前import java.sql.*; |
public class Study |
{ |
private Connection con; |
public ResultSet re; |
private CallableStatement callsta; |
private String str; |
private String use = "sa"; |
private String pwd = "sa"; |
public Study() |
{ |
try |
{ |
//连接数据库驱动 |
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver"); |
String str = "jdbc:microsoft:sqlserver://localhost:1433;databasename=northwind"; |
con = DriverManager.getConnection (str, use, pwd); |
//设置存储过程参数 |
String st = "{call MyProc(?,?,?)}"; |
callsta = con.prepareCall (st); |
callsta.setInt (1, 10248); |
callsta.registerOutParameter (2, Types.VARCHAR); |
callsta.registerOutParameter (3, Types.INTEGER); |
//测试调用执行成功与否 |
System.out.println (callsta.execute() ); |
//循环输出调用存储过程的记录结果 |
if (callsta.execute() == true) |
{ |
re = callsta.getResultSet(); |
while (re.next() ) |
{ |
System.out.println (re.getInt (1) + " " + re.getString (2) + " " + re.getInt (3) ); |
} |
} |
else |
{ |
System.out.println ("dfas"); |
} |
} |
catch (Exception e) |
{ |
e.printStackTrace(); |
} |
} |
public static void main (String[] age) |
{ |
Study study = new Study(); |
} |
} |
