-
Notifications
You must be signed in to change notification settings - Fork 0
/
Route.java
53 lines (42 loc) · 1.03 KB
/
Route.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
package ticketmanagement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
public class Route {
private String routeName;
private short totalNumberOfSeats;
public void setRoute(String r)
{
routeName = r;
}
public String getRoute()
{
return routeName;
}
public void setTotalNumberOfSeats(short seats)
{
totalNumberOfSeats = seats;
}
public short getTotalNumberOfSeats()
{
return totalNumberOfSeats;
}
protected void insertRoute()
{
try
{
//open connection to DB
Connection con = DatabaseInteraction.connect();
Statement statement = con.createStatement();
statement.setQueryTimeout(30); // set timeout to 30 sec.
//insert route info to DB
statement.executeUpdate("Insert INTO routes (routeName,totalNumberOfSeats) Values ( '" + routeName + "', " + totalNumberOfSeats + ")");
//close connection to DB
DatabaseInteraction.disconnect(con);
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}