JDBC进行数据库连接操作
在page指令中可以使用import导入所需要的java开发包java.sql,进行数据库开发。
查询代码如下所示
<%@page contentType="text/html" pageEncoding="GBK" %>
<%@page import="java.sql.*" %>
<html>
<head>
<title>jdbc编程测试</title>
</head>
<body>
<%!
public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/baron";
public static final String DBUSER="root";
public static final String DBPASS="mysql";
%>
<%
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
%>
<%
try {
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="SELECT name,age FROM user";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while (rs.next()){
String name=rs.getString("name");
int age=rs.getInt("age");
%>
<%=name%><br><%=age%><br>
<%
}
rs.close();
pstmt.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
%>
<%="结果显示"%>
</body>
</html>