userbean.java~20~

这是本人编辑运行过的一个极好的学习struts的入门例子,执行了添加用户的过程. JBuilder7编辑环境 需要打包后在jboss5/postgresql环境运行 里面的JSP/bean/we

package com.mainet.Tony.strutsadduser;

import java.sql.*;

//import javax.sql.*;
//import com.mainet.Tony.strutsadduser.User;
/**
 * <p>Description: business logic, used by Action class</p>
 * <p>Copyright: Copyright (c) 07/2005</p>
 * <p>Company: Mainet</p>
 * @author Tony , guoxiaotao
 * @version 1.0
 */

public class UserBean {
  private Connection  conn;
  public UserBean()  throws Exception
  {
    try{
         Class.forName("org.postgresql.Driver").newInstance();
         this.conn = DriverManager.getConnection("jdbc:postgresql://192.168.10.254/loginTest","postgres","");
        }catch(Exception e){
           System.out.print("conn error");
           e.printStackTrace();
        }
  }

  /**
   * add a user
  */
 public void addUser(User user)  throws  Exception
 {
   Statement stmt = conn.createStatement();
   stmt.executeUpdate("insert into StrutsUser values('"+user.getUserName()+"','"+user.getPassword()+"',"+user.getAge()+")");
// stmt.executeUpdate("  insert into StrutsUser values( 'cat' ,'123',3)  ");
 }
 public static void main(String[] args) {   //Test codes
   try
   {
   UserBean bean = new UserBean();
   User usert = new User();
   usert.setUserName("cat");
   usert.setPassword("123");
   usert.setAge(3);
   bean.addUser(usert);
   }catch(Exception e)
   {}
  }
}