Connect to database using jsf
Solution 1
To get connected to mysql:
public void open() {
try {
String databaseName = "custom";
String userName = "root";
String password = "welcome";
//
String url = "jdbc:mysql://localhost/" + databaseName;
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(url, userName, password);
} catch (Exception e) {
System.out.println("Not able to connect");
}
}
In this case there is nothing to change in web.xml.But you to add this in pom.xml
<dependency>
<groupId>groupId = mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
This was working successfully.
Solution 2
Here is a very good tutorial on how to use DAO with JSF in the best way:
http://balusc.blogspot.com/2008/07/dao-tutorial-use-in-jsf.html
If you are using JSF, that website can be a good place to find solutions for common problems. There are great and complete examples.
Anyway, JSF is a framework that manages the view and the controller layers. For the model layer and the access to a database there are not big difference if you use JSF or any other java web framework that manages the view/controller part of your application.
Warrior
I am a software engineer.I have to learn lot in this field.
Updated on June 16, 2022Comments
-
Warrior almost 2 years
How do I connect to the database(MYSQL) in connection bean using JSF to retrieve its contents. Also please let me know how do I configure the web.xml file?
-
Warrior over 15 yearsthe query was about jsf and sql.yours example is irrelevant to query.
-
Kalle Richter about 6 yearsThe link is dead.