private void submitButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_submitButtonActionPerformed
// TODO add your handling code here:
Connection con = FrameLogin.getConnect();
String SQLInsert =
"INSERT INTO `2761DB`.`Persons` (`FirstName`, `LastName`, `CellPhoneNo`, `HomePhoneNo`, "
+ "`SchoolId`, `Graduation Year`, `Gender`) VALUES ('"
+ firstName.getText()
+ "', '"
+ lastName.getText()
+ "', '"
+ cellPhone.getText()
+ "', '"
+ homePhone.getText()
+ "', '"
+ studentId.getText()
+ "', '"
+ gradYear.getText()
+ "', '"
+ (String) (gender.getSelectedItem())
+ "');";
String SQLUpdate =
"UPDATE `2761DB`.`Persons` SET `FirstName` = '"
+ firstName.getText()
+ "', `LastName` = '"
+ lastName.getText()
+ "', `CellPhoneNo` = ' "
+ cellPhone.getText()
+ "', `HomePhoneNo` = '"
+ homePhone.getText()
+ "', `Graduation Year` = '"
+ gradYear.getText()
+ "', `Gender` = '"
+ (String) (gender.getSelectedItem())
+ "' WHERE `PersonId` = '"
+ Id
+ "';";
// UPDATE `2761DB`.`Persons` SET `FirstName`='Robbie', `LastName`='Tacescu', `CellPhoneNo`='',
// `HomePhoneNo`='559300', `SchoolId`='15648916', `Graduation Year`='6545', `Gender`='males'
// WHERE
// `PersonId`='42';
try {
if (isEdit) {
Statement stmt = con.createStatement();
// System.out.println(SQLUpdate);
stmt.executeUpdate(SQLUpdate);
} else {
Statement stmt = con.createStatement();
// System.out.println(SQLInsert);
stmt.executeUpdate(SQLInsert);
}
} catch (SQLException err) {
MessageBox.infoBox(err.toString(), "Error in AddUserForm submitButton");
}
FrameLogin.closeConnect();
this.dispose();
} // GEN-LAST:event_submitButtonActionPerformed
public void connect() {
try {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/root", "root", "");
statement = connection.createStatement();
statement1 = connection.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "JavaError:Not Connect");
}
}
private void ListValueChanged(
javax.swing.event.ListSelectionEvent evt) { // GEN-FIRST:event_ListValueChanged
// TODO add your handling code here:
// String part=partno.getText();
try {
String sql =
"SELECT TYPE,ITEM_NAME,QUANTITY,MRP FROM MOTORS WHERE ITEM_NAME='"
+ List.getSelectedValue()
+ "'";
Class.forName("com.mysql.jdbc.Driver");
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
partno.setText(rs.getString("TYPE"));
name.setText(rs.getString("ITEM_NAME"));
qty.setText(rs.getString("QUANTITY"));
rate.setText(rs.getString("MRP"));
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.toString());
}
} // GEN-LAST:event_ListValueChanged
private void isEdit(Boolean isEdit) {
if (isEdit) {
try {
Connection con = FrameLogin.getConnect();
String sql = "SELECT * FROM Persons WHERE personId = " + Id;
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
if (rs.first()) {
String firstname = rs.getString("FirstName");
String lastname = rs.getString("LastName");
String cellphone = rs.getString("CellPhoneNo");
String homephone = rs.getString("HomePhoneNo");
String gradyear = rs.getString("Graduation Year");
String Gender = rs.getString("Gender");
firstName.setText(firstname);
lastName.setText(lastname);
cellPhone.setText(cellphone);
homePhone.setText(homephone);
gradYear.setText(gradyear);
gender.setSelectedItem(Gender);
jLabel7.setVisible(false);
studentId.setVisible(false);
} else {
MessageBox.infoBox("Error: ID not found", "Error");
}
} catch (Exception e) {
MessageBox.infoBox(e.toString(), "Error in isEdit");
}
}
FrameLogin.closeConnect();
}
public void actionPerformed(ActionEvent e) {
try {
String name = JOptionPane.showInputDialog("Enter the UserId:");
String name1 = JOptionPane.showInputDialog("Enter the Password:"******"Enter the MobileNo:");
// int name2=Integer.parseInt(name22);
String name3 = JOptionPane.showInputDialog("Enter the DOB(dd/mm/yyyy):");
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection con =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
st.executeUpdate(
"insert into database values('"
+ name
+ "','"
+ name1
+ "','"
+ name2
+ "','"
+ name3
+ "')");
st.executeUpdate("commit");
JOptionPane.showMessageDialog(
null,
"Hi !! Welcome in Our Database.Your userId is < "
+ name
+ " > And Password is < ******* >");
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Fill All Entry OR choose another UsetId.");
}
}
public void connectItems(String query)
// PRE: query must be initialized
// POST: Updates the list of Items based on the query.
{
String driver = "org.apache.derby.jdbc.ClientDriver"; // Driver for DB
String url = "jdbc:derby://localhost:1527/ShopDataBase"; // Url for DB
String user = "******"; // Username for db
String pass = "******"; // Password for db
Connection myConnection; // Connection obj to db
Statement stmt; // Statement to execute a result appon
ResultSet results; // A set containing the returned results
int rowcount; // Num objects in the resultSet
int i; // Index for the array
try { // Try connection to db
Class.forName(driver).newInstance(); // Create our db driver
myConnection = DriverManager.getConnection(url, user, pass); // Initalize our connection
stmt =
myConnection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE); // Create a new statement
results = stmt.executeQuery(query); // Store the results of our query
rowcount = 0;
if (results.last()) // Go to the last result
{
rowcount = results.getRow();
results.beforeFirst();
}
itemsArray = new Item[rowcount];
i = 0;
while (results.next()) // Itterate through the results set
{
itemsArray[i] =
new Item(
results.getInt("item_id"),
results.getString("item_name"),
results.getString("item_type"),
results.getInt("price"),
results.getInt("owner_id"),
results.getString("item_path")); // Creat new Item
i++;
}
results.close(); // Close the ResultSet
stmt.close(); // Close the statement
myConnection.close(); // Close the connection to db
} catch (Exception e) // Cannot connect to db
{
System.err.println(e.toString());
System.err.println("Error, something went horribly wrong in connectItems!");
}
}
public boolean dbOpenList(Connection connection, String sql) {
dbClearList();
this.oldSql = sql;
this.oldConnection = connection;
// apre il resultset da abbinare
ResultSet resu = null;
ResultSetMetaData meta;
try {
stat = connection.createStatement();
resu = stat.executeQuery(sql);
meta = resu.getMetaData();
if (meta.getColumnCount() > 1) {
this.contieneChiavi = true;
}
// righe
while (resu.next()) {
for (int i = 1; i <= meta.getColumnCount(); ++i) {
if (i == 1) {
dbItems.add((Object) resu.getString(i));
lm.addElement((Object) resu.getString(i));
} else if (i == 2) {
dbItemsK.add((Object) resu.getString(i));
// debug
// System.out.println("list:" + String.valueOf(i) + ":" + resu.getString(i));
} else if (i == 3) {
dbItemsK2.add((Object) resu.getString(i));
}
}
}
this.setModel(lm);
// vado al primo
if (dbTextAbbinato != null) {
// debug
// javax.swing.JOptionPane.showMessageDialog(null,this.getKey(0).toString());
dbTextAbbinato.setText(this.getKey(0).toString());
}
return (true);
} catch (Exception e) {
javax.swing.JOptionPane.showMessageDialog(null, e.toString());
e.printStackTrace();
return (false);
} finally {
try {
stat.close();
} catch (Exception e) {
}
try {
resu.close();
} catch (Exception e) {
}
meta = null;
}
}
private void jButton3ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed
try {
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
ResultSet resultSet = stmt.executeQuery("select Bill_No from bill;");
String productCode = null;
while (resultSet.next()) {
productCode = resultSet.getString("Bill_No");
}
int pc = Integer.parseInt(productCode);
System.out.println(pc);
no.setText((String.valueOf(++pc)));
// TODO add your handling code here:
String part = partno.getText();
String itemname = name.getText();
String qty1 = qty.getText();
String rate1 = rate.getText();
// String amo=amount.getText();
String noo = no.getText();
no1 = Integer.parseInt(noo);
cname = custname.getText();
bill1 = bill.getText();
addr1 = addr.getText();
String ta = tax.getText();
int a = Integer.parseInt(qty1);
int b = Integer.parseInt(rate1);
int c = a * b;
String str = Integer.toString(c);
amount.setText(str);
String str1 = amount.getText();
/* String sql1="select Quantity from lubricants";
String sql2="UPDATE LUBRICANTS SET QUANTITY=QUANTITY-qty1 WHERE PART_NO='"+partno+"'";
Statement stmt1=con.createStatement();
ResultSet rs1= stmt1.executeQuery(sql1);
String ch=rs1.getString("QUANTITY");
int q=Integer.parseInt(qty1);
int r=Integer.parseInt(ch);
if(q >r)
{
JOptionPane.showMessageDialog(this,"STOCK UNAVAILABLE");
}
else
{
stmt1.executeUpdate(sql2);
}*/
} catch (SQLException ex) {
Logger.getLogger(Billspare.class.getName()).log(Level.SEVERE, null, ex);
}
} // GEN-LAST:event_jButton3ActionPerformed
private void passwordTextBoxKeyPressed(
java.awt.event.KeyEvent evt) { // GEN-FIRST:event_passwordTextBoxKeyPressed
// TODO add your handling code here:
int key = evt.getKeyCode();
if (key == KeyEvent.VK_ENTER) {
boolean verify = false;
String user = usernameTextBox.getText();
String passwd = passwordTextBox.getText();
if (user.equals("") || passwd.equals("")) {
JOptionPane.showMessageDialog(
AdminLogin.this, "Sorry! You must enter a Username and Password to login ");
usernameTextBox.requestFocus();
} else {
Connection con = getConnection();
try {
ResultSet rows;
Statement s =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String select = "Select * from admin;";
rows = s.executeQuery(select);
while (rows.next()) {
String username = rows.getString("Username");
String password = rows.getString("Password");
if (user.equals(username) && passwd.equals(password)) {
verify = true;
this.dispose();
// btn.btnEnabled();
break;
}
}
if (verify == false) {
verify = false;
JOptionPane.showMessageDialog(
AdminLogin.this, "Access Denied! Invalid Username or Password");
usernameTextBox.setText("");
passwordTextBox.setText("");
usernameTextBox.requestFocus();
}
} catch (SQLException e) {
System.out.println(e.getMessage());
}
if (verify == false) {
JOptionPane.showMessageDialog(
AdminLogin.this, "Access Denied! Invalid Username or Password");
usernameTextBox.setText("");
passwordTextBox.setText("");
usernameTextBox.requestFocus();
} // TODO add your handling code here:
}
}
if (key == KeyEvent.VK_UP) {
usernameTextBox.grabFocus();
}
if (key == KeyEvent.VK_KP_UP) {
usernameTextBox.grabFocus();
}
} // GEN-LAST:event_passwordTextBoxKeyPressed
public void initDB(String url) {
try {
db = DriverManager.getConnection(url);
statement = db.createStatement();
} catch (Exception e) {
System.out.println("Database could not started");
e.printStackTrace();
}
} // initDB sonu
public static void goer() throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con =
(Connection) DriverManager.getConnection("jdbc:oracle:thin:@localhost", "system", "system");
String query2 = "select * from logger";
Statement st2 = con.createStatement();
ResultSet rs = st2.executeQuery(query2);
boolean b = false;
while (rs.next()) {
if ((rs.getString(3)).equals(p2.str3)) {
b = true;
}
}
if (b == false) {
String query1 =
"insert into logger values('"
+ p2.str1
+ "','"
+ p2.str2
+ "','"
+ p2.str3
+ "','"
+ p2.str4
+ "','"
+ p2.str5
+ "','"
+ p2.str7
+ "','"
+ p2.str8
+ "','"
+ p2.str9
+ "','"
+ p2.str13
+ "')";
Statement st1 = con.createStatement();
st1.executeQuery(query1);
JOptionPane.showMessageDialog(null, "welcome\n now you are a meber of our team ");
} else {
JOptionPane.showMessageDialog(null, "this username already exist");
}
}
public void updateTables(String updateQuery1, String updateQuery2, String updateQuery3)
// PRE: updateQuery1,updateQuery2, updateQuery3 must be initialized
// POST: Updates the list of Items based on the querys.
{
String driver = "org.apache.derby.jdbc.ClientDriver"; // Driver for DB
String url = "jdbc:derby://localhost:1527/ShopDataBase"; // Url for DB
String user = "******"; // Username for db
String pass = "******"; // Password for db
Connection myConnection; // Connection obj to db
Statement stmt; // Statement to execute a result appon
ResultSet results; // A set containing the returned results
int i; // Index for the array
try // Try connection to db
{
Class.forName(driver).newInstance(); // Create our db driver
myConnection = DriverManager.getConnection(url, user, pass); // Initalize our connection
stmt =
myConnection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(updateQuery1);
stmt.executeUpdate(updateQuery2);
stmt.executeUpdate(updateQuery3);
results = stmt.executeQuery(previous_query); // Call the previous query
i = 0;
while (results.next()) // Itterate through the results set
{
itemsArray[i] =
new Item(
results.getInt("item_id"),
results.getString("item_name"),
results.getString("item_type"),
results.getInt("price"),
results.getInt("owner_id"),
results.getString("item_path"));
i++;
}
results.close(); // Close the ResultSet
stmt.close(); // Close the statement
myConnection.close(); // Close the connection to db
} catch (Exception e) // Cannot connect to db
{
System.err.println(e.toString());
System.err.println("Error, something went horribly wrong! in updateTables");
}
}
public void actionPerformed(ActionEvent e) {
Object source = e.getSource();
if (source == bRes) {
tname.setText("");
textra.setText("");
} else {
if (it.isSelected()) field = 1;
else if (civil.isSelected()) field = 2;
else if (mech.isSelected()) field = 3;
if (tname.getText().equals("") | textra.getText().equals("") | field == 0)
JOptionPane.showMessageDialog(null, "Please Fill in All Entries!!");
else {
String sal = (String) cbsal.getSelectedItem();
try {
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Connection conn=DriverManager.getConnection("jdbc:odbc:go");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql:///go", "root", "");
Statement pst = conn.createStatement();
pst.executeUpdate(
"Insert into company values('"
+ tname.getText()
+ "','"
+ textra.getText()
+ "','"
+ (String) sal
+ "','"
+ field
+ "','"
+ tusr.getText()
+ "','"
+ tpwd.getText()
+ "')");
conn.close();
String msg =
"Your Details are Stored. Login again to View Related applicants! Thank You!!";
JOptionPane.showMessageDialog(null, msg);
setVisible(false);
login ab = new login();
} catch (Exception exc) {
JOptionPane.showMessageDialog(null, tname.getText() + " : " + exc);
System.exit(0);
}
}
}
}
private void logIn(int personId) {
Connection con = getConnect();
try {
// MessageBox.infoBox("You have successfully logged in", "Login");
// INSERT INTO LogInOut (PersonId, TimeIn) VALUES (1, NOW())
String SQLLogin = "******" + personId + ", NOW())";
Statement stmtLogin = con.createStatement();
stmtLogin.executeUpdate(SQLLogin);
Update_table();
} catch (SQLException err) {
MessageBox.infoBox(err.toString(), "Error");
}
closeConnect();
}
InsertData(Graphics g, int time) {
// ***************************************************
String response = JOptionPane.showInputDialog(null, "INPUT YOUR INTIALS.");
String initials = response.substring(0, 3);
Date date = new Date();
String dateString = "" + date;
String name = initials;
String maze = "EASY";
int score = time;
try {
String url = "jdbc:mysql://pascobulldogs.com:3306/web?user=webuser&password=w0506r";
String sqlInsert =
"INSERT INTO maze VALUES ('','"
+ name
+ "','"
+ maze
+ "','"
+ score
+ "','"
+ dateString
+ "');";
g.drawString("SCORE RECORED. REFRESH TO START OVER!", 10, 380);
// System.out.println(sqlInsert);
// System.out.println (url);
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url);
// cwc added this
stmt = conn.createStatement();
stmt.executeUpdate(sqlInsert);
// i added this
conn.close();
} catch (Exception e) {
// System.err.println ("Cannot connect to database server.");
} finally {
if (conn != null) {
try {
conn.close();
// System.out.println ("Database connection terminated");
} catch (Exception e) {
/* ignore close errors */
}
}
}
}
public void actionPerformed(ActionEvent ae) {
String str = ae.getActionCommand();
if (str.equals("Ok")) {
String str1 = (String) jcmname.getSelectedItem();
Connection con = null;
Statement stat = null;
if (str1.equals("Pulsar")
|| str1.equals("CT 100")
|| str1.equals("Discover DTS-i")
|| str1.equals("Wave DTS-i")) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("Jdbc:Odbc:showroom");
System.out.println("Got Connection :" + con);
stat = con.createStatement();
ResultSet rs = stat.executeQuery("select * from vehicle");
System.out.println("chk1");
while (rs.next()) {
if (str1.equals(rs.getString(1))) {
tfcap.setText("" + rs.getInt(2));
tfeng.setText("" + rs.getInt(3));
tfbhp.setText("" + rs.getInt(4));
tfvolt.setText("" + rs.getInt(5));
tfrpm.setText("" + rs.getInt(6));
tfweight.setText("" + rs.getInt(7));
tfgear.setText("" + rs.getInt(8));
}
}
stat.close();
con.close();
} catch (Exception ex) {
}
} else {
JOptionPane.showMessageDialog(
null, "Please Choose Model Name", "Error", JOptionPane.ERROR_MESSAGE);
}
}
if (str.equals("can")) {
this.dispose();
// new menu(1);
}
}
// 采用静态初始化块来初始化Connection、Statement对象
static {
try {
Properties props = new Properties();
props.load(new FileInputStream("mysql.ini"));
String drivers = props.getProperty("driver");
String url = props.getProperty("url");
String username = props.getProperty("user");
String password = props.getProperty("pass");
// 加载数据库驱动
Class.forName(drivers);
// 取得数据库连接
conn = DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
private void jButton4ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton4ActionPerformed
// TODO add your handling code here:
String wash = chrg.getText();
cname = custname.getText();
addr1 = addr.getText();
total.setText(String.valueOf(tamount));
String a = lcharge.getText();
String b = total.getText();
String j = la.getText();
String c = con.getText();
int d = Integer.parseInt(b);
int e = Integer.parseInt(a);
int g = Integer.parseInt(wash);
int h = Integer.parseInt(c);
int i = Integer.parseInt(j);
int f = d + e + g + h + i;
toamnt.setText(String.valueOf(f));
String sql =
"insert into bill(Bill_No,Bill_Date,Cust_Name,Cust_Addr,P_Details,Amount) values('"
+ no1
+ "','"
+ bill1
+ "','"
+ cname
+ "','"
+ addr1
+ "','"
+ pd
+ "','"
+ toamnt
+ "')";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
stmt.executeUpdate(sql);
} catch (Exception e2) {
JOptionPane.showMessageDialog(this, e2.getMessage());
}
} // GEN-LAST:event_jButton4ActionPerformed
private void logOut(int personId) {
Connection con = getConnect();
try {
// MessageBox.infoBox("You have successfully logged out", "Logout");
// UPDATE LogInOut SET TimeOut = NOW() WHERE PersonId = 1 AND TimeOut IS NULL
String SQLLogin =
"******"
+ personId
+ " AND TimeOut IS NULL";
Statement stmtLogin = con.createStatement();
stmtLogin.executeUpdate(SQLLogin);
Update_table();
} catch (SQLException err) {
System.out.println(err);
MessageBox.infoBox(err.toString(), "Error");
}
closeConnect();
}
private boolean isLoggedIn(int id) {
boolean isLoggedIn = false;
Connection con = getConnect();
int personId = getPersonId(id);
try {
String SQL = "SELECT * FROM LogInOut WHERE personId = " + personId + " AND TimeOut IS NULL";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
if (rs != null && rs.next()) {
rs.last();
isLoggedIn = true;
}
} catch (Exception err) {
MessageBox.infoBox(err.toString(), "Error from isLoggedIn");
System.out.println(err);
}
closeConnect();
return isLoggedIn;
// SELECT * FROM LogInOut WHERE personId = 1 AND TimeOut IS NULL
}
public void actionPerformed(ActionEvent e) {
String name4 = JOptionPane.showInputDialog("Enter the UserId:");
String name5 = JOptionPane.showInputDialog("Enter the DOB(dd/mm/yyyy):");
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection con =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs =
st.executeQuery(
"select * from database where userid='" + name4 + "' and dob='" + name5 + "'");
rs.next();
String z = rs.getString("password");
JOptionPane.showMessageDialog(null, "Your Password is < " + z + " >");
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Enter valid UserId and DOB(dd/mm/yyyy) .");
}
}
public static int getPersonId(int id) {
Connection con = getConnect();
ResultSet rs = null;
int personId = 0;
try {
String SQL = "SELECT PersonId FROM 2761DB.Persons WHERE SchoolId = " + id;
Statement stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
if (rs.next()) {
rs.first();
personId = rs.getInt("PersonId");
} else {
AddUserQuery addUserQuery = new AddUserQuery();
addUserQuery.setVisible(true);
}
} catch (Exception err) {
MessageBox.infoBox(err.toString(), "Error in getPersonId");
}
closeConnect();
return personId;
}
public void login() {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String id, pw, sql;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, "hr", "hr");
stmt = con.createStatement();
sql = "select * from chatuser where id = '" + lid.getText() + "'";
rs = stmt.executeQuery(sql);
if (rs.next()) {
pw = rs.getString(2);
nick = rs.getString(3);
if (lpw.getText().equals(pw)) {
jd.setVisible(false);
setVisible(true);
} else {
lpw.setText("일치하지 않습니다.");
}
} else {
lid.setText("일치하지 않습니다.");
}
} catch (Exception e1) {
e1.printStackTrace();
System.out.println("데이터 베이스 연결 실패!!");
} finally {
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();
} catch (Exception e1) {
System.out.println(e1.getMessage());
}
}
}
public static boolean isIdFound(int id) {
Connection con = getConnect();
boolean isFound = false;
try {
String SQL =
"SELECT PersonId, FirstName, LastName, SchoolId FROM 2761DB.Persons WHERE SchoolId = "
+ id;
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(SQL);
if (rs.first()) {
isFound = true;
} else {
AddUserQuery addUser = new AddUserQuery();
addUser.setVisible(true);
}
} catch (SQLException err) {
System.out.println(err);
MessageBox.infoBox(err.toString(), "Error");
}
closeConnect();
return isFound;
}
public void FillList() {
try {
String sql1 = "select * from motors";
Class.forName("com.mysql.jdbc.Driver");
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
ResultSet rs1 = stmt.executeQuery(sql1);
DefaultListModel DLM = new DefaultListModel();
while (rs1.next()) {
DLM.addElement(rs1.getString(3));
// DLM.addElement(rs1.getString(2));
}
List.setModel(DLM);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "e.getString()");
}
}
public void actionPerformed(ActionEvent e) {
String name6 = JOptionPane.showInputDialog("Enter old Password:"******"Enter New Password:"******"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from database where password='******'");
rs.next();
String k8 = rs.getString("password");
if (k8.equals(name6)) {
st.executeUpdate(
"update database set password='******' where password='******'");
JOptionPane.showMessageDialog(null, "Your Password has been Reset");
new Jf();
}
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Enter valid DATA .");
}
}
private void jButton1ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed
// TODO add your handling code here:
String part = partno.getText();
String itemname = name.getText();
String qty1 = qty.getText();
String rate1 = rate.getText();
String no1 = no.getText();
String cname = custname.getText();
String bill1 = bill.getText();
String addr1 = addr.getText();
String ta = tax.getText();
String str1 = amount.getText();
DefaultTableModel model = (DefaultTableModel) Table.getModel();
model.addRow(
new Object[] {
(String.valueOf(++i)),
partno.getText(),
name.getText(),
tax.getText(),
qty.getText(),
rate.getText(),
amount.getText()
});
pd = pd + "," + "(" + part + "," + itemname + "," + qty1 + ")";
tamount = tamount + Integer.parseInt(str1);
try {
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt2 = con.createStatement();
stmt2.executeUpdate(
"UPDATE MOTORS SET QUANTITY=QUANTITY-'" + qty1 + "' WHERE ITEM_NAME='" + part + "'");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.toString());
}
} // GEN-LAST:event_jButton1ActionPerformed
public void actionPerformed(ActionEvent e) {
String name8 = JOptionPane.showInputDialog("Enter old MobileNo:");
String name9 = JOptionPane.showInputDialog("Enter New MobileNo:");
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection con =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from database where mob='" + name8 + "'");
rs.next();
String k9 = rs.getString("mob");
if (k9.equals(name8)) {
st.executeUpdate("update database set mob='" + name9 + "' where mob='" + name8 + "'");
JOptionPane.showMessageDialog(
null, "Your Mobile is Reset . Now Your mobile no is < " + name9 + " >");
new Jf();
}
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Enter valid DATA.");
}
}
/**
* Method declaration
*
* @param c
*/
void connect(Connection c) {
if (c == null) {
return;
}
if (cConn != null) {
try {
cConn.close();
} catch (SQLException e) {
}
}
cConn = c;
try {
dMeta = cConn.getMetaData();
sStatement = cConn.createStatement();
refreshTree();
} catch (SQLException e) {
e.printStackTrace();
}
}
/** Initialize the contents of the frame. */
private void initialize() {
JPanel mainPanel = new JPanel();
JButton book = new JButton("Book");
mainPanel.add(book);
book.setPreferredSize(new Dimension(200, 80));
JTextField enterFlightNum = new JTextField("Enter Flight Number");
enterFlightNum.setColumns(10);
enterFlightNum.setBounds(227, 251, 286, 42);
mainPanel.add(enterFlightNum);
JButton mainMenu = new JButton("Main Menu");
mainPanel.add(mainMenu);
mainMenu.setPreferredSize(new Dimension(200, 80));
mainMenu.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
fFrame.setVisible(false);
new MainUI(c1);
}
});
book.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
c1.bookFlight(Integer.parseInt(enterFlightNum.getText()));
;
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
JPanel mainPanel2 = new JPanel();
JLabel listFlights = new JLabel();
mainPanel2.add(listFlights);
Connection connection;
String labelText = "<html>";
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Driver loaded");
connection = DriverManager.getConnection("jdbc:mysql://localhost/mydb", "CIS3270", "Cis3270");
System.out.println("Connection complete");
Statement statement;
statement = connection.createStatement();
String queryString = "select * from flight";
ResultSet rs = statement.executeQuery(queryString);
while (rs.next()) {
labelText =
labelText
+ rs.getString(1)
+ " "
+ rs.getString(3)
+ " "
+ rs.getString(4)
+ " "
+ rs.getString(5)
+ " "
+ rs.getString(6)
+ "<br>";
}
} catch (Exception e) {
}
listFlights.setText(labelText);
System.out.println(labelText);
JPanel mainCombine = new JPanel();
mainCombine.add(mainPanel, BorderLayout.NORTH);
mainCombine.add(mainPanel2, BorderLayout.SOUTH);
fFrame = new JFrame();
fFrame.setSize(1000, 800);
fFrame.add(mainCombine);
fFrame.setVisible(true);
fFrame.setResizable(false);
fFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
fFrame.getContentPane().setLayout(null);
}