i 绝望

依然

Miss Lang

java web 程序---jsp连接mysql数据库的实例基础+表格显示

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
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="gb2312"%>
 
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  
   
  <body>
  <center>JSP连接mysql数据库</center>
   <%
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123");
    Statement stm=conn.createStatement();
    //stm.executeUpdate("insert into shop values ('男','林俊杰','323')");
    ResultSet rs=stm.executeQuery("select * from shop");
    out.print("<table border='1'>");
    out.print("<tr><td>性别:</td><td>姓名:</td><td>密码:</td></tr>");
    while(rs.next()){
        out.print("<tr>");
        out.print("<td>"+rs.getString("sex")+"</td>");
        out.print("<td>"+rs.getString("name")+"</td>");
        out.print("<td>"+rs.getString("pass")+"</td>");
        out.print("</tr>");
    }
    out.print("</table>");
    %>
  </body>

  

posted on   juewang  阅读(1206)  评论(0编辑  收藏  举报
努力加载评论中...

绝望依然

Miss Lang
点击右上角即可分享
微信分享提示