在Jsp中用Bean和Servlet聯合實現用戶注冊
2024-09-05 00:20:05
供稿：網友
本例需要的軟件和運行環境：
1、windows2000 server操作系統
2、jdk1.4
3、jcreator2.5（java源碼編輯調試器）
4、macromedia jrun mx
5、macromedia dreamweaver mx（非必需）
6、mysql數據庫（最好安裝mysql control center）
一、數據庫設計
用mysql control center打開mysql數據庫，新建數據庫shopping，在其下新建表tbl_user，其中各字段設置如下：
二、編寫連接數據庫bean：dbconn.java
//dbconn.java
//include required classes
import java.sql.*;
//==========================================
// define class dbconn
//==========================================
public class dbconn
{
public string sql_driver = "org.gjt.mm.mysql.driver";
public string sql_url = "jdbc:mysql://localhost:3306";
public string sql_dbname = "shopping";
public string user = "sa";
public string pwd = "";
connection conn = null;
statement stmt = null;
resultset rs = null;
public boolean setdriver(string drv)
{
this.sql_driver = drv;
return true;
}
public string getdriver()
{
return this.sql_driver;
}
public boolean seturl(string url)
{
this.sql_url = url;
return true;
}
public boolean setdbname(string dbname)
{
this.sql_dbname = dbname;
return true;
}
public string getdbname()
{
return this.sql_dbname;
}
public boolean setuser(string user)
{
this.user = user;
return true;
}
public string getuser()
{
return this.user;
}
public boolean setpwd(string pwd)
{
this.pwd = pwd;
return true;
}
public string getpwd()
{
return this.pwd;
}
public dbconn()
{
try{
class.forname(sql_driver);//加載數據庫驅動程序
this.conn = drivermanager.getconnection(sql_url + "/" + sql_dbname + "?user=" + user + "&password=" + pwd + "&useunicode=true&characterencoding=gb2312");
this.stmt = this.conn.createstatement();
}catch(exception e){
system.out.println(e.tostring());
}
}
//執行查詢操作
public resultset executequery(string strsql)
{
try{
this.rs = stmt.executequery(strsql);
return this.rs;
}catch(sqlexception e){
system.out.println(e.tostring());
return null;
}catch(nullpointerexception e){
system.out.println(e.tostring());
return null;
}
}
//執行數據的插入、刪除、修改操作
public boolean execute(string strsql)
{
try{
if(this.stmt.executeupdate(strsql) == 0)
return false;
else
return true;
}catch(sqlexception e){
system.out.println(e.tostring());
return false;
}catch(nullpointerexception e){
system.out.println(e.tostring());
return false;
}
}
//結果集指針跳轉到某一行
public boolean rs_absolute(int row)
{
try{
this.rs.absolute(row);
return true;
}catch(sqlexception e){
system.out.println(e.tostring());
return false;
}
}
public void rs_afterlast()
{
try{
this.rs.afterlast();
}catch(sqlexception e){
system.out.println(e.tostring());
}
}
public void rs_beforefirst()
{
try{
this.rs.beforefirst();
}catch(sqlexception e){
system.out.print(e.tostring());
}
}
public void rs_close()
{
try{
this.rs.close();
}catch(sqlexception e){
system.out.print(e.tostring());
}
}
public void rs_deleterow()
{
try{
this.rs.deleterow();
}catch(sqlexception e){
system.out.print(e.tostring());
}
}
public boolean rs_first()
{
try{
this.rs.first();
return true;
}catch(sqlexception e){
system.out.print(e.tostring());
return false;
}
}
public string rs_getstring(string column)
{
try{
return this.rs.getstring(column);
}catch(sqlexception e){
system.out.println(e.tostring());
return null;
}
}
//此方法用于獲取大段文本，
//將其中的回車換行替換為
//輸出到html頁面
public string rs_gethtmlstring(string column)
{
try{
string str1 = this.rs.getstring(column);
string str2 = "/r/n";
string str3 = "
";
return this.replaceall(str1,str2,str3);
}catch(sqlexception e){
system.out.println(e.tostring());
return null;
}
}
//把str1字符串中的str2字符串替換為str3字符串
private static string replaceall(string str1,string str2,string str3)
{
stringbuffer strbuf = new stringbuffer(str1);
int index=0;
while(str1.indexof(str2,index)!=-1)
{
index=str1.indexof(str2,index);
strbuf.replace(str1.indexof(str2,index),str1.indexof(str2,index)+str2.length(),str3);
index=index+str3.length();
str1=strbuf.tostring();
}
return strbuf.tostring();
}
public int rs_getint(string column)
{
try{
return this.rs.getint(column);
}catch(sqlexception e){
system.out.println(e.tostring());
return -1;
}
}
public int rs_getint(int column)
{
try{
return this.rs.getint(column);
}catch(sqlexception e){
system.out.println(e.tostring());
return -1;
}
}
public boolean rs_next()
{
try{
return this.rs.next();
}catch(sqlexception e){
system.out.println(e.tostring());
return false;
}
}
//判斷結果集中是否有資料
public boolean hasdata()
{
try{
boolean has_data = this.rs.first();
this.rs.beforefirst();
return has_data;
}catch(sqlexception e){
system.out.println(e.tostring());
return false;
}
}
public boolean rs_last()
{
try{
return this.rs.last();
}catch(sqlexception e){
system.out.println(e.tostring());
return false;
}
}
public boolean rs_previous()
{
try{
return this.rs.previous();
}catch(exception e){
system.out.println(e.tostring());
return false;
}
}
//main方法，調試用
public static void main(string args[])
{
try{
dbconn myconn = new dbconn();
//myconn.setdbname("shopping");
//myconn.dbconn();
//myconn.execute("insert into tbl_test(id,name) values('10','shandaer')");
//myconn.execute("update tbl_test set name='yyyyyyyyyyyy' where id=10");
//myconn.execute("delete from tbl_test where id=1");
resultset rs = myconn.executequery("select * from tbl_user order by id desc limit 1");
//boolean hasdata = myconn.hasdata();
//system.out.println("has data:" + hasdata);
//rs.first();
while (myconn.rs.next())
{
int id = myconn.rs_getint("id") + 1;
system.out.print(id);
system.out.println(myconn.rs_getint("id") + myconn.rs_getstring("name"));
//system.out.println('/n' + myconn.rs_gethtmlstring("name"));
//system.out.println(myconn.rs.getstring("name") + myconn.rs_getint(1));
}
}catch(exception e){
system.err.println(e.tostring());
}
}
}
