首页 > 数据库技术 > 详细

jsp+连接MYSQL5.1

时间:2014-03-06 15:05:46      阅读:595      评论:0      收藏:0      [点我收藏+]
bubuko.com,布布扣
<%
        String DBDriver = "org.gjt.mm.mysql.Driver";
        String DBUrl = "jdbc:mysql://localhost:3306/cheng_base";
        String DBUser = "root";
        String DBPassword = "cheng";
        Class.forName(DBDriver);
        Connection conn = null;
        try 
        {
            conn = DriverManager.getConnection(DBUrl,DBUser,DBPassword);
            out.println("数据库连接成功!");
        }
        catch(Exception ex)
        {
            //out.println("连接失败!");
            ex.printStackTrace();
            //return ;
        }
        Statement sqlStatement = conn.createStatement();
        String sql = "select * from cheng";
        ResultSet rs = sqlStatement.executeQuery(sql);
        while(rs.next())
        {
        %>
            <%=rs.getString(1)%>
            <%=rs.getString(2)%>
            你是 <%=rs.getString(3)%><br  />
        <%
        }
        %>
bubuko.com,布布扣

jsp+连接MYSQL5.1,布布扣,bubuko.com

jsp+连接MYSQL5.1

原文:http://www.cnblogs.com/cheng07045406/p/3582203.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!