JSP中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 td%=rs.getString(password) %/td /tr % } % % out.print(数据库操作成功，恭喜你); sqlbean.close(); % /table /body /html 2.插入数据： %@ 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 h1center向表中添加信息/center/h1 brbrbrhrbrbrbr % String sql=insert into stud values(01,1,1,786596905,11407,99,99,99); sqlbean.doUpdate(sql); out.println(数据插入成功！); % /body /html 3.修改数据： %@ page pageEncoding=utf-8 contentType=text/html% %@ page language=java import=java.sql.*% jsp:useBean id=sqlbean1 scope=page class=tom.jiafei.DBhelper/jsp:useBean html head /head body bgcolor=blue h1center更新表中的信息/center/h1 brbrbrhrbrbrbr form action=l3.jsp method=post center p输入学号:input type=text name=idbr p新的姓名:input type=text name=namebr p新的地址:input type=text name=addrbr p新的电话:input type=text name=telbr p新的班级:input type=text name=gradebr p新的语文:input type=text name=chinesebr p新的数学:input type=text name=mathbr p新的英语:input type=text name=englishbrbr input type=submit name=submit value= 更nbsp;新 /center /form centerp数据库更新前记录：/centerbr table align=center border=1 tr align=center td width=100学号/td td width=100姓名/td td width=10