i would like to ask how to connect Java program in MySQL, help me please! and can you give me a demo just to show the records on Database, thanks in advance!
2
-
possible duplicate of Java connectivity with MySQLR D– R D2014-06-30 09:47:58 +00:00Commented Jun 30, 2014 at 9:47
-
@RajavelD i cant understand that postuser3789690– user37896902014-06-30 09:57:35 +00:00Commented Jun 30, 2014 at 9:57
Add a comment
|
1 Answer
the 127.0.0.1:3306 is depends what is the settings of your database
make sure you add the MySQL JDBC Driver in your Libraries
then try this code..
try{
Class.forName("com.mysql.jdbc.Driver"); // to set the driver
Connection connect = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306", "<Database username>", "<Database password>"); // connect to database
Statement st = connect.createStatement();
Resultset rs = st.executeQuery( "SELECT * FROM <tablename>" );
while( rs.next() ){
System.out.print( rs.getString(1) );
}
}
catch( Exception e ){
System.out.print( e );
}