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();
相应代码为 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();