java+tomcat+struts2+mysql+myeclipse

zyc8211

　　MyEclipse配置Tomcat(图解) :http://shz2008bj.iteye.com/blog/166721%20
　　MyEclipse开发web项目(jsp+Servlet):http://blog.sina.com.cn/s/blog_628cc2b70100jrpa.html%20
　　MyEclipse开发web项目(jsp+Servlet):http://blog.sina.com.cn/s/blog_628cc2b70100p5ip.html
　　struts2 框架下MyEclipse编写HelloWorld程序:http://blog.sina.com.cn/s/blog_628cc2b70100p7zg.html%20
　　使用Struts2开发Java Web应用程序（目录） ：http://blog.iyunv.com/struts2/article/details/1721752
　　Maven起步-教你开始使用Maven：http://www.blogjava.net/i369/articles/86037.html
　　MyEclipse连接MySQL的方法  :http://blog.163.com/w375257253@126/blog/static/17048785520105365416661/
　　myeclipse安装在eclipse: http://jinguo.iteye.com/blog/378080
　　Eclipse中添加MyEclipse插件:http://developer.iyunv.com/art/200906/130176.htm
　　个人心得：
　　调用http://xujiaxuan-pc:8080/struts2_demo/login.action 可以直接被拦截,并被转发到jsp界面
　　成功例子：java案例教程的3章+myeclipse
　　注意要点：
　　1.原来是配置文件struts.xml应该放在src下。同时web.xml放在webroot下
　　2.eclipse或myeclipse调试没有source code 可能是每个类都继承自object有些没办法看到具体的初始化。继续f5就好了
　　步骤：
　　(1)myeclipse10
　　myeclipse破解参考网址：http://blog.iyunv.com/ll136078/article/details/7197809
　　myeclipse10版本的下载:
　　http://downloads.myeclipseide.com/downloads/products/eworkbench/indigo/installers/myeclipse-10.0-offline-installer-windows.exe
　　破解补丁以及下载地址：http://pan.baidu.com/share/link?shareid=165650&uk=1678594189
　　注意（要在myeclipse中添加tomcat）
　　(2)mysql 官方网址：http://www.mysql.com
　　mysql驱动程序：http://pan.baidu.com/share/link?shareid=165653&uk=1678594189
　　1.正常安装
　　2.关于mysql的使用：直接点击MYSQL->MySQL Server 5.5->mysql 5.5 command line client
　　3.输入密码 （默认的用户名为root） 或者
　　（开始，运行，cmd [ ,cd  mysql安装目录/bin ],  mysql -u userName -p Password）
　　mysql -h110.110.110.110 -uroot -pabcd123       // 远程登录 （登入前，服务器要先给客户端登入权限）
　　(注:u与root可以不用加空格，其它也一样)
　　4.驱动直接放到jre所在的目录 然后添加进classpath
　　(3)struts2官方网址：http://struts.apache.org/download.cgi#struts2211
　　书籍推荐：《java高级编程框架应用开发案例教程》(含code+ppt)：
　　http://pan.baidu.com/share/link?shareid=165674&uk=1678594189
　　myeclipse->facets->选java版本修改为1.5或其他的>
　　只需将需要struts2的项目的lib中添加stuts2中的lib下的相应jar包不要全部添加
　　例子：
　　文件结构

　　mysql:


View Code


create database acesys;
use acesys;
create table Usr(
id int  primary key,
username nvarchar(50),
password nvarchar(50),
fullname nvarchar(50),
title nvarchar(50),
companyname nvarchar(50),
companyaddress nvarchar(50),
city nvarchar(50),
job nvarchar(50),
email nvarchar(50),
country nvarchar(50),
zip nvarchar(50),
tel nvarchar(50),
superuser nvarchar(50),
delsoft nvarchar(50),
note nvarchar(50))insert into Usr values (4,"1","1","1","1","1","1","1","1","1","1","1","1","p","1","1");
　　struts.xml:


View Code







/registUsrWelcome.jsp
/registUsrWelcome.jsp
/adminWelcome.jsp
/login.jsp



　　web.xml


View Code




Struts 2.0

struts2      
org.apache.struts2.dispatcher.FilterDispatcher


struts2
/*


index.jsp


　　DBConn


View Code


package com.ascent.struts2.anli;
import java.sql.*;
public class DBConn {
public static Connection getConn()
{
Connection con=null;
try
{
//Class。forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/acesys";
String user="root";
String password="root";
con=DriverManager.getConnection(url,user,password);
}
catch(ClassNotFoundException e){
System.out.println("---找不到到驱动器");
}
catch (SQLException e)
{
System.out.println("获得数据库连接失败");
}
return con;
}
public static void dbClose(Connection con,Statement st,ResultSet rs){
try{
if(rs!=null)
{
rs.close();
rs=null;
}
if(st!=null){
st.close();
st=null;
}
if(con!=null)
{
con.close();
con=null;}
}catch(SQLException e){
e.printStackTrace();
}
}
}
　　UsrDAO


View Code


package com.ascent.struts2.anli;
import java.util.ArrayList;
import java.util.List;
import com.ascent.struts2.po.Usr;
import java.sql.*;
public class UsrDAO {
private Connection con;
private PreparedStatement ps;
private ResultSet rs;
public Usr checkUsr(String username,String password){
Usr u=null;
String sql="select * from Usr";
try{
con=DBConn.getConn();
ps=con.prepareStatement(sql);
//ps.setString(1, username);
//ps.setString(2,password);
rs=ps.executeQuery();
if(rs.next())
{
u=new Usr();
u.setId(rs.getInt("id"));
u.setUsername(rs.getString("username"));
u.setEmail(rs.getString("email"));
u.setTel(rs.getString("tel"));
u.setSuperuser(rs.getString("superuser"));
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally{
DBConn.dbClose(con,ps,rs);
}
return u;
}
}
　　Usr


View Code


package com.ascent.struts2.po;
/**
* Usr entity. @author MyEclipse Persistence Tools
*/
public class Usr implements java.io.Serializable {
// Fields
private int id;
private String username;
private String password;
private String fullname;
private String title;
private String companyname;
private String companyaddress;
private String city;
private String job;
private String tel;
private String email;
private String country;
private String zip;
private String superuser;
private String delsoft;
private String note;
// Constructors
/** default constructor */
public Usr() {
}
/** full constructor */
public Usr(String username, String password, String fullname, String title,
String companyname, String companyaddress, String city, String job,
String tel, String email, String country, String zip,
String superuser, String delsoft, String note) {
this.username = username;
this.password = password;
this.fullname = fullname;
this.title = title;
this.companyname = companyname;
this.companyaddress = companyaddress;
this.city = city;
this.job = job;
this.tel = tel;
this.email = email;
this.country = country;
this.zip = zip;
this.superuser = superuser;
this.delsoft = delsoft;
this.note = note;
}
// Property accessors
public int getId() {
return this.id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return this.username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return this.password;
}
public void setPassword(String password) {
this.password = password;
}
public String getFullname() {
return this.fullname;
}
public void setFullname(String fullname) {
this.fullname = fullname;
}
public String getTitle() {
return this.title;
}
public void setTitle(String title) {
this.title = title;
}
public String getCompanyname() {
return this.companyname;
}
public void setCompanyname(String companyname) {
this.companyname = companyname;
}
public String getCompanyaddress() {
return this.companyaddress;
}
public void setCompanyaddress(String companyaddress) {
this.companyaddress = companyaddress;
}
public String getCity() {
return this.city;
}
public void setCity(String city) {
this.city = city;
}
public String getJob() {
return this.job;
}
public void setJob(String job) {
this.job = job;
}
public String getTel() {
return this.tel;
}
public void setTel(String tel) {
this.tel = tel;
}
public String getEmail() {
return this.email;
}
public void setEmail(String email) {
this.email = email;
}
public String getCountry() {
return this.country;
}
public void setCountry(String country) {
this.country = country;
}
public String getZip() {
return this.zip;
}
public void setZip(String zip) {
this.zip = zip;
}
public String getSuperuser() {
return this.superuser;
}
public void setSuperuser(String superuser) {
this.superuser = superuser;
}
public String getDelsoft() {
return this.delsoft;
}
public void setDelsoft(String delsoft) {
this.delsoft = delsoft;
}
public String getNote() {
return this.note;
}
public void setNote(String note) {
this.note = note;
}
}
　　login.jsp


View Code








MY JSP 'LOGIN.JSP'STARTING PAGE


   





用户名：
密码：




　　index.jsp


View Code








My JSP 'index.jsp' starting page


   





This is my JSP page.


　　regisUsrWelcome.jsp


View Code








My JSP 'welcome.jsp' starting page


   





regisusr welcome


　　adminWelcome.jsp


View Code








My JSP 'adminWelcome.jsp' starting page


   





admin welcome


　　error.jsp


View Code








My JSP 'error.jsp' starting page


   





Struts2Demo
登陆失败！


　　
运行结果：

　　修改成下面的网址后显示为：

　　输入用户名以及密码后：

　　项目地址：http://pan.baidu.com/share/link?shareid=165680&uk=1678594189