有没有关于针对文本文件或数据库读取和写入的例子

p<%@ page import="java.sql.*" %> <html>
<head>
<title>Administrator  Login  JSP Page</title>
</head>
<body bgcolor=white>
<%
try { 
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } 
catch (Exception E) { 
out.println("Unable to load driver."); } 
  
try { 
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/iwadp?user=root&password=&useUnicode=true&characterEncoding=8859_1"); 
Statement s=C.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
ResultSet rs=s.executeQuery("select * from USER_MASTER"); 
out.println("<table border=1>"); 
int i=1; 
for (i=1;i<2;i++) 
{ 
if (rs.absolute(i)) 
{ 
out.println("<tr><td>"); 
out.println(rs.getString(1)); 
out.println("</td>"); 
out.println("<td>"); 
out.print(rs.getString(2)); 
out.println("</td>"); 
out.println("<td>"); 
out.print(rs.getString(3)); 
out.println("</td></tr>"); 
} 
else 
{ 
break; 
} } 
out.println("</table>"); 
rs.close(); 
s.close(); 
C.close(); 
} 
catch (SQLException E) { 
out.println("SQLException: " + E.getMessage()); 
out.println("SQLState: " + E.getSQLState()); 
out.println("VendorError: " + E.getErrorCode()); 
} %>  <FORM ACTION="login_01.jsp" NAME="LOGIN" METHOD="post">
  <div align="center">
  <table width="75%" border="0">
        <tr>
  <td width="7%">&nbsp;</td>
  <td colspan="2">&nbsp;</td>
  <td width="18%">&nbsp;</td>
  </tr>
      <tr> 
      <td width="7%">&nbsp;</td>
      <td colspan="2">&nbsp;</td>
      <td width="18%">&nbsp;</td>
  </tr>
  <tr> 
     <td width="7%">&nbsp;</td>
     <td colspan="2">&nbsp;</td>
     <td width="18%">&nbsp;</td>
  </tr>
  <tr>
   <td width="7%">&nbsp;</td>
     <td colspan="2"> 
       <div align="center">Admin Control</div>
         </td>
        <td width="18%">&nbsp;</td>
       </tr>
       <tr> 
      <td width="7%">&nbsp;</td>
      <td colspan="2">&nbsp;</td>
      <td width="18%">&nbsp;</td>
      </tr>
      <tr> 
      <td width="7%">&nbsp;</td>
      <td colspan="2"> 
      <div align="center">UserName 
      <input type="text" name="textfield" size="20" maxlength="12">
      </div>
      </td>
      <td width="18%">&nbsp;</td>
      </tr>
      <tr>
      <td width="7%">&nbsp;</td>
      <td colspan="2">&nbsp;</td>
      <td width="18%">&nbsp;</td>
      </tr>
      <tr>
      <td width="7%">&nbsp;</td>
      <td colspan="2"> 
      <div align="center">PassWord 
      <input type="password" name="textfield2" size="20" maxlength="12">
      </div>
      </td>
      <td width="18%">&nbsp;</td>
      </tr>
     <tr> 
      <td width="7%">&nbsp;</td>
        <td width="55%">&nbsp;</td>
        <td width="20%">&nbsp;</td>
      <td width="18%">&nbsp;</td>
      </tr>
     <tr> 
     <td width="7%">&nbsp; </td>
        <td width="55%"> 
          <div align="right">
     <input type="submit" name="Submit" value="Submit">
      </div>
      </td>
        <td width="20%">&nbsp;</td>
      <td width="18%">&nbsp;</td>
      </tr>
      </table>
      </div>
</form>
</body>
</html>

解决方案 »

  1.   

    上面是一个JSP程序，改一下相应的SQL语句就可以了，MYSQL数据库，ROOT没有口令抽取如下的代码，稍做编写就是一个APPLICATION程序。OK
    try { 
    Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } 
    catch (Exception E) { 
    out.println("Unable to load driver."); } 
      
    try { 
    Connection C = DriverManager.getConnection("jdbc:mysql://localhost/iwadp?user=root&password=&useUnicode=true&characterEncoding=8859_1"); 
    Statement s=C.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
    ResultSet rs=s.executeQuery("select * from USER_MASTER"); 
    out.println("<table border=1>"); 
    int i=1; 
    for (i=1;i<2;i++) 
    { 
    if (rs.absolute(i)) 
    { 
    out.println("<tr><td>"); 
    out.println(rs.getString(1)); 
    out.println("</td>"); 
    out.println("<td>"); 
    out.print(rs.getString(2)); 
    out.println("</td>"); 
    out.println("<td>"); 
    out.print(rs.getString(3)); 
    out.println("</td></tr>"); 
    } 
    else 
    { 
    break; 
    } } 
    out.println("</table>"); 
    rs.close(); 
    s.close(); 
    C.close(); 
    } 
    catch (SQLException E) { 
    out.println("SQLException: " + E.getMessage()); 
    out.println("SQLState: " + E.getSQLState()); 
    out.println("VendorError: " + E.getErrorCode()); 
    }