jsp实现emp表数据

来源：互联网发布：最有名的十大网络主播编辑：程序博客网时间：2024/05/22 11:42

<%@ page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>emp表数据</title>
</head>
<body>
<%!
private static String driver= "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://127.0.0.1:3306/mydatabase";
private static String username = "root";
private static String passwords="123456";
%>
<%
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
%>
<%
try
{
Class.forName(driver);
conn=DriverManager.getConnection(url,username,passwords);
String sql="SELECT empno,ename,job,sal,hiredate FROM emp";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
%>
<center>
<table border="1" width="80%">
<tr>
<td>雇员编号</td>
<td>雇员姓名</td>
<td>雇员工作</td>
<td>雇员工资</td>
<td>雇员日期</td>
</tr>
<%
while(rs.next())
{
int empno=rs.getInt(1);
String ename=rs.getString(2);
String job=rs.getString(3);
float sal=rs.getFloat(4);
Date date=rs.getDate(5);
%>
<tr>
<td><%=empno%></td>
<td><%=ename%></td>
<td><%=job%></td>
<td><%=sal%></td>
<td><%=date%></td>
</tr>
<%
}
%>
</table>
</center>
<%
}
catch(Exception e)
{
System.out.println(e);
}finally
{
rs.close();
pstmt.close();
conn.close();
}
%>
</body>
</html>

0 0