文档介绍:本例需要的软件和运行环境:
1、 Windows2000 Server 操作系统
2、
3、 (java源码编辑调试器,吐血推荐!)
4、 Macromedia JRun MX
5、 Macromedia Dreamweaver MX (非必需)
6、 MySQL 数据库(最好安装 MySQL Control Center)
一、数据库设计
用MySQL Control Center打开MySQL数据库,新建数据库 shopping,在其下新建
表tbl_user,其中各字段设置如下:
Fiftld
Typ* I
Null
Default
Extrsi
? id
int (11)
FRI
0
v ar char [LOCO
YES
virchir Cl 00]
IBS
Email
var char Cl 00)
IES
二、编写连接数据库 bean :
//DBCo nn .java
//in clude required classes
import .*;
//========================================== // Defi ne Class DBC onn
//========================================== public class DBConn
{
public Stri ng sql_driver = "";
public Stri ng sql_url = "jdbc:mysql://localhost:3306";
public Stri ng sql_DBName = "shopp in g";
public Stri ng user = "sa";
public Stri ng pwd ="";
Conn ecti on conn 二 n ull;
Stateme nt stmt = n ull;
ResultSet rs = null;
public boolea n setDriver(Stri ng drv)
{
= drv;
return true;
}
public Stri ng getDriver()
{
return ;
}
public boolea n setUrl(Stri ng url)
{
= url;
return true;
}
public boolean setDBName(String dbname)
{
= dbn ame;
return true;
}
public Stri ng getDBName()
{
return ;
}
public boolea n setUser(Stri ng user)
{
= user;
try{
return true;
}
public Stri ng getUser()
{
retur n ;
}
public boolea n setPwd(Stri ng pwd)
{
= pwd;
return true;
}
public String getPwd()
{
return ;
}
public DBCo nn()
{
try{
(sql_driver);〃 加载数据库驱动程序
onn 二 DriverMa onn ectio n(sql_url + "/" + sql_DBName + ”?user二"+ user + "&password=" + pwd +
"&use Un icode二true&characterE ncodi ng二gb2312");
= onn .createStateme nt();
}catch(Excepti on e){
ntl n( ng());
}
}
//执行查询操作
public ResultSet e