数据库综合实验报告格式模版（3000字）

52、 */

53、 public resultset do_sql(string sql) throws sqlexception{ 54、

55、 rs = (resultset) stmt.executequery(sql); 56、 return rs; 57、 } 58、

59、 /*登录时候对数据库的操作函数 60、 * 无参数

61、 * return null; 62、 */

63、 public void get_login_id_password() throws sqlexception{// 64、

65、 rs = (resultset) stmt.executequery(select id,password from login ); 66、

67、 }

68、 /*管理员注册

69、 * 操作：对数据库login表进行插入操作 70、 * 参数：id，password 71、 * return null; 72、 */

73、 public void insert_id_password(string id,string password) throws sqlexception{ 74、

75、 stmt.executequery(insert

login(id,password)values(+id++,++password+) ); 76、 } 77、

78、 /*判断车辆的出租状态 // into79、 * 操作：对合同表和车辆表的连接查询

80、 *参数：无

81、 * return rs;返回rs集合 82、 */

83、 public resultset judge_car_state() throws sqlexception{ 84、 85、 rs=(resultset) stmt.executequery(select rentalno,vehicle.vehlicenseno from rentalagreement,vehicle where rentalagreement.vehlicenseno=vehicle.vehlicenseno; ); 86、 while(rs.next()){ 87、 88、 }

89、 return rs; 90、 } 91、 92、}

2、员工信息

import java.sql.sqlexception; import java.util.logging.level; import java.util.logging.logger; /*

* to change this template, choose tools | templates * and open the template in the editor. */

/** *

* @author 马寄闪珊珊

* @time 2012-11-23 16：23

* @for 对错误报告进行插入和更新数据 */

public class fault_info_ui extends javax.swing.jframe { /**

* creates new form fault_info_ui */

public fault_info_ui() { }

/**

* this method is called from within the constructor to initialize the form.* warning: do not modify this code. the content of this method is always * regenerated by the form editor. */

@suppresswarnings(unchecked)

jlabel1 = new javax.swing.jlabel(); jlabel2 = new javax.swing.jlabel(); jlabel3 = new javax.swing.jlabel(); jlabel4 = new javax.swing.jlabel(); jlabel5 = new javax.swing.jlabel();

jtextfield1 = new javax.swing.jtextfield(); jtextfield2 = new javax.swing.jtextfield(); jtextfield3 = new javax.swing.jtextfield(); jtextfield4 = new javax.swing.jtextfield(); ok = new java.awt.button(); exit = new java.awt.button();

setdefaultcloseoperation(javax.swing.windowconstants.dispose_on_close); jlabel1.settext(车辆编号); jlabel2.settext(检查日期); jlabel3.settext(评价); jlabel4.settext(员工号);

jlabel5.setfont(new java.awt.font(宋体, 0, 18)); // noi18n jlabel5.settext(请仔细输入错误报告信息);

ok.setlabel(ok);

ok.addactionlistener(new java.awt.event.actionlistener() { public void actionperformed(java.awt.event.actionevent evt) { okactionperformed(evt); } });

exit.setlabel(exit);

exit.addactionlistener(new java.awt.event.actionlistener() { public void actionperformed(java.awt.event.actionevent evt) { exitactionperformed(evt); }});

javax.swing.grouplayout layout = new javax.swing.grouplayout(getcontentpane()); getcontentpane().setlayout(layout); layout.sethorizontalgroup(

layout.createparallelgroup(javax.swing.grouplayout.alignment.leading) .addgroup(layout.createsequentialgroup() .addgap(37, 37, 37)

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.leading)

.addgap(59, 59, 59)

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.trailing, false)

javax.swing.grouplayout.alignment.leading) javax.swing.grouplayout.alignment.leading) javax.swing.grouplayout.alignment.leading,

javax.swing.grouplayout.default_size, 194, short.max_value)) .addcontainergap(javax.swing.grouplayout.default_size, short.max_value))

.addgroup(javax.swing.grouplayout.alignment.trailing, layout.createsequentialgroup() .addgap(0, 0, short.max_value) .addgap(19, 19, 19)

.addgroup(javax.swing.grouplayout.alignment.trailing, layout.createsequentialgroup()

.addcontainergap(119, short.max_value) .addgap(83, 83, 83)) );

layout.setverticalgroup(

layout.createparallelgroup(javax.swing.grouplayout.alignment.leading).addgroup(layout.createsequentialgroup() .addcontainergap() .addgap(66, 66, 66)

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.baseline)

javax.swing.grouplayout.preferred_size, javax.swing.grouplayout.default_size, javax.swing.grouplayout.preferred_size)) .addgap(24, 24, 24)

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.baseline)

javax.swing.grouplayout.preferred_size, javax.swing.grouplayout.default_size, javax.swing.grouplayout.preferred_size)) .addgap(21, 21, 21)

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.baseline)

javax.swing.grouplayout.preferred_size, javax.swing.grouplayout.default_size, javax.swing.grouplayout.preferred_size)) .addgap(24, 24, 24)

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.baseline)

javax.swing.grouplayout.preferred_size, javax.swing.grouplayout.default_size, javax.swing.grouplayout.preferred_size))

.addgroup(layout.createparallelgroup(javax.swing.grouplayout.alignment.leading, false)

.addgap(0, 75, short.max_value)) );

java.awt.dimension screensize = java.awt.toolkit.getdefaulttoolkit().getscreensize();

setbounds((screensize.width-416)/2, (screensize.height-488)/2, 416, 488);}// </editor-fold>

private void okactionperformed(java.awt.event.actionevent evt) { // todo add your handling code here:

if(operate_ui.state.equals(insert)){ //执行对数据库的插入操作 string sql=insert into

+ +jtextfield1.gettext().tostring()++,+

+jtextfield2.gettext().tostring()++, ++jtextfield3.gettext().tostring()+ +, + +jtextfield4.gettext().tostring()++); try {

dodatabase.stmt.execute(sql); } catch (sqlexception ex) {

logger.getlogger(car_info_ui.class.getname()).log(level.severe, null, ex); }}

if(operate_ui.state.equals(update)){ string sql=update faultreport set+

vehlicenseno=++jtextfield1.gettext().tostring()++,+datachecked=++jtextfield2.g