Struts Operation Database - a simple example

Some basic steps for database programming:

Registration driver

Create a database connection

Execute SQL statement get the result

Some basic classes to use

CONNECTION Class

Statement class and PeparedStatement classes

Resultset class

Need to pay attention

When the database operation, it will appear, pay attention to capture and process.

Use the following code to explain the driver of the database (hereinafter given below is to connect the ODBC database)

String striver = "sun.jdbc.odbc.jdbcodbcdriver"; // Define the URL of the data (name)

String strConnection = "jdbc: odbc: myFirstData"; // user name data access String strConnectUsername = ""; // password for database access String strConnectPassword = ""; Connection conn = null; Statement stmt = null; ResultSet rs = null String SQL_TEMP = "Select * from tablename" try {

Class.forName (strDriver); // Register drive} catch (ClassNotFoundException ex1) {ex1.printStackTrace (); // capture driver registration process anomalies obtained} try {// database connection conn = DriverManager.getConnection (strConnection, strConnectUsername , strConnectPassword); stmt = conn.CreateStatement (); // create a Statement object stmtrs = stmt.executeQuery (sql_temp); // stmt using SQL operations to return a result set rs} catch (SQLException ex2) {ex2.printStackTrace ();

Come an example to explain how? Function Description Write a user login program, the user enters the password, click the "Login" button, find it in the user data sheet, if there is a corresponding record, tell: Hello, welcome you! If there is no user, it will be prompted: the username or password is incorrect, please re-login. Wow, I finally went to write a little person to touch the dog-like program. I used to call the procedure before, it is simply the name of the three-structured structure to deceive people. . .

Create a database: In order to simply use Access to build one, the name of the database is User, set it in ODBC. What, don't know how to set it? Oh, I really don't have a mood to explain with you. Please solve this problem and look down.

Create a data table: useertable

User number Userno text

User password Password text

The department number DEPARTNO text

Fill in a few values

111 111 001

222 222 002

333 333 003 Landing JSP (I am afraid I will tell you how to write such JSP)

Login.jsp

<% @ Page ContentType = "text / html; charset = GB2312"%>

<% @ Taglib Uri = "/ Web-INF / STRUTS-TILES.TLD" prefix = "tiles"%>

<% @ Taglib URI = "/ Web-INF / STRUTS-HTML.TLD" prefix = "html"%>

<% @ Taglib URI = "/ Web-INF / STRUTS-LOGIC.TLD" prefix = "logic"%>

<% @ Taglib Uri = "/ Web-INF / STRUTS-Bean.tld" prefix = "bean"%>