jsp连接MYSQL数据库代码_jsp连接mysql的文件下载代码-CSDN博客

本文链接：https://blog.csdn.net/aalililii/article/details/111934119

netbeans里面用JSP连接数据库的代码，在库里放个jar包就可以测试连接了

<%@ page contentType="text/html"%>  
<%@page pageEncoding="GB2312"%>  
<%@page import="java.sql.*" %>  <%--导入java.sql包--%>
<html>
<head>
<title >从MySQL数据库中读出student表</title>
</head>
<body bgcolor="orange">
<%  
        try {  
            Class.forName("com.mysql.jdbc.Driver"); 
            String url = "jdbc:mysql://localhost:3306/test"; //数据库名
            String username = "root";  //数据库用户名
            String password = "root";  //数据库用户密码
            Connection conn = DriverManager.getConnection(url, username, password);

            if(conn != null){  
                out.print("数据库连接成功！");  
                out.print("<br />"); 
%>
<table border="2">
<tr>
<th width="87" align="center">学号</th>
            <th width="87" align="center">姓名</th>
            <th width="87" align="center">性别</th>
            <th width="87" align="center">年龄</th>
            <th width="87" align="center">体重</th>
</tr>
<%
                Statement stmt = null;  
                ResultSet rs = null;  
                String sql = "SELECT * FROM student;";  //查询语句
                stmt = conn.createStatement();  
                rs = stmt.executeQuery(sql);  
                out.print("查询结果：");  
				out.print("<br/>");
                while (rs.next()) {%>
   <tr>
            `在这里插入代码片`<td><%=rs.getString("SID")%></td>>
            <td><%=rs.getString("SName")%></td>>
            <td><%=rs.getString("SSex")%></td>>
            <td><%=rs.getString("SAge")%></td>>
            <td><%=rs.getString("SWeight")%></td>>
  </tr>
  <%
            }  
            }else{  
                out.print("连接失败！");  
            }  
        }catch (Exception e) {        
            //e.printStackTrace();  
            out.print("数据库连接异常！");  
        }  
%> 
</table>
</body>
</html>