java创建存储过程_jdbc如何创建存储过程

//创建存储过程,记住关闭对象

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class UseSQLDataBase3 {

Connection con;

Statement state;

ResultSet rs;

CallableStatement cs;//调用存储过程使用的接口

String url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test";

String user = "sa";

String password = "";

public void connectSQL(){

try {

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

} catch (ClassNotFoundException e) {

// TODO 自动生成 catch 块

e.printStackTrace();

}

try {

con = DriverManager.getConnection(url, user, password);