81,092
社区成员
发帖
与我相关
我的任务
分享
<div class="movie movie-test movie-test-light movie-test-right">
<div class="movie__images">
<a href="Efilminfo.jsp?filmChs=第三度嫌疑人" class="movie-beta__link">
<img alt="" src="images/dsdxyr.png" class="img-responsive" alt=""/>
</a>
</div>
<div class="movie__info">
<a href="single.html" class="movie__title">电影名: </a>
<p class="movie__time">时长:</p>
<p class="movie__option"><a href="single.html">类型:</p>
<ul class="list_6">
<li><i class="icon1"> </i><p>导演:</p></li>
<li><i class="icon3"> </i><p>年份:</p></li>
<li>评分 : </p></li>
<div class="clearfix"> </div>
</ul>
</div>
<div class="clearfix"> </div>
</div>
<div class="clearfix"> </div>
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
//加载驱动程序
String driverName="com.mysql.jdbc.Driver";
//数据库信息
String userName="root";
//密码
String userPasswd="123";
//数据库名
String dbName="Student";
//表名
String tableName="stu_info";
//将数据库信息字符串连接成为一个完整的url(也可以直接写成url,分开写是明了可维护性强)
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql="SELECT * FROM "+tableName;
ResultSet rs = stmt.executeQuery(sql);
out.print("id");
out.print("|");
out.print("name");
out.print("|");
out.print("phone");
out.print("<br>");
while(rs.next()) {
out.print(rs.getString(1)+" ");
out.print("|");
out.print(rs.getString(2)+" ");
out.print("|");
out.print(rs.getString(3));
out.print("<br>");
}
out.print("<br>");
out.print("ok, Database Query Successd!");
rs.close();
stmt.close();
conn.close();
%>