QuestionAsk Questions?
Martin
Using javabeans to connect mySQL database on a jsp page
1 Answer(s) 5 years and 3 months ago
Posted in : JSP-Interview Questions
1 Answer(s) 5 years and 3 months ago
Posted in : JSP-Interview Questions
Hi, Am doing my project and I don't know how to connect a jsp page to a mySQl database...; Connecting a JSP page to MYSQL Database using JavaBean File Name: beancode.java
View Answers
March 18, 2008 at 8:09 PM
Connecting a JSP page to MYSQL Database using JavaBean
File Name: beancode.java
import java.sql.*;
public class beancode {
private String username;
private String password;
private Connection con = null;
private ResultSet rs = null;
private PreparedStatement st = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
public beancode(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(url+db,"root","root");
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
public void setusername(String userId){
username = userId;
}
public String getusername(){
return (username);
}
public void setpassword(String pass){
password = pass;
}
public String getpassword(){
return (password);
}
public void insert(){
try{
String s1="insert into userlogin values('"+username+"','"+password+"')";
st = con.prepareStatement(s1);
st.executeUpdate();
st.clearParameters();
st.close();
}
catch(Exception m){
}
}
}
File Name: DataBase.jsp
<%@ page language="Java" import="java.sql.*" %>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head>
</head>
<body>
<form name="form1" action="beancode" method="POST">
UserName: <input type="text" name ="userId"> <br>
Password: <input type="password" name ="pass"> <br>
<input type = "submit" value="Submit">
<jsp:useBean id="beancode" class="beancode">
<jsp:setProperty name="beancode" property="userId"/>
<jsp:setProperty name="beancode" property="pass"/>
</jsp:useBean>
</form>
</body>
</html>
Database connectivity using JavaBean Example Code
File Name: beancode.java
import java.sql.*;
public class beancode {
private String username;
private String password;
private Connection con = null;
private ResultSet rs = null;
private PreparedStatement st = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
public beancode(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(url+db,"root","root");
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
public void setusername(String userId){
username = userId;
}
public String getusername(){
return (username);
}
public void setpassword(String pass){
password = pass;
}
public String getpassword(){
return (password);
}
public void insert(){
try{
String s1="insert into userlogin values('"+username+"','"+password+"')";
st = con.prepareStatement(s1);
st.executeUpdate();
st.clearParameters();
st.close();
}
catch(Exception m){
}
}
}
File Name: DataBase.jsp
<%@ page language="Java" import="java.sql.*" %>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head>
</head>
<body>
<form name="form1" action="beancode" method="POST">
UserName: <input type="text" name ="userId"> <br>
Password: <input type="password" name ="pass"> <br>
<input type = "submit" value="Submit">
<jsp:useBean id="beancode" class="beancode">
<jsp:setProperty name="beancode" property="userId"/>
<jsp:setProperty name="beancode" property="pass"/>
</jsp:useBean>
</form>
</body>
</html>
Database connectivity using JavaBean Example Code
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
