Dinesh on Java

CREATE TABLE users (
  User_ID VARCHAR(10) NOT NULL,
  UserName VARCHAR(10) NOT NULL,
  PASSWORD VARCHAR(10) NOT NULL,
  PRIMARY KEY (User_ID)
  ) 


INSERT INTO `DOJDB`.`users` 
 (`User_ID`, 
 `UserName`, 
 `PASSWORD`
 )
 VALUES
 ('DOJ01', 
 'Dinesh', 
 'Sweety'
 );

package com.dineshonjava.struts2.login;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.opensymphony.xwork2.ActionSupport;

/**
 * @author Dinesh Rajput
 *
 */
@SuppressWarnings("serial")
public class LoginAction  extends ActionSupport{
 private String username;
    private String password;
    private String userid;
    
 public String execute() {
  String ret = ERROR;
       Connection conn = null;

       try {
          String URL = "jdbc:mysql://localhost:3306/DOJDB";
          Class.forName("com.mysql.jdbc.Driver");
          conn = DriverManager.getConnection(URL, "root", "root");
          String sql = "SELECT name FROM user WHERE";
          sql+=" userName = ? AND password = ?";
          PreparedStatement ps = conn.prepareStatement(sql);
          ps.setString(1, username);
          ps.setString(2, password);
          ResultSet rs = ps.executeQuery();

          while (rs.next()) {
           username = rs.getString(1);
           ret = SUCCESS;
          }
       } catch (Exception e) {
        addActionError(getText("error.login"));  
          ret = ERROR;
       } finally {
          if (conn != null) {
             try {
                conn.close();
             } catch (Exception e) {
             }
          }
       }
       return ret;
    }

 public String getUsername() {
  return username;
 }

 public void setUsername(String username) {
  this.username = username;
 }

 public String getPassword() {
  return password;
 }

 public void setPassword(String password) {
  this.password = password;
 }

 public String getUserid() {
  return userid;
 }

 public void setUserid(String userid) {
  this.userid = userid;
 }
 
}