Http://community.9cbs.net/expert/topic/3517/3517995.xml?temp =.2898371 This is my first Struts application, only for user registration; registered users are deposited in the database. Reference "JSP App Development Detailed" Electronic Industry Press Part I / III
/ ** SQL Server 2000 Tomcat 4.1Struts Jakarta-Struts-1.1editplus * /
// ---- Database script ---- Create Database DBACREATE TABLE TUSER (Uname Varchar (64), Upassword Varchar (64), UAGE INT)
// ---- Tomcat Configuration ----
// ---- ClassPath Settings ---- // Since I use a basic text editor, Struts's JAR file needs to be manually configured to ClassPath.; E: / Struts / Web-INF / CLASSES; E: /struts/web-inf/lib;d:/webset/jdk/lib/dt.jar;d:/webset/jdk/lib/tools.jar;d:/webset/jdk/lib/msbase.jar;d: /Webset/jdk/lib/msqlserver.jar;d:/webset/jdk/lib/msutil.jar;d:/webset/jdk/lib/itextasian.jar;d:/Webset/jdk/lib/jxl.jar; E: /STRUTS/Web-inf/Lib/Struts.jar; E: /STRUTS/Web-inf/lib/commons-beanutils.jar; E: /STRUTS/Web-inf/lib/commons-collections.jar; E : /Struts-Digester.jar; e: /struts/web-inf/lib/commons-fileupload.jar; E: /STRUTS/Web-inf/lib/commons-lang.jar; E: /struts/web-inf/lib/commons-logging.jar; E: /STRUTS/Web-inf/lib/commons-validator.jar
// ---- Struts Configuration ----- E: / Struts / Web-INF / LIB directory 2003-06-29 118, 726 Commons-beanutils.jar2003-06-29 165, 119 Commons-Collectes.jar2003-06-29 109, 096 Commons-Digester.jar2003-06-29 22,379 Commons-fileupload.jar2003-06-29 63,980 Commons-lang.jar2003-06-29 31,605 Commons-logging.jar2003-06-29 46,865 Commons-Validator.jar2003-06-29 498,051 struts.jar [2002-05-03 302, 282 msbase.jar] [2002-05-03 69, 477 mssqlser.jar] [2002-05-03 67, 235 msutil.jar]
E: / struts / web-inf / TLD catalog 2003-06-29 8,868 struts-bean.tld2003-06-29 66,192 struts-html.tld2003-06-29 14,511 struts-logic.tld2003-06-29 64,659 struts- Nested.tld2003-06-29 1,631 struts-template.tld2003-06-29 7,850 struts-tiles.tld // --- Web-inf / web.xml ----
// ---- Web-INF / STRUTS-Config.xml ----
Part II / III / / ---- Class Writing ---- E: / Struts / Web-INF / CLASSES / COM / STRU Directory DBCON.CLASS // Package Basic Database Operation User.class // Basic Getter, setter method Userbean.class // Implement specific business logic (usually the operation of the database), is called UseRaction.class //ActionUserform.class // formy by the Action class
// ---- DBCON.JAVA ---- package com.stru; / ** Basic database operation class * / import java.sql. *; Import java.net. *; Import java.util.StringTokenizer; public Class dbcon {string driverstr = "com.microsoft.jdbc.sqlser.sqlserverdriver"; string dbip = "127.0.0.1"; string dbname = "dba"; string dbuser = "sa"; string dbpwd = "jnxr @) $ "; String errtag =" "; string dburl =" ";
public void setDbIp (String value) {dbIp = value;} public String getDbIp () {return dbIp;} public void setDbName (String value) {dbName = value;} public String getDbName () {return dbName;} public void setDbUser ( String value) {dbuser = value;} public string getdbuser () {return dbuser;} public void setdbpwd (String value) {dbpwd = value;} public string getDbpwd () {return dbpwd;}
public void setErrbz (String value) {errTag = value;} public String getErrbz () {return errTag;} public boolean dbtry () {try {dbUrl = "jdbc: microsoft: sqlserver: //" dbIp ": 1433; DatabaseName = " DBNAME; Class.Forname (driverstr); // Loading Drive Connection CONN = DriverManager.getConnection (DBURL, DBUSER, DBPWD); // Load Database Connection Return True;} Catch (Exception E) {Return False;}}
public String dbTest () {try {dbUrl = "jdbc: microsoft: sqlserver: //" dbIp ": 1433; DatabaseName =" dbName; Class.forName (driverStr); // load drivers Connection conn = DriverManager.getConnection ( DBURL, DBUSER, DBPWD; // Load Database Connection Return "Database Connection OK!";} catCH (Exception E) {Return "error: / n" e.tostring ();}}
public void dbexe (String sqlstr) {Connection conn = null; Statement stmt = null; try {dbUrl = "jdbc: microsoft: sqlserver: //" dbIp ": 1433; DatabaseName =" dbName; Class.forName (driverStr) ; conn = DriverManager.getConnection (dbUrl, dbUser, dbPwd); stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.execute (sqlstr); errTag = "ok";} catch (Exception e) {System .out.println (E.TOString ()); system.out.println (SQLSTR); errtag = "error";} finally {try {if (stmt! = null) stmt.close (); if (conn! = NULL) CONN.CLOSE ();} catch (sqlexception ee) {system.out.println (Ee.tostring ());}}} public resultset dbqry (String SQLSTR) {// Data Source Unat CONNECTION CONN = NULL; Statement stmt = null; ResultSet rs = null; try {dbUrl = "jdbc: microsoft: sqlserver: //" dbIp ": 1433; DatabaseName =" dbName; Class.forName (driverStr); conn = DriverManager.getConnection (dbUrl , dbuser, dbpwd; stmt = conn.createstatement (ResultSet.Type_Scroll_Sensitive, ResultSet.concur_updata; rs = stmt.executeQuery (SQLST r); errtag = "ok";} catch (eXception e) {system.out.println (e.tostring ()); system.out.println (sqlstr); errtag = "error";} return}
Public int = NULL; Statement Stmt = NULL; ResultSet RS = NULL; INT NUM = -1; try {dburl = "JDBC: Microsoft: SQLServer: //" DBIP ": 1433; DatabaseName = " dbName; Class.forName (driverStr); conn = DriverManager.getConnection (dbUrl, dbUser, dbPwd); stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery (sqlstr); if (rs.next ()) {Num = rs.getint (1); errtag = "ok";}} catch (exception e) {system.out.println (e.tostring ()); system.out.println SQLSTR); errtag = "error";} finally {try {if (rs! = null) rs.close (); if (stmt! = null) stmt.close (); if (conn! = null) conn.close ();} Catch (system.out.println (ee.tostring ());}}}}}}}}}}}} // ---- User.java ----
Package com.stru; / ** The most basic getter, setter method * / public class user {public void setname (String Aname) {this.name = aname;} public string getname () {Return this.name;} public void setPassword (String aPassword) {this.password = aPassword;} public String getPassword () {return this.password;} public void setAge (int aAge) {this.age = aAge;} public int getAge () {return this.age }
Public static void main (string [] args) {system.out.println ("current user");}
Private string name; private string password; private int agent;}
Part III / III
// ---- Userbean.java -----
Package com.stru; import java.sql. *; import javax.sql. *; import java.io. *; / ** Implement specific business logic (usually a database operation), is called by Action class; but HttpRequest Non-related * / public class userbean {private dbcon dbcon;
public UserBean () throws Exception {dbcon = new Dbcon ();} public void addUser (User user) throws SQLException {String sql = "insert into Tuser (uname, upassword, uage) values ( '" user.getName () "','" user.getpassword () "" user.getage () ")"; dbcon.dbexe (sql);}} // ---- use.java ---- package com.stru; import javax.servlet.http *;. import org.apache.struts.action *;. / ** ACTION * / public class UserAction extends Action {public ActionForward perform (ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse Response) {Userform f = (userform) form; try {userbean userbean = new userbean (); userbean.adduser (f.getuser ());} catch (exception e) {E.PrintStackTrace ();} request.setttribute ( "User", F.Getuser ()); // return (Mapping.FindForward ("UserCreated"));}}
// ---- Userform.java ---- package com.stru; import javax.servlet.http.httpservletRequest; import org.apache.struts.Action. *;
/ ** FORM * / public class UserForm extends ActionForm {public void setUserName (String aUserName) {user.setName (aUserName);} public String getUserName () {return user.getName ();} public void setUser (User user) { THISUSER = User;} public user getuser () {return this.user;} / ** reset the form * / public void reset (actionmapping mapping, httpservletRequest request) {this.user = new user ();} / * * check the form * / public ActionErrors validate (ActionMapping mapping, HttpServletRequest request) {ActionErrors errors = new ActionErrors ();.. if (user.getName () == null || user.getName () trim () equals ( " ") || user.getPassword (). Trim (). Equals (")) {Errors.Add ("UserInputError", New Actionerror ("ErrorInput: Name / Password");} Return Errors;} private user user = New user ();} // -------- JSP page Writing ---- 2004-11-15 CREATEUSER.JSP // Enter area 2004-11-15 ViewUser.jsp // Execution Back
// ---- CREATEUSER.JSP ----- <% @ Page ContentType = "text / html; charset = GB2312"%> <% @ Taglib URI = "/ struts-logic" prefix = "logic"%>%> <% @ Taglib Uri = "/ Struts-Bean" prefix = "bean"%> <% @ Taglib URI = "/ struts-html" prefix = "html"%>
