如何在jsp连接mysql数据库

2023-04-10 18:53:52

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*"%>

<html>

<body>

<%Class.forName("com.mysql.jdbc.Driver").newInstance();

String url ="jdbc:mysql://localhost:3306/testdb?user=root&"+

"password=123&useUnicode=true&characterEncoding=8859_1";

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); %>

?????????? <td>?ㄧ??绗?浜?涓?瀛?娈靛??瀹逛负锛?</td></tr>

while(rs.next()) {%>

<%=rs.getString(1)%> </td><td>

<%=rs.getString(2)%> </td></tr>

<%}%>

</table>

<%out.print("?版??搴???浣?????锛?????浣?");%>

<%rs.close();

stmt.close();

conn.close();

</body>

继续阅读