Cricket Match Example Program With JDBC by Programing Kid
CRICKET MATCH WITH JDBC
import java.sql.*;
import java.util.Random;
import java.util.Scanner;
public class cricketmatchjdbc {
public static void main(String[] args) {
// Creating Connection
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1:3306/cricket";
String user = "root";
String pass = "2010";
Connection con = DriverManager.getConnection(url, user, pass);
cricket(con);
} catch (Exception e) {
e.printStackTrace();
}
}
public static void cricket(Connection con) {
String bat;
Scanner scan = new Scanner(System.in);
System.out.println();
System.out.println("1 to Continue 2 to Close 3 to Previous Match Score");
int cc = scan.nextInt();
if (cc == 2) {
} else {
if (cc == 3) {
String q1 = "show tables;";
try {
Statement st = con.createStatement();
ResultSet rt = st.executeQuery(q1);
while (rt.next()) {
System.out.println(rt.getString(1));
System.out.println();
}
System.out.println("Which Match you select like upvsmp");
String match1 = scan.nextLine();
String match = scan.nextLine();
String q1234 = "SELECT * FROM " + match;
ResultSet rt2 = st.executeQuery(q1234);
while (rt2.next()) {
int fg = 0;
fg = fg + rt2.getInt("run");
System.out.println("Name - " + rt2.getString("name") + " " + "Run - " + rt2.getInt("run"));
System.out.println();
}
} catch (SQLException e) {
System.out.println("This Match Not Found");
cricket(con);
}
} else {
System.out.println();
System.out.println("Welcome to Cricket game");
System.out.println("Which 1 team name");
String fteam1 = scan.nextLine();
String fteam = scan.nextLine();
System.out.println("Which 2 team name");
String steam = scan.nextLine();
String q123 = "create table " + fteam + "vs" + steam + "(name varchar(200),run int(200));";
try {
Statement st = con.createStatement();
st.executeUpdate(q123);
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("How many over in this match");
int over = scan.nextInt();
System.out.println("");
Random ran = new Random();
System.out.println("Tossing ");
int ran1 = ran.nextInt(0, 2);
if (ran1 == 1) {
System.out.println(fteam + " Win toss");
System.out.println(" What They Chose");
System.out.println("Deciding");
int ran2 = ran.nextInt(0, 2);
if (ran2 == 1) {
System.out.println("They Chose Batting");
bat = fteam;
} else {
System.out.println("They Chose Bolwing");
bat = steam;
}
} else {
System.out.println(steam + " Win toss");
System.out.println();
System.out.println("What They Chose");
System.out.println();
System.out.println("Deciding");
int ran2 = ran.nextInt(1, 2);
if (ran2 == 1) {
System.out.println();
System.out.println("They Chose Batting");
bat = steam;
} else {
System.out.println();
System.out.println("They Chose Bolwing");
bat = fteam;
}
}
int ball = 6 * over;
int frun = 0;
int srun = 0;
for (int i = 1; i <= ball; i++) {
int run = ran.nextInt(1, 6);
if (bat.equals(fteam)) {
frun = frun + run;
} else {
srun = srun + run;
}
System.out.println(bat + " run in this ball " + run);
try {
String q12 = "INSERT INTO " + fteam + "vs" + steam + "(name,run) VALUES(?,?);";
PreparedStatement pst = con.prepareStatement(q12);
pst.setString(1, bat);
pst.setInt(2, run);
pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (bat.equals(fteam)) {
bat = steam;
} else {
bat = fteam;
}
for (int i = 1; i <= ball; i++) {
int run = ran.nextInt(1, 6);
if (bat.equals(fteam)) {
frun = frun + run;
} else {
srun = srun + run;
}
System.out.println(bat + " run in this ball " + run);
try {
Statement sa = con.createStatement();
sa.execute("use cricket");
String q12 = "INSERT INTO " + fteam + "vs" + steam + "(name,run) VALUES(?,?);";
PreparedStatement pst = con.prepareStatement(q12);
pst.setString(1, bat);
pst.setInt(2, run);
pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (frun < srun) {
System.out.println(fteam + "win match");
} else {
System.out.println(steam + "win match");
}
cricket(con);
}
}
}
}
Comments
Post a Comment