jsp 连接数据库数据表格显示

来源：互联网发布：数控车g92管螺纹编程编辑：程序博客网时间：2024/05/21 08:56

<%@ page contentType="text/html" pageEncoding="utf-8"%><%@ page import="java.sql.*" %><!doctype html><head> <title>TEST</title></head><body><%!public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";public static final String DBURL = "jdbc:oracle:thin:@192.168.40.251:1521:orcl";public static final String DBUSER = "user";public static final String DBPASS = "password";%><%Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;%><%try{Class.forName(DBDRIVER);conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);String sql = "select usercode,username,relname from t_user";pstmt = conn.prepareStatement(sql);rs = pstmt.executeQuery();%><center><table border="1" width="80%"><tr><td>1</td><td>2</td><td>3</td><td>4</td></tr><%while(rs.next()){String usercode = rs.getString(1);String username = rs.getString(2);String relname = rs.getString(3);%><tr><td><%=usercode%></td><td><%=username%></td><td><%=relname%></td></tr><%}%></table></center><%}catch(Exception e){System.out.println(e);}finally{rs.close();pstmt.close();conn.close();}%></body></html>

0 0

jsp 连接数据库 数据表格显示

jsp 连接数据库数据表格显示