站内搜索

[Struts]Struts入门实例：通讯录

这是一个与mysql搭配的Struts程序。有全部源码，入门级的好实例。
一、先用addressgookdb.sql在mysql中建数据库和表。

DROP DATABASE IF EXISTS ADDRESSBOOKSAMPLE;
CREATE DATABASE ADDRESSBOOKSAMPLE;
USE ADDRESSBOOKSAMPLE;
CREATE TABLE ADDRESSBOOK_TABLE(ID INT(4) AUTO_INCREMENT NOT NULL PRIMARY KEY,NAME VARCHAR(25),
PHONE VARCHAR(10), ADDRESS VARCHAR(50));
INSERT INTO ADDRESSBOOK_TABLE VALUES(1,'Wang',?','Beijing,Haidian');
INSERT INTO ADDRESSBOOK_TABLE VALUES(2,'Zhang',?','Shanghai,Pudong');
INSERT INTO ADDRESSBOOK_TABLE VALUES(3,'Cheng',?','Tianjing');
INSERT INTO ADDRESSBOOK_TABLE VALUES(4,'Zhao',?','Hainan');
INSERT INTO ADDRESSBOOK_TABLE VALUES(5,'Cao',?','Heibei');

二、再将addressbook目录复制到Tomcat下的webapps目录下即可。 (struts的库文件请自己加入）

附：连接数据库的工具类

package addressbook.model;

import java.io.*;
import java.sql.*;

/**
* <strong>DbUtil</strong> is a utility class to create
* a connection to our sample database.
*/
public class DbUtil {
static String driverName="com.mysql.jdbc.Driver";
static String dbUrl="jdbc:mysql://";

public DbUtil() {

}

public static java.sql.Connection connectToDb(String hostName, String databaseName)throws Exception
{
        Connection connection=null;
        String connName = dbUrl + hostName+":3306"+"/"+databaseName;
       Class.forName(driverName).newInstance();
        connection = DriverManager.getConnection(connName);
        return connection;
}

public static java.sql.Connection connectToDb(String databaseName)throws Exception{
return(connectToDb("localhost", databaseName));
}

public static java.sql.Connection connectToDb()throws Exception{
return(connectToDb("localhost", "addressbooksample?user=root;password="));
}

}

[wangjy17908]

添加时间：2006-12-01