sql public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
// TODO Auto-generated method stub
AddUserForm addUserForm = (AddUserForm) form;
String password = addUserForm.getPassword();
String username = addUserForm.getUsername();
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://192.168.2.220:3306/test", "test", "test");
Statement stmt = conn.createStatement();
String sql = "select password from usertable where username='"
+ username + "'";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next() != false) {
rs.close();
stmt.close();
conn.close();
System.out.println("user /"" + username
+ "/" is already in using..");
return (mapping.findForward("addfail"));
} else if (rs.next() == false) {
String insertsql = "insert into usertable(username,password) values('"
+ username + "'," + "'" + password + "')";
stmt.execute(insertsql);
rs.close();
stmt.close();
conn.close();
System.out.println("user /"" + username
+ "/" is added ok.....");
return (mapping.findForward("success"));
}
/*
* javax.sql.DataSource ds =
* getDataSource(servletRequest,"dataSource");
*
* Connection conn = ds.getConnection(); Statement
* stmt=conn.createStatement();
*
* String sql= "select password from user where username ='"
* +loginForm.getUsername()+"'"; ResultSet
* rs=stmt.executeQuery(sql);
*
*/
} catch (Throwable e) {
e.printStackTrace();
}
throw new java.lang.UnsupportedOperationException(
"Method $execute() not yet implemented.");
}
}