- <%@ page contentType="text/html;charset=gb2312"%>
- <%@ page import="java.sql.*"%>
- <html>
- <body>
- <%
- Class.forName("org.gjt.mm.mysql.Driver").newInstance();
- String url = "jdbc: mysql://localhost/testDB?user=root&password=12345678&useUnicode=true&characterEncoding=8859_1";
- //testDB为你的数据库名
- Connection conn = DriverManager.getConnection(url);
- Statement stmt = conn
- .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
- ResultSet.CONCUR_UPDATABLE);
- String sql = "select * from test";
- ResultSet rs = stmt.executeQuery(sql);
- while (rs.next()) {
- %>
- 您的第一个字段内容为:<%=rs.getString(1)%>
- 您的第二个字段内容为:<%=rs.getString(2)%>
- <%
- }
- %>
- <%
- out.print("数据库操作成功,恭喜你");
- %>
- <%
- rs.close();
- stmt.close();
- conn.close();
- %>
- </body>
- </html>
来源: http://www.phpxs.com/code/1002725/