当前页面: 开发资料首页 → Java 专题 → Struts入门实例：通讯录

Struts入门实例：通讯录

摘要: Struts入门实例：通讯录

</td> </tr> <tr> <td height="35" valign="top" class="ArticleTeitle">
<table width="741" border="0"> <tr> <td> </td> </tr> </table>
这是一个与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.*;

/**
* DbUtil 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="));
}

}

function TempSave(ElementID) { CommentsPersistDiv.setAttribute("CommentContent",document.getElementById(ElementID).value); CommentsPersistDiv.save("CommentXMLStore"); } function Restore(ElementID) { CommentsPersistDiv.load("CommentXMLStore"); document.getElementById(ElementID).value=CommentsPersistDiv.getAttribute("CommentContent"); } </td> </tr> <tr>

↑返回目录
前一篇: 用strtus制作登陆页面
后一篇: 你的第一个struts应用程序