java databases connectivity

Question

Hello friends i want to know about the jdbc how i can valid a login page ? thanks

Sazid Mauhammad · Answer

hi friend first of all you should create database in mysql/MS-access/sql or oracle and after that you should write coding in .java file that i add in jar file you can see this one import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DB { /** * @param args */ public static void main(String[] args) { try { String name="sonal"; String pass="asd"; Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root","admin"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select password from login where userName ='"+name+"' "); if(rs.next()) { String temp_pass=rs.getString(1); if(temp_pass.endsWith(pass)) { System.out.println("Welcome "+name+" password is - "+pass); } else { System.out.println("Wrong Password"); } } else { System.out.println("Invalid User"); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } this coding is use only for login database in mysql

umme salma · Answer

Create a html file which take user name and password .. when user press submit it should link to the java program which takes user name and password which entered into the html page.. connect it to database and verify it

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/uploadfile/satyapriyanayak/learning-jdbc-java-database-connectivity/default.aspx http://www.c-sharpcorner.com/UploadFile/73d82f/database-connectivity-and-validation-of-data-from-oracle-dat/

java databases connectivity

Answers (3)