Why insertion can not be performed in JDBC ?

[vinoth vino]

Helo programmers, I m new to JDBC concepts and now i came to understand a little bit of JDBC such as connecting sql with java(jdbc) , creating table using jdbc application... This is what i learned now I m facing difficulty with insertion of values in database. I've created database "emp4" it consists of 3 columns(id,gmail,yahoo) Now i m trying to insert a set of values to emp4 but i didn't get any exception..... It just showing only the sysout in the console. Help me !!!

package demojdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;

public class MysqlCon {
	private static final String DB_Driver = "com.mysql.jdbc.Driver";
	private static final String DB_Connection = "jdbc:mysql://localhost:3306/vinoth";
	private static final String DB_User = "root";
	private static final String DB_Password = "vino";
	
	public static void main(String args[]){
		
		try{

			updateDBTable();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	private static void updateDBTable()throws SQLException{
		Connection dbConnection = null;
		Statement stmt = null;
		String query = "INSERT INTO EMP4" +  " (id, gmail ,yahoo) " + " VALUES" + "(1,'vinothvino','vinothvinoooo')";
		
		try{
			dbConnection = getDBConnection();
			stmt = dbConnection.createStatement();
			
			//Showing the query into console
			System.out.println(query);
			int rows = stmt.executeUpdate(query);
			System.out.println("Values inserted Successfully");
		    System.out.println(rows+"Rows Affected");
			
			
		}catch (SQLException e) {
			e.getMessage();
		} finally {

			if (stmt != null) {
				stmt.close();
			}

			if (dbConnection != null) {
				dbConnection.close();
			}

		}
	}
	private static Connection getDBConnection(){
		Connection dbConnection = null;
		
		try{
			
			Class.forName(DB_Driver);
			
		}catch(ClassNotFoundException e){
			System.out.println("Please check the driver location properly"+e.getMessage());
		}
		
		try{
			
			dbConnection = DriverManager.getConnection(DB_Connection,DB_User,DB_Password);
			//return dbConnection;
			
		}catch(SQLException e){
			e.printStackTrace();
		}
	return dbConnection;
  }
}

OUTPUT
INSERT INTO EMP4 (id, gmail ,yahoo) VALUES(1,'vinothvino','vinothvinoooo')

[Henry Wong]

vinoth vino wrote:Now i m trying to insert a set of values to emp4 but i didn't get any exception..... It just showing only the sysout in the console. Help me !!!

Actually, I think you did get an exception. There is one "catch" statement in your code, that doesn't print anything -- and it is likely, it is not showing anything because that is the code path that is taken.

Henry