beactiful_code

Echo_zy_if

于 2017-02-15 22:09:08 发布

阅读量209

点赞数

分类专栏： tomcat 文章标签： beactiful_code

本文链接：https://blog.csdn.net/qq_33291307/article/details/55224493

版权

tomcat 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

<%@ page contentType="text/html; charset=UTF-8" language="java" errorPage="" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
   <title>connDB</title>
</head>
<body>
    <% String sql="select ename,empno from emp";
        String DBDRIVER="oracle.jdbc.driver.OracleDriver";
        String DBURL="jdbc:oracle:thin:@localhost:1521:orcl";
        String DBUSER="scott";
        String DBPASS="root";
        Class.forName(DBDRIVER);
        Connection conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
        PreparedStatement pstmt=conn.prepareStatement(sql);
        ResultSet rs=pstmt.executeQuery();
        while(rs.next()){


    %>
           <tr>
              <td><%=rs.getString(1)%></td>
              <td><%=rs.getInt(2)%></td>
           </tr>
           <br>

    <%}%>

    <%conn.close();%>

</body>
</html>