本例需要的软件和运行环境

《本例需要的软件和运行环境》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、本例需要的软件和运行环境：1、Windows2000Server操作系统2、jdk1.43、JCreator2.5（java源码编辑调试器，吐血推荐！）4、MacromediaJRunMX5、MacromediaDreamweaverMX（非必需）6、MySQL数据库（最好安装MySQLControlCenter）一、数据库设计用MySQLControlCenter打开MySQL数据库，新建数据库shopping，在其下新建表tbl_user，其中各字段设置如下：二、编写连接数据库bean：DBCo

2、nn.java//DBConn.java//includerequiredclassesimportjava.sql.*;//==========================================//DefineClassDBConn//==========================================publicclassDBConn{publicStringsql_driver="org.gjt.mm.mysql.Driver";publicStringsql_u

3、rl="jdbc:mysql://localhost:3306";publicStringsql_DBName="shopping";publicStringuser="sa";publicStringpwd="";Connectionconn=null;Statementstmt=null;ResultSetrs=null;publicbooleansetDriver(Stringdrv){this.sql_driver=drv;returntrue;}publicStringgetDriver(

4、){returnthis.sql_driver;}publicbooleansetUrl(Stringurl){this.sql_url=url;returntrue;}publicbooleansetDBName(Stringdbname){this.sql_DBName=dbname;returntrue;}publicStringgetDBName(){returnthis.sql_DBName;}publicbooleansetUser(Stringuser){this.user=user;

5、returntrue;}publicStringgetUser(){returnthis.user;}publicbooleansetPwd(Stringpwd){this.pwd=pwd;returntrue;}publicStringgetPwd(){returnthis.pwd;}publicDBConn(){try{Class.forName(sql_driver);//加载数据库驱动程序this.conn=DriverManager.getConnection(sql_url+"/"+sq

6、l_DBName+"?user="+user+"&password="+pwd+"&useUnicode=true&characterEncoding=gb2312");this.stmt=this.conn.createStatement();}catch(Exceptione){System.out.println(e.toString());}}//执行查询操作publicResultSetexecuteQuery(StringstrSql){try{this.rs=stmt.executeQ

7、uery(strSql);returnthis.rs;}catch(SQLExceptione){System.out.println(e.toString());returnnull;}catch(NullPointerExceptione){System.out.println(e.toString());returnnull;}}//执行数据的插入、删除、修改操作publicbooleanexecute(StringstrSql){try{if(this.stmt.executeUpdate(

8、strSql)==0)returnfalse;elsereturntrue;}catch(SQLExceptione){System.out.println(e.toString());returnfalse;}catch(NullPointerExceptione){System.out.println(e.toString());returnfalse;}}//结果集指针跳转到某一行publicbooleanrs_absolute(introw){try{this