admin管理员组文章数量:1289867
I want to connect to a database depending on the data enter in a .jsp form. I do not know how to connect to database in a Javascript.
My code as follows:
<%@ page contentType="text/html; charset=iso-8859-1" language="java" %>
<html>
<head>
<script>
function validateForm()
{
if(document.frm.username.value=="srinu")
{
// conect database here
}
else
{
alert("wrong input");
document.frm.pwd.focus();
return false;
}
}
Body here, i want to connect database based on the details entered in the body.
<body>
<form name="frm" method="get" action="validateInput.jsp" onSubmit="return validateForm()">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="22%"> </td>
<td width="78%"> </td>
</tr>
<tr>
<td>UserName </td>
<td><input type="text" name="username" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="Submit"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>
I want to connect to a database depending on the data enter in a .jsp form. I do not know how to connect to database in a Javascript.
My code as follows:
<%@ page contentType="text/html; charset=iso-8859-1" language="java" %>
<html>
<head>
<script>
function validateForm()
{
if(document.frm.username.value=="srinu")
{
// conect database here
}
else
{
alert("wrong input");
document.frm.pwd.focus();
return false;
}
}
Body here, i want to connect database based on the details entered in the body.
<body>
<form name="frm" method="get" action="validateInput.jsp" onSubmit="return validateForm()">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="22%"> </td>
<td width="78%"> </td>
</tr>
<tr>
<td>UserName </td>
<td><input type="text" name="username" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="Submit"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>
- 1 You should not do this validation inside your javascript. It is not a good practice. You pass this values to servlet and do validate there. – Vinoth Krishnan Commented Oct 10, 2013 at 8:41
- can you give some simple example here ? – Vasu Commented Oct 10, 2013 at 8:42
- You can create a database connection in JSP as same as Java. But its not a good practice you need to create connection once and carry that connection through out the application with help of JSP session. – Srinath Thota Commented Oct 10, 2013 at 9:29
2 Answers
Reset to default 4You can not connect to database from client side. JavaScript run on a browser which has a very strict security restrictions. And keeping any connection string on JavaScript is not a good practice at all . Don't keep any sensitive things on client side. Make a call to server side validate and work on that.
function validateForm()
{
if(document.frm.username.value=="srinu")
{
$.ajax({
type: 'GET',
url: 'validateuser?username=document.frm.username.value' + '&Pwd=' + document.frm.userpassword.value,
success: function (data) {
if (data=='Y')
alert('Valid User');
else
alert('Invalid User');
}, cache: false,
error: function (xhr, ajaxOptions, thrownError) {
alert('failed.');
}
});
}
}
@user2773010 Glad to help, not for entire project. You need to think about how to implement the following snippit as per your requirements.
String userName = request.getParameter("user");
String password = request.getParameter("pass");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
con = DriverManager.getConnection("jdbc:odbc:library", "administrator", "");
stat = con.createStatement();
System.out.println("user Connected");
rs = stat.executeQuery("Select * FROM User_Master");
while(rs.next())
{
String un = rs.getString(5);
String Pwd = rs.getString(6);
if(un.equals(userName) && Pwd.equals(password))
{
session.setAttribute("username",un);
String des = "http://localhost:8080/Final_Review/review/homeuser.jsp";
response.sendRedirect(response.encodeRedirectURL(des));
break;
}
/* else
{
response.sendRedirect(response.encodeRedirectURL("http://localhost:8080/Final_Review/review/ErrorPage.jsp"));
}*/
}
stat.close();
con.close();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException se)
{
System.out.println(se);
}
}
本文标签： htmlHow to write a database connection in JavascriptStack Overflow
版权声明：本文标题：html - How to write a database connection in Javascript? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741433269a2378487.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论