<%@ page import="java.sql.Connection" %><%@ page import="java.sql.DriverManager" %><%@ page import="java.sql.Statement" %><%@ page import="java.sql.ResultSet" %><%-- Created by IntelliJ IDEA. User: Administrator Date: 2015-08-21 Time: 16:13 To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <script type="text/javascript" src = "http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.0.js"></script> <script type="text/javascript" src = "wejs/jquery-2.1.1.min.js"></script></head><body><% String driverName = "com.mysql.jdbc.Driver"; String userName = "root"; String userPasswd = "root"; String dbName = "pfrm"; String tableName = "payout"; String url = "jdbc:mysql://localhost:3306/" + dbName + "?user=" + userName + "&password=" + userPasswd; Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection connection = DriverManager.getConnection(url); Statement statement = connection.createStatement(); String sql = "SELECT * FROM " + tableName; ResultSet rs = statement.executeQuery(sql);%><table id="dg"title="收入一览" class="easyui-datagrid" style="width:900px; height: 400px; padding-left: 200px;" pagination="true" rownumbers="true" fitcolumns="true"singleselect="true"> <thead> <tr> <th field ="1" width="50">支出名称</th> <th field ="2" width="50">支出金额</th> <th field ="3" width="50">支出时间</th> </tr> </thead> <tbody> <% while (rs.next()) { %> <tr> <td> <% out.print(rs.getString(2)); %> </td> <td> <% out.print(rs.getString(3)); %> </td> <td> <% out.print(rs.getString(4)); %> </td> </tr> </tbody> <% } %></table></body></html>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow