Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql1: create table if not exists Games(Gamesupc integer, name varchar(10), type varchar(10), release integer, rating varchar(3))
- Exception in thread "main" java.lang.NumberFormatException: For input string: "Sports"
- at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
- at java.lang.Integer.parseInt(Integer.java:580)
- at java.lang.Integer.parseInt(Integer.java:615)
- at LoadGames.main(LoadGames.java:50)
- import java.io.File;
- import java.io.FileNotFoundException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Scanner;
- public class LoadGames {
- public static void main(String[] args) {
- Connection c = null;
- Statement s = null;
- Scanner fromFile = null;
- String sql1 = null, sql2 = null;
- String line = null, name = null, type = null, rating = null;
- String[ ] fields;
- int release = 0;
- try {
- // Define Connection and Statement objects.
- Class.forName("org.sqlite.JDBC");
- c = DriverManager.getConnection("jdbc:sqlite:Games.db");
- s = c.createStatement();
- // Instantiate scanner to read from file.
- fromFile = new Scanner(new File ("Games.csv"));
- // Create Games table.
- sql1 = "create table if not exists " +
- "Games(Gamesupc integer, " +
- "name varchar(10), " +
- "type varchar(10), " +
- "release integer, " +
- "rating varchar(3))";
- System.out.println("sql1: " + sql1);
- s.executeUpdate(sql1);
- // Populate Games table.
- for (int upc = 1001; fromFile.hasNextLine( ); upc++) {
- line = fromFile.nextLine( );
- fields = line.split(",");
- name = fields[0].trim( );
- type = fields[1].trim( );
- release = Integer.parseInt(fields[2].trim( ));
- rating = fields[3].trim();
- sql2 = String.format(
- "insert into Games (Gamesupc, name, type, release, rating) " +
- "values (%d, '%s', '%s', %d, '%s');",
- upc, name, type, release, rating);
- System.out.println(sql2);
- s.executeUpdate(sql2);
- }
- c.close( );
- }
- catch (FileNotFoundException e) {
- System.out.println("File queries.sql not found.");
- System.err.println( e.getClass().getName() +
- ": " + e.getMessage() );
- }
- catch(SQLException e) {
- System.out.println("SQLException.");
- System.err.println( e.getClass().getName() +
- ": " + e.getMessage() );
- }
- catch (ClassNotFoundException e ) {
- System.err.println( e.getClass().getName() +
- ": " + e.getMessage() );
- }
- finally {
- fromFile.close( );
- }
- }
- }
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Scanner;
- public class DisplayGames {
- public static void main(String[] args) {
- Connection c = null;
- Statement s = null;
- ResultSet rs = null;
- int upc = 0, release = 0;
- String sql = null, name = null, type= null, rating = null;
- Scanner fromKeyboard = new Scanner(System.in);
- try {
- // Define Connection and Statement objects.
- Class.forName("org.sqlite.JDBC");
- c = DriverManager.getConnection("jdbc:sqlite:Games.db");
- s = c.createStatement();
- while (upc != -1) {
- // Read id and display corresponding table row.
- System.out.print("Enter Product UPC: ");
- upc = fromKeyboard.nextInt( );
- sql = "select name, type, release, rating from Games " +
- "where Gamesupc = " + upc + ";";
- System.out.println(sql);
- rs = s.executeQuery(sql);
- while (rs.next( )) {
- name = rs.getString("name");
- type = rs.getString("type");
- release = rs.getInt("release");
- rating = rs.getString("rating");
- System.out.println("Name: " + name);
- System.out.println("Type: " + type);
- System.out.println("Release: " + release);
- System.out.println("Rating: " + rating);
- }
- }
- }
- catch(SQLException e) {
- System.out.println("SQLException.");
- System.err.println( e.getClass().getName() +
- ": " + e.getMessage() );
- }
- catch (ClassNotFoundException e ) {
- System.err.println( e.getClass().getName() +
- ": " + e.getMessage() );
- }
- finally {
- fromKeyboard.close( );
- }
- }
- }
Add Comment
Please, Sign In to add comment