分布式数据库程序.docVIP

基于jsp实现分布式数据库的增删改查 一、增加用户表单 form name=addform method=post action=reader_save.jsp table width=600 height=432 border=0 cellpadding=0 cellspacing=0 bgcolor=lightgreen tr td height=35 align=center编号：/td tdinput name=id type=text/td /tr tr td width=173 align=center学号：/td td width=427 height=39labelinput name=number type=text*/label/td /tr tr td align=center姓名：/td td height=35labelinput type=text name=name id=textfield /*/label/td /tr tr td width=173 align=center性别：/td td height=35 input name=sex type=radio class=noborder id=radiobutton value=男 checked label for=radiobutton男 /label labelinput name=sex type=radio class=noborder value=女女/label/td /tr tr td height=35 align=center班级：/td tdinput name=banji type=text/td /tr tr td height=35 align=center院系：/td tdlabel input type=text name=dept /label/td /tr tr td height=35 align=center电话：/td tdlabel input type=text name=telephone /label/td /tr tr td height=35 align=center密码：/td tdlabel input type=text name=password /label/td /tr tr td height=35 align=center创建日期：/td tdlabel input type=text name=create_date /label/td /tr /table input name=Submit type=submit value=保存 class=STYLE2/ nbsp; input name=Submit2 type=button value=返回 onClick=history.back() class=STYLE2 /form 保存到数据库 % ResultSet rs = null; Statement stmt = null; Connection conn = null; boolean falg = false; String dbuser = root; String dbpwd = ; String url = jdbc:mysql://localhost:3306/liuchengqi?useUnicode=truecharacterEncoding=gbk; Class.forName(org.gjt.mm.mysql.Driver); conn=DriverManager.getConnection(url,dbuser,dbpwd); stmt = conn.createStatement(); rs=stmt.executeQuery(select * from stuuser); % %