分布式数据库程序.doc
文本预览下载声明
基于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);
%
%
显示全部