先贴段jsp代码试试

作者: 贫道化缘不化斋
来源: 51数据库
2021-07-28

<%@ page contenttype="text/html;charset=utf-8" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
     string strname = "";
     string strsex = "" ;
     try
     {
      class.forname("com.mysql(和php搭配之最佳组合).jdbc.driver").newinstance();
      string url = "jdbc:mysql(和php搭配之最佳组合)://localhost:3306/samp_db" ;
      string struser = "root" ;
      string strpasswd = "123" ;
      connection conn = drivermanager.getconnection(url,struser,strpasswd) ;
      statement stmt = conn.createstatement(resultset.type_scroll_insensitive,resultset.concur_updatable) ;
      string strsql = "select * from student" ;
      resultset rs = stmt.executequery(strsql) ;
      while(rs.next())
      {
        strname = rs.getstring("name") ;
        strsex = rs.getstring("sex") ;
        out.print(strname) ;
        out.println(strsex) ;
       }
       stmt.close() ;
       conn.close() ;
   }
   catch(exception e)
    {
        e.printstacktrace() ;
    }
%>
</body>
</html>