jsp连接数据库的语句

<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
<%@ page language=“java” import=“java.sql.Connection” %>
<%@ page language=“java” import=“java.sql.Statement” %>
<%@ page language=“java” import=“java.sql.ResultSet” %>
<%@ page language=“java” import=“java.sql.DriverManager” %>
<%@ page language=“java” import=“java.sql.SQLException” %>

<%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
String url=“jdbc:mysql://localhost:3306/student1”;//（数据库名字）
String pass="******";//（数据库密码）
String name=“root”;
try {
con=DriverManager.getConnection(url,name,pass);//连接数据库
} catch (SQLException e) {

e.printStackTrace();

}

try {
sql = (Statement) con.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

rs=sql.executeQuery(“select * from studentinfo”);
while(rs.next()){
String name1=rs.getString(1);
String pass1=rs.getString(2);
String sex=rs.getString(3);
String num=rs.getString(4);
out.print(name1);out.print(" “);
out.print(pass1);out.print(” “);
out.print(sex);out.print(” “);
out.println(num);out.print(” ");
%>

姓名：<%=name1 %>  
密码：<%=pass1 %>  
性别：<%=sex %>  
学号：<%=num %>  

<% }
%>

<% con.close();%>