Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Development For Dummies

Authors: Allen G. Taylor

1st Edition

978-0764507526

More Books

Students also viewed these Databases questions

Question

Be familiar with the integrative servicescape model.

Answered: 1 week ago

Question

Determine the roles of spatial layout and functionality.

Answered: 1 week ago