jsp显示mysql数据库_JSP连接MySql数据库方法

相应代码为

classDriver=”sun.jdbc.odbc.JdbcOdbcDriver”

url=”jdbc:odbc:MySql”

举个例子

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection conn=DriverManager.getConnection("jdbc:odbc:MySql","","");

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("select * from userinfo");

while(rs.next())

{

out.print("
用户名："+rs.getString("username")+"密码："+rs.getString("password"));

}

rs.close();

stmt.close();

conn.close();