<%@ page language="java" import="java.util.*" contentType="text/html;charset=utf-8" pageEncoding="utf-8"%>
<%@ page import=" java.sql.*" %>
<!DOCTYPE HTML >
查看页面
<%!
public static final String DBDRIVER ="org.gjt.mm.mysql.Driver";
public static final String DBPASS="123654789";
public static final String DBURL="jdbc:mysql://localhost:3306/test";
public static final String DBUSER="root";
%>
<%
String username=null;
String salary=null;
ResultSet rs=null;
Connection conn =null;
%>
try{
Class.forName("DBDRIVER");
Connection conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql_select="select * form tb5";
preparedStatement ps=conn.prepareStatement("sql_select");
rs=ps.executeQuery();
%>
<tabel>
<tr><td>用户名</td><td>工资</td></tr>
<%
while(rs.next()){
%>
<tr>
<td><%=rs.getString("username")%></td>
<td><%=rs.getString("salary")%></td>
</tr>
</tabel>
}
}
catch(Exception e){
out.print("图书信息查询失败!");
e.printStackTrace();
}