Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL and JDBC How to solve this Code: Error column car_date is of type date but expression is of type character varying System.out.print(Please enter the
SQL and JDBC
How to solve this Code: Error column car_date is of type date but expression is of type character varying
System.out.print("Please enter the ID of car: "); genre=in.nextInt(); System.out.print("Please enter the model of car: "); mediaType=in.nextLine(); System.out.print("Please enter the car date: "); releaseDate=in.nextLine(); Connection con = null; ResultSet result=null; PreparedStatement stmt=null; try { Class.forName("org.postgresql.Driver"); //load driver // opening database connection to postgresql server String url = "jdbc:postgresql://localhost/a4"; con = DriverManager.getConnection(url,"postgres", "123"); ll getting Statement object to execute query stmt = con.prepareStatement("INSERT INTO cars(car_id,car_model.car_date)"+ "VALUES (?, ?, ?)'); stmt.setInt(1, carld); stmt.setString(2, carModel) stmt.setDate(3, carDate) result = stmt.execute Query()Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started