<%@ 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>
jsp 连接数据库 数据表格显示
最新推荐文章于 2020-01-15 18:56:28 发布