jsp调用MYSQL5.0存储过程问题

Question

用MYSQL写了一个存储过程,怎么用JSP中调用它.谁能给个简单的例子给我看一下吗?谢谢大家

Answer 1

package testcallable;
import java.sql.*;
import java.io.*;public class CallableDemo
{
  final static String URL = "jdbc:oracle:thin:@localhost:1521:learn"; //表示Oracle的路径
  final static String USERNAME = "user"; //存储用户名
  final static String PASSWORD = "user"; //存储密码        public static void main(String[] args)
        {
                try
                {
                        //定义连接及CallableStatement对象
                        //CallableStatement对象主要用来执行存储过程
                        Connection con;
                        CallableStatement cs;
                        //直连方式
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                        con = DriverManager.getConnection(URL,USERNAME,PASSWORD);
                        cs = con.prepareCall("{call PRCO1(?,?)}");
                        BufferedReader keyIn=new BufferedReader(new InputStreamReader(System.in));
                        System.out.println("员工编号：");
                        String eno=keyIn.readLine();
                        int empno = Integer.parseInt(eno);
                        cs.setInt(1,empno);
                        cs.registerOutParameter(2,java.sql.Types.DOUBLE);
                        cs.execute();
                        System.out.println("编号为" + empno + "的员工工资为" +cs.getDouble(2));
                }
                catch(Exception e)
                {
                        System.out.println(e.getMessage());
                }
        }
}
给了一个oracle的，自己照着做吧