当前页面: 开发资料首页 → 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应用程序