存储过程与数据库

 package hqn;

/**
 * 存储过程与数据库
 * @author hqn
 *
 */
import java.sql.*;

public class Learn3 {
 Connection con;

 // PreparedStatement pst;
 CallableStatement cs;

 ResultSet rs;

 /**
  * 连接数据库
  *
  * @return Connection
  */
 public Connection getcon() {

  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   con = DriverManager
     .getConnection(
       "jdbc:microsoft:sqlServer://localhost:1433;Databasename=stu",
       "sa", "");

   if (con != null) {
    System.out.println("数据库连接成功");
   }
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   System.out.println("数据库连接失败");
   e.printStackTrace();
  }
  return con;
 }

 /**
  * 调用存储过程
  */
 public void pro(String name) {
  con = getcon();
  String sql = "create procedure search1(@name varchar(20)) as select * from person where name like @name";
  String s = "exec search1 ?";
  try {

   cs = con.prepareCall(sql);

   cs.execute();

   CallableStatement cs1 = con.prepareCall(s);
   cs1.setString(1, name);
   rs = cs1.executeQuery();
   while (rs.next()) {
    System.out.println(rs.getInt(1) + "  " + rs.getString(2));
   }

  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

 }

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  Learn3 l = new Learn3();
  l.pro("%l%");
 }

}