JDBC program using Properties file
JDBC program using Properties file
- In our Previous topic we provided database username and password from our
java program and that is not secure. - Now we will provide database username and password from Properties file.
- Extension of Properties file is .properties and it contain data in
name=value pair. - I have created Properties file like below
java program that read username and password from properties file
and fetch data from database.
and fetch data from database.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 | package com.spy.javaforlearn; import java.io.FileReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; import com.mysql.jdbc.Driver; public class JdbcusingProperty { public static void main(String[] args) { Connection con=null; Statement stmt=null; ResultSet rs=null; try { //1.Load the Driver java.sql.Driver driverref=new Driver(); DriverManager.registerDriver(driverref); //get the db connection via driver String dburl="jdbc:mysql://localhost:3306/test"; FileReader f=new FileReader("E:\\myjdbc.properties"); Properties prop=new Properties(); prop.load(f); con=DriverManager.getConnection(dburl,prop); //issue sql query String query="Select * from Student_detail"; stmt=con.createStatement(); rs=stmt.executeQuery(query); //process result return by mysql query while(rs.next()) { String id=rs.getString("user_id"); String f_name=rs.getString("f_name"); String l_name=rs.getString("l_name"); System.out.println("user_id:"+id); System.out.println("first name:"+f_name); System.out.println("last name:"+l_name); System.out.println("*******************"); } } catch(Exception e) { e.printStackTrace(); } finally { try { if(con!=null) { con.close(); } if(stmt!=null) { stmt.close(); } if(rs!=null) { rs.close(); } } catch(Exception e) { System.out.println("Exception occur"); } } } } output: user_id:1 first name:bhavesh last name:lakhani ******************* user_id:2 first name:vivel last name:patel ******************* user_id:3 first name:abhilash1 last name:shah ******************* |