怎么用oracle调用create or replace PROCEDURE queryEmp1(eno in number,empname out VARCHAR2,empsal out NUMBER) as begin select ename,sal into empname,empsal from emp where empno=eno; end;

你可以使用以下语句在 Oracle 中创建或替换存储过程：

CREATE OR REPLACE PROCEDURE queryEmp1 (eno IN NUMBER, empname OUT VARCHAR2, empsal OUT NUMBER) AS
BEGIN
  SELECT ename, sal INTO empname, empsal FROM emp WHERE empno = eno;
END;

注意：在执行这个存储过程之前，你需要先创建表 `emp` 并在其中插入数据。

相关问题

idea写一个Servlet以实现增删改查 Emp表，连接oracle数据库

好的，这个问题很棒。为了实现增删改查Emp表的Servlet，需要进行以下步骤：

1. 首先，需要建立一个Emp类，包含Emp表中每个字段的属性，如id、name、age等。

2. 然后，需要在Servlet中建立Oracle数据库连接，在doGet或doPost方法中实现增删改查操作。

3. 对于查询操作，可以使用SELECT语句从Emp表中获取数据，并将结果集存储在List<Emp>对象中。

4. 对于插入操作，可以使用INSERT语句将新的Emp对象插入到Emp表中。

5. 对于更新操作，可以使用UPDATE语句更新Emp表中指定的字段。

6. 对于删除操作，可以使用DELETE语句从Emp表中删除指定的数据。

下面是一个简单的示例代码，演示如何实现增删改查Emp表的Servlet:

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/EmpServlet")
public class EmpServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    private Connection conn = null;
    private PreparedStatement pstmt = null;
    private ResultSet rs = null;

    private String url = "jdbc:oracle:thin:@localhost:1521:orcl";
    private String user = "scott";
    private String password = "tiger";

    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String method = request.getParameter("method");

        if ("add".equals(method)) {
            addEmp(request, response);
        } else if ("delete".equals(method)) {
            deleteEmp(request, response);
        } else if ("update".equals(method)) {
            updateEmp(request, response);
        } else if ("query".equals(method)) {
            queryEmp(request, response);
        }
    }

    private void addEmp(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String age = request.getParameter("age");
        String sql = "INSERT INTO Emp (id, name, age) VALUES (?, ?, ?)";

        try {
            conn = DriverManager.getConnection(url, user, password);
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, id);
            pstmt.setString(2, name);
            pstmt.setString(3, age);
            pstmt.executeUpdate();

            response.sendRedirect("index.jsp");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeAll();
        }
    }

    private void deleteEmp(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        String sql = "DELETE FROM Emp WHERE id = ?";

        try {
            conn = DriverManager.getConnection(url, user, password);
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, id);
            pstmt.executeUpdate();

            response.sendRedirect("index.jsp");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeAll();
        }
    }

    private void updateEmp(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String age = request.getParameter("age");
        String sql = "UPDATE Emp SET name = ?, age = ? WHERE id = ?";

        try {
            conn = DriverManager.getConnection(url, user, password);
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, name);
            pstmt.setString(2, age);
            pstmt.setString(3, id);
            pstmt.executeUpdate();

            response.sendRedirect("index.jsp");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeAll();
        }
    }

    private void queryEmp(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<Emp> list = new ArrayList<Emp>();
        String sql = "SELECT * FROM Emp";

        try {
            conn = DriverManager.getConnection(url, user, password);
            pstmt = conn.prepareStatement(sql);
            rs = pstmt.executeQuery();

            while (rs.next()) {
                Emp emp = new Emp();
                emp.setId(rs.getString("id"));
                emp.setName(rs.getString("name"));
                emp.setAge(rs.getString("age"));
                list.add(emp);
            }

            request.setAttribute("list", list);
            request.getRequestDispatcher("list.jsp").forward(request, response);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeAll();
        }
    }

    private void closeAll() {
        try {
            if (rs != null) {
                rs.close();
            }
            if (pstmt != null) {
                pstmt.close();
            }
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

以上代码可能需要根据你的实际情况作一些修改，例如数据库连接信息、SQL语句等。

idea写一个Servlet以实现增删改查 Emp表，连接数据库

好的，以下是一个示例代码，可以实现基本的增删改查功能：

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/EmpServlet")
public class EmpServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    private Connection conn;
    private PreparedStatement pstmt;
    private ResultSet rs;

    public void init() {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/test";
        String user = "root";
        String password = "123456";

        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(url, user, password);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        String action = request.getParameter("action");

        if (action.equals("addEmp")) {
            String empno = request.getParameter("empno");
            String ename = request.getParameter("ename");
            String job = request.getParameter("job");
            String mgr = request.getParameter("mgr");
            String hiredate = request.getParameter("hiredate");
            String sal = request.getParameter("sal");
            String comm = request.getParameter("comm");
            String deptno = request.getParameter("deptno");

            String sql = "INSERT INTO emp (empno, ename, job, mgr, hiredate, sal, comm, deptno) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

            try {
                pstmt = conn.prepareStatement(sql);
                pstmt.setString(1, empno);
                pstmt.setString(2, ename);
                pstmt.setString(3, job);
                pstmt.setString(4, mgr);
                pstmt.setString(5, hiredate);
                pstmt.setString(6, sal);
                pstmt.setString(7, comm);
                pstmt.setString(8, deptno);
                pstmt.executeUpdate();
                out.println("添加成功！");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else if (action.equals("deleteEmp")) {
            String empno = request.getParameter("empno");

            String sql = "DELETE FROM emp WHERE empno = ?";

            try {
                pstmt = conn.prepareStatement(sql);
                pstmt.setString(1, empno);
                pstmt.executeUpdate();
                out.println("删除成功！");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else if (action.equals("updateEmp")) {
            String empno = request.getParameter("empno");
            String ename = request.getParameter("ename");
            String job = request.getParameter("job");
            String mgr = request.getParameter("mgr");
            String hiredate = request.getParameter("hiredate");
            String sal = request.getParameter("sal");
            String comm = request.getParameter("comm");
            String deptno = request.getParameter("deptno");

            String sql = "UPDATE emp SET ename = ?, job = ?, mgr = ?, hiredate = ?, sal = ?, comm = ?, deptno = ? WHERE empno = ?";

            try {
                pstmt = conn.prepareStatement(sql);
                pstmt.setString(1, ename);
                pstmt.setString(2, job);
                pstmt.setString(3, mgr);
                pstmt.setString(4, hiredate);
                pstmt.setString(5, sal);
                pstmt.setString(6, comm);
                pstmt.setString(7, deptno);
                pstmt.setString(8, empno);
                pstmt.executeUpdate();
                out.println("修改成功！");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else if (action.equals("queryEmp")) {
            String empno = request.getParameter("empno");
            String ename = request.getParameter("ename");

            String sql = "SELECT * FROM emp WHERE 1 = 1";

            if (empno != null && !empno.trim().equals("")) {
                sql += " AND empno = '" + empno + "'";
            }

            if (ename != null && !ename.trim().equals("")) {
                sql += " AND ename = '" + ename + "'";
            }

            try {
                pstmt = conn.prepareStatement(sql);
                rs = pstmt.executeQuery();

                while (rs.next()) {
                    out.println("empno: " + rs.getString("empno") + "<br>");
                    out.println("ename: " + rs.getString("ename") + "<br>");
                    out.println("job: " + rs.getString("job") + "<br>");
                    out.println("mgr: " + rs.getString("mgr") + "<br>");
                    out.println("hiredate: " + rs.getString("hiredate") + "<br>");
                    out.println("sal: " + rs.getString("sal") + "<br>");
                    out.println("comm: " + rs.getString("comm") + "<br>");
                    out.println("deptno: " + rs.getString("deptno") + "<br><br>");
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void destroy() {
        try {
            if (rs != null) {
                rs.close();
            }

            if (pstmt != null) {
                pstmt.close();
            }

            if (conn != null) {
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

在这个例子中，我们使用了MySQL数据库，数据库名为test，用户名为root，密码为123456。你可以根据自己的实际情况修改这些参数。在init()方法中，我们使用了JDBC驱动来连接数据库。

在doPost()方法中，我们首先获取前端传来的action参数，根据参数的不同执行不同的操作。如果action为addEmp，表示进行插入操作，我们从request中获取表单数据，使用PreparedStatement对数据库进行操作。如果action为deleteEmp，表示进行删除操作，我们从request中获取要删除的empno，对数据库进行操作。如果action为updateEmp，表示进行更新操作，我们从request中获取要更新的empno以及表单数据，对数据库进行操作。如果action为queryEmp，表示进行查询操作，我们从request中获取要查询的empno和ename，根据不同的情况构造不同的SQL语句，使用PreparedStatement查询数据库，并将结果输出到前端。

最后，我们在destroy()方法中关闭ResultSet、PreparedStatement和Connection对象，释放资源。