中MySQL数据库的增删改查的简单应用.docVIP

MySQL数据库的访问JSP代码： 1.直接访问查询： %@ page pageEncoding=utf-8 contentType=text/html% %@ page language=java import=java.sql.*% jsp:useBean id=sqlbean scope=page class=tom.jiafei.DBhelper/jsp:useBean html head /head body bgcolor=blue br h2centerJDBC直接访问mysql数据库/center/h2 brhrbr table align=center tr align=center td编号/td td用户名/td td密码/td /tr % //DBhelper db=new DBhelper(); String sql=select * from login; ResultSet rs=sqlbean.doQuery(sql); while(rs.next()){ % tr td%=rs.getString(id) %/td td%=rs.getString(user) %/td