How to make connection using jdbc,mysql,java source code

How to make connection using jdbc,mysql,java source code

import java.sql.*;
import java.util.*;
public class FirstActivity
{
	public static void main (String[] args) 
			{
				Scanner scan=new Scanner(System.in);
				System.out.println ("Enter the Name");
				String name=scan.nextLine();
				System.out.println ("Enter the Salary");
				double salary=scan.nextDouble();
				try
					{
						Class.forName("com.mysql.cj.jdbc.Driver");
						Connection cn=DriverManager.getConnection("jdbc:mysql://127.0.0.1/university?autoReconnect=true&useSSL=false","root","root");
						if(!cn.isClosed())
						{
							System.out.println ("database server connected");
							PreparedStatement ps=cn.prepareStatement("insert into employee(name,salary)values(?,?)");
							ps.setString(1,name);
							ps.setDouble(2,salary);
							int a=ps.executeUpdate();
								if(a>0)
								{
									System.out.println ("record inserted");
								}
						}
						cn.close();
					
				    }
				catch(Exception e)
				{
					System.out.println ("Error is :"+e.getMessage());
					
				}    
			}
}

Additional Reading

you can read more articles like this here.

READ MORE

Leave a Reply

Your email address will not be published. Required fields are marked *