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
public JobIniciado retornaUltimoLote(Connection conn, String job, int operacao)
throws SQLException {
String sql =
" select job, operacao, tripulacao,recurso, max(data_fim) \n"
+ "from joblote where job = ? and operacao = ? \n"
+ "group by job, operacao, tripulacao, recurso ";
PreparedStatement stmt = null;
ResultSet rs = null;
JobIniciado iniciado = null;
stmt = conn.prepareStatement(sql);
stmt.setString(1, job.trim().replace(".", ""));
stmt.setInt(2, operacao);
rs = stmt.executeQuery();
if (rs.next()) {
iniciado = new JobIniciado();
iniciado.setJob(rs.getString(1));
iniciado.setOperacao(rs.getInt(2));
iniciado.setTripulacao(rs.getDouble(3));
iniciado.setRecurso(rs.getString(4));
Timestamp data = rs.getTimestamp(5);
iniciado.setData(Validacoes.getDataHoraString(data));
}
return iniciado;
}
@Override
public void actionPerformed(ActionEvent axnEve) {
Object obj = axnEve.getSource();
if (obj == replyBut) {
try {
if (Home.composeDial != null && Home.composeDial.isShowing()) {
} else {
Home.composeDial =
new ComposeMailDialog(
msgID, workingSet.getString("mail_addresses"), workingSet.getString("subject"));
}
} catch (SQLException sqlExc) {
sqlExc.printStackTrace();
}
} else if (obj == forwardBut) {
try {
if (Home.composeDial != null && Home.composeDial.isShowing()) {
} else {
Home.composeDial =
new ComposeMailDialog(
msgID,
workingSet.getString("subject") + "\n\n" + workingSet.getString("content"));
}
} catch (SQLException sqlExc) {
sqlExc.printStackTrace();
}
}
}
/**
* metoda pobierajaca wszystkie rekordy z BD1.
*
* @return
*/
public ArrayList<StudentFirst> getAllStudentFromDBfirst() {
logger.info("getAllContactFromDB");
ResultSet result = null;
ArrayList<StudentFirst> students = new ArrayList<>();
try {
prepStmt = conn.prepareStatement("SELECT * FROM student1");
result = prepStmt.executeQuery();
int id, index;
String name, surname, university, faculty, field;
for (int i = 0; result.next(); i++) {
id = result.getInt("stud1_id");
index = result.getInt("stud1_index");
name = result.getString("stud1_name");
surname = result.getString("stud1_lastname");
university = result.getString("stud1_university");
faculty = result.getString("stud1_faculty");
field = result.getString("stud1_field");
students.add(new StudentFirst(id, index, name, surname, university, faculty, field));
logger.info(students.get(i).toString());
}
if (students.size() == 0) {
logger.info("Pusta BD?");
}
return students;
} catch (SQLException e1) {
JOptionPane.showMessageDialog(null, e1);
e1.printStackTrace();
return null;
}
}
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 ae) {
try {
if (ae.getSource() == b7) {
rs = st.executeQuery("select count(*) from employeemaster");
if (rs.next()) {
t6.setText(rs.getString(1));
}
rs = st.executeQuery("select * from Head");
if (rs.next()) {
t1.setText(rs.getString(1));
t2.setText(rs.getString(2));
t7.setText(rs.getString(3));
t4.setText(rs.getString(4));
t5.setText(rs.getString(5));
t3.setText(rs.getString(6));
}
} else if (ae.getSource() == b6) {
dispose();
}
} catch (Exception e) {
JOptionPane.showMessageDialog(this, "Error is" + e);
}
}
public boolean validLogin(String username, String password) {
boolean validUser = false;
try {
dbStm =
dbCon.prepareStatement(
"SELECT * FROM userInfo WHERE username = "******"\"" + username + "\"" + ";");
dbRs = dbStm.executeQuery();
while (dbRs.next()) {
String un = "";
String pw = "";
un = dbRs.getString("username");
System.out.println(un + " " + username);
pw = dbRs.getString("password");
System.out.println(pw + " " + password);
if (((username.equals(un) == true) && ((password.equals(pw) == true)))) {
validUser = true;
System.out.println("Valid User");
}
}
} catch (Exception e) {
e.printStackTrace();
}
return validUser;
}
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;
}
}
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!");
}
}
stab(ResultSet k) {
super("PATIENT FOUND");
String[] chd = {
"Date",
"Patient ID",
"Name",
"Gender",
"Age",
"Weight",
"Address",
"Contact No.",
"Doctor Name",
"Symptoms",
"Dignosis",
"Fee: Rs.",
"Blood Group"
};
// DefaultTableModel dtm=new DefaultTableModel();
// jt.setModel(new DefaultTableModel(arr,chd));
jt = new JTable();
jsp = new JScrollPane(jt);
btn = new JButton("CLOSE");
btn.addActionListener(this);
int i = 0;
try {
while (k.next()) {
arr[i][0] = k.getString(1);
// System.out.println("ddddddddddddd"+arr[i][0]);
arr[i][1] = "" + k.getInt(2);
arr[i][2] = k.getString(3) + " " + k.getString(4) + " " + k.getString(5);
arr[i][3] = k.getString(6);
arr[i][4] = "" + k.getInt(7);
arr[i][5] = k.getString(8);
arr[i][6] = k.getString(9);
arr[i][7] = k.getString(10);
arr[i][8] = k.getString(11);
arr[i][9] = k.getString(12);
arr[i][10] = k.getString(13);
arr[i][11] = "" + k.getInt(14);
arr[i][12] = k.getString(15);
arr[i][13] = k.getString(16);
// dtm.insertRow(i,new Object[]{patient.rs.getString(1),
// patient.rs.getInt(2),patient.rs.getString(3)+patient.rs.getString(4)+patient.rs.getString(5),patient.rs.getString(6),patient.rs.getInt(7),patient.rs.getString(8),patient.rs.getString(9),patient.rs.getString(10),patient.rs.getString(11),patient.rs.getString(12),patient.rs.getString(13),patient.rs.getInt(14)});
i++;
}
} catch (Exception e12) {
System.out.println("" + e12);
}
jt.setModel(new DefaultTableModel(arr, chd));
Container con = getContentPane();
con.setLayout(null);
jsp.setBounds(20, 20, 1230, 600);
btn.setBounds(685, 630, 100, 30);
add(jsp);
add(btn);
setSize(1330, 800);
setVisible(true);
}
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 JobProtheus retornaJob(Connection conn, JobLote lote) throws SQLException {
ResultSet rs = null;
PreparedStatement stmt = null;
JobProtheus job = null;
String sql = "select job , B1_DESC, operacao , produto, ";
sql += " dt_release, job_start_date , qtd_release, setor, qtd_transf ";
sql += " from job left join " + DB_PROTHEUS.trim() + ".dbo.SB1000 SB1 ";
sql += " on(produto collate SQL_Latin1_General_CP1_CI_AS = B1_COD) ";
sql += " where job = ? and operacao = ? and SB1.D_E_L_E_T_ = '' ";
sql += " order by dt_release, produto ";
stmt = conn.prepareStatement(sql);
stmt.setString(1, lote.getJob().trim());
stmt.setInt(2, lote.getOperNum());
rs = stmt.executeQuery();
while (rs.next()) {
String nJob = rs.getString("job");
int operacao = rs.getInt("operacao");
String produto = rs.getString("produto");
Date dataEmissao = rs.getDate("dt_release");
Date dataPrevisaoInicio = rs.getDate("job_start_date");
String descricaoProduto = rs.getString("B1_DESC");
double quantidade = rs.getDouble("qtd_release");
String wc = rs.getString("setor");
String emissao = dataEmissao != null ? getDateToString(dataEmissao) : "";
String previsaoInicio = dataPrevisaoInicio != null ? getDateToString(dataPrevisaoInicio) : "";
job = new JobProtheus();
job.setStatus("");
job.setJob(nJob);
job.setOperacao(operacao);
job.setProduto(produto.trim());
job.setDataEmissao(emissao);
job.setQuantidadeLiberada(quantidade);
job.setDescricaoProduto(descricaoProduto);
job.setCentroTrabalho(wc);
double qtdTotal = retornaQtdTotal(conn, job); // calcula o total transferido para o job
job.setQuantidadeCompleta(qtdTotal);
job.setDataPrivisaoInicio(previsaoInicio);
job.setQuantidadeFaltando(quantidade - qtdTotal); // seta o valor qtd faltando
}
return job; // retorna lista de jobs
}
private void Baru() {
btnSave.setText("Save");
txtNip.requestFocus();
txtNip.setText("");
try {
Class.forName(KoneksiDatabase.driver);
java.sql.Connection c =
DriverManager.getConnection(
KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass);
Statement s = c.createStatement();
String sql = "select * from absensi_lembur";
ResultSet rs = s.executeQuery(sql);
final String[] headers = {
"Kd Absen",
"NIP",
"Tgl Absen",
"Masuk",
"Pulang",
"Hari",
"Tipe Hari",
"Terlambat",
"Lembur",
"Tipe Lembur",
"Tot Lembur",
"Tunj Makan",
"Tunj Transport"
};
rs.last();
int n = rs.getRow();
Object[][] data = new Object[n][13];
int p = 0;
rs.beforeFirst();
while (rs.next()) {
data[p][0] = rs.getString(1);
data[p][1] = rs.getString(2);
data[p][2] = rs.getString(3);
data[p][3] = rs.getString(4);
data[p][4] = rs.getString(5);
data[p][5] = rs.getString(6);
data[p][6] = rs.getString(7);
data[p][7] = rs.getString(8);
data[p][8] = rs.getString(9);
data[p][9] = rs.getString(10);
data[p][10] = rs.getString(11);
data[p][11] = rs.getString(12);
data[p][12] = rs.getString(13);
p++;
}
tblLembur.setModel(new DefaultTableModel(data, headers));
tblLembur.setAlignmentX(CENTER_ALIGNMENT);
} catch (Exception e) {
JOptionPane.showMessageDialog(
null, "Gagal Koneksi, Ada Kesalahan.", "Warning", JOptionPane.WARNING_MESSAGE);
}
}
public ArrayList<File> getFiles(String sql) {
ArrayList<File> list = new ArrayList<File>();
Connection conn = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
conn = getConnection();
ps =
conn.prepareStatement(
sql.toLowerCase().startsWith("select")
? sql
: ("SELECT FILENAME, MODIFIED FROM FILES WHERE " + sql));
rs = ps.executeQuery();
while (rs.next()) {
String filename = rs.getString("FILENAME");
long modified = rs.getTimestamp("MODIFIED").getTime();
File file = new File(filename);
if (file.exists() && file.lastModified() == modified) {
list.add(file);
}
}
} catch (SQLException se) {
LOGGER.error(null, se);
return null;
} finally {
close(rs);
close(ps);
close(conn);
}
return list;
}
public ArrayList<String> getStrings(String sql) {
ArrayList<String> list = new ArrayList<String>();
Connection conn = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
conn = getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
String str = rs.getString(1);
if (isBlank(str)) {
if (!list.contains(NONAME)) {
list.add(NONAME);
}
} else if (!list.contains(str)) {
list.add(str);
}
}
} catch (SQLException se) {
LOGGER.error(null, se);
return null;
} finally {
close(rs);
close(ps);
close(conn);
}
return list;
}
public void executeQuery() throws SQLException {
log(
"select account, branch, balance, filler from "
+ m_Driver.getAccountName()
+ " where account < 101\n",
2);
Statement stmt = null;
try {
stmt = m_conn.createStatement();
ResultSet set =
stmt.executeQuery(
"select account, branch, balance, filler from "
+ m_Driver.getAccountName()
+ " where account < 101");
while (set.next()) {
set.getInt(1);
set.getInt(2);
set.getDouble(3);
set.getString(4);
}
set.close();
} finally {
if (stmt != null) stmt.close();
stmt = null;
}
}
public JTable queryTable(String table, String query) {
//create statement
Statement stmt = con.createStatement();
stmt.executeUpdate(table);
//query db for table
ResultSet rs = stmt.executeQuery(query);
//initialize values for jtable
Object[50][50] data;
int n=1;
int p=1;
//put info into jtable
while (rs.next()) { // print up to 50 rows
while (n<=50) { // print up to 50 columns
String s = rs.getString(n);
data[p][n] = s;
}
n=1;
p++;
}
//create jtable
String[] columnNames = {query};
final JTable jtable = new JTable(data, columnNames);
return jtable;
}
public static int retornaQtdTotal(Connection conn, JobProtheus job) throws SQLException {
PreparedStatement stmt = null;
ResultSet rs = null;
int qtdTotal = 0;
int qtdSucata = 0;
String sqlVerQtd =
"select job, sum(qtd_transf), sum(hr_tot), sum(qtd_sucata) from jobLote where job = ? and operacao = ? group by job";
stmt = conn.prepareStatement(sqlVerQtd);
stmt.setString(1, job.getJob().trim());
stmt.setInt(2, job.getOperacao());
rs = stmt.executeQuery();
String qtdJob = "";
double totHora = 0;
while (rs.next()) {
qtdJob = rs.getString(1); // numero job
qtdTotal = rs.getInt(2); // quantidade total
totHora = rs.getInt(3); // hora total em minutos
qtdSucata = rs.getInt(4);
}
return qtdTotal + qtdSucata;
}
public void actionPerformed(ActionEvent evt) {
// 删除原来的JTable(JTable使用scrollPane来包装)
if (scrollPane != null) {
jf.remove(scrollPane);
}
try (
// 根据用户输入的SQL执行查询
ResultSet rs = stmt.executeQuery(sqlField.getText())) {
// 取出ResultSet的MetaData
ResultSetMetaData rsmd = rs.getMetaData();
Vector<String> columnNames = new Vector<>();
Vector<Vector<String>> data = new Vector<>();
// 把ResultSet的所有列名添加到Vector里
for (int i = 0; i < rsmd.getColumnCount(); i++) {
columnNames.add(rsmd.getColumnName(i + 1));
}
// 把ResultSet的所有记录添加到Vector里
while (rs.next()) {
Vector<String> v = new Vector<>();
for (int i = 0; i < rsmd.getColumnCount(); i++) {
v.add(rs.getString(i + 1));
}
data.add(v);
}
// 创建新的JTable
JTable table = new JTable(data, columnNames);
scrollPane = new JScrollPane(table);
// 添加新的Table
jf.add(scrollPane);
// 更新主窗口
jf.validate();
} catch (Exception e) {
e.printStackTrace();
}
}
public void setQuery(String q) {
cache = new Vector();
try {
ResultSet rs = statement.executeQuery(q);
ResultSetMetaData meta = rs.getMetaData();
colCount = meta.getColumnCount();
headers = new String[colCount];
for (int h = 1; h <= colCount; h++) {
headers[h - 1] = meta.getColumnName(h);
}
while (rs.next()) {
String[] record = new String[colCount];
for (int i = 0; i < colCount; i++) {
record[i] = rs.getString(i + 1);
}
cache.addElement(record);
} // while sonu
fireTableChanged(null);
} // try sonu
catch (Exception e) {
cache = new Vector();
e.printStackTrace();
}
} // setQuery sonu
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
public SingleNameReport(WritableWorkbook workbook, Statement new_statement, String[] arguments) {
String main_tsn = "";
String main_rank = "";
String main_kingdom = "";
row = 0;
try {
statement = new_statement;
func = new AdditionalFunctions(statement);
copy = workbook;
kingdom = arguments[0];
hrank = arguments[1];
lrank = arguments[2];
scientificName = arguments[3];
date_from = arguments[4];
date_to = arguments[5];
user = arguments[6];
String temp = "";
temp =
"SELECT tsn,rank_id,kingdom_id from Tree where scientificName='" + scientificName + "'";
System.out.println(temp);
result = statement.executeQuery(temp);
metadata = result.getMetaData();
int numberOfRows = 0;
int hrankVal = Integer.parseInt(hrank);
int main_rankVal = 0;
if (result.last()) numberOfRows = result.getRow();
result.first();
if (numberOfRows > 0 && metadata.getColumnCount() > 0) {
main_tsn = result.getString(1);
main_rank = result.getString(2);
main_rankVal = Integer.parseInt(main_rank);
main_kingdom = result.getString(3);
}
if (HasChildren(main_tsn) == true) FindChildInformation(main_tsn, arguments, func);
FileInFrontPage frontPage = new FileInFrontPage(copy, statement, arguments);
copy.write();
copy.close();
} catch (Exception e) {
e.printStackTrace();
System.exit(1);
}
} // end of constructor
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 boolean isValidUser() throws SQLException {
CreateJDBCConnection jdbc = new CreateJDBCConnection();
Statement stmt = jdbc.getStatement();
stmt.execute("use jana;");
String sqlQuery =
"select password from user_details where idno = '" + nameText.getText() + "';";
ResultSet rs = stmt.executeQuery(sqlQuery);
while (rs.next()) {
if (rs.getString("password").equals(passText.getText())) return true;
}
return false;
}
public void cleanup() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = getConnection();
ps = conn.prepareStatement("SELECT COUNT(*) FROM FILES");
rs = ps.executeQuery();
dbCount = 0;
if (rs.next()) {
dbCount = rs.getInt(1);
}
rs.close();
ps.close();
PMS.get().getFrame().setStatusLine(Messages.getString("DLNAMediaDatabase.2") + " 0%");
int i = 0;
int oldpercent = 0;
if (dbCount > 0) {
ps =
conn.prepareStatement(
"SELECT FILENAME, MODIFIED, ID FROM FILES",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
rs = ps.executeQuery();
while (rs.next()) {
String filename = rs.getString("FILENAME");
long modified = rs.getTimestamp("MODIFIED").getTime();
File file = new File(filename);
if (!file.exists() || file.lastModified() != modified) {
rs.deleteRow();
}
i++;
int newpercent = i * 100 / dbCount;
if (newpercent > oldpercent) {
PMS.get()
.getFrame()
.setStatusLine(Messages.getString("DLNAMediaDatabase.2") + newpercent + "%");
oldpercent = newpercent;
}
}
}
} catch (SQLException se) {
LOGGER.error(null, se);
} finally {
close(rs);
close(ps);
close(conn);
}
}
public void actionPerformed(ActionEvent ae) {
try {
Integer num = Integer.parseInt(tfdid.getText());
String name;
String addr;
String contact;
String spec;
String workf;
String workt;
Statement st = cn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM DOC WHERE did=" + num);
if (rs.next()) {
num = rs.getInt("did");
name = rs.getString("name");
addr = rs.getString("address");
contact = rs.getString("contact");
spec = rs.getString("specialization");
workf = rs.getString("workfrom");
workt = rs.getString("workto");
tfname.setText(name);
taadd.setText(addr);
tftel.setText(contact);
taspecial.setText(spec);
tfworkf.setText(workf);
tfworkt.setText(workt);
}
} catch (SQLException sq) {
System.out.println(sq);
}
}
public void actionPerformed(java.awt.event.ActionEvent evt) {
String sql1 =
"select a.* FROM ANTENA a WHERE a.ID_antena='"
+ (newJPanel.jList1.getSelectedIndex() + 1)
+ "' ";
String pom = "";
System.out.println(sql1);
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", user, password);
Statement stmt1 = conn.createStatement();
ResultSet rs1 = stmt1.executeQuery(sql1);
while (rs1.next()) {
NewJPanel.jTextField1.setText(rs1.getString("ID_antena"));
NewJPanel.jTextField2.setText(rs1.getString("Producent"));
NewJPanel.jTextField3.setText(rs1.getString("Numer_identyfikacyjny"));
NewJPanel.jTextField4.setText(rs1.getString("Czestotliwosc"));
NewJPanel.jTextField5.setText(rs1.getString("Polaryzacja"));
NewJPanel.jTextField6.setText(rs1.getString("Moc"));
NewJPanel.jTextField7.setText(rs1.getString("Rodzaj"));
}
} catch (SQLException e1) {
System.out.println("tutaj 1");
e1.printStackTrace();
}
} catch (ClassNotFoundException e1) {
System.out.println("tutaj 2");
e1.printStackTrace();
}
}
public void updateRecord() {
String totalSeat, alotSeat, vacentSeat, strHostel;
try {
rs = statement.executeQuery("select hostelName from hostelStatus");
while (rs.next()) {
strHostel = rs.getString(1);
try {
rs1 = statement1.executeQuery("select count(*) from " + strHostel + "");
rs1.next();
totalSeat = rs1.getString(1);
rs1 = statement1.executeQuery("select count(*) from " + strHostel + " where status='F'");
rs1.next();
alotSeat = rs1.getString(1);
try {
vacentSeat = String.valueOf(Integer.parseInt(totalSeat) - Integer.parseInt(alotSeat));
statement1.executeUpdate(
"update hostelStatus set totalSeat='"
+ totalSeat
+ "',vacentSeat='"
+ vacentSeat
+ "'where hostelName='"
+ strHostel
+ "'");
statement1.executeUpdate("commit");
rs1.close();
} catch (SQLException sqle) {
JOptionPane.showMessageDialog(null, sqle);
}
} catch (SQLException sqle) {
JOptionPane.showMessageDialog(null, "Error " + sqle);
}
}
} catch (SQLException sq) {
JOptionPane.showMessageDialog(null, sq);
}
}
public void display(ResultSet rs) {
try {
boolean recordNumber = rs.next();
if (recordNumber) {
payNo = rs.getString(1);
pasNo = rs.getString(2);
pasName = rs.getString(3);
mode = rs.getString(4);
dt = rs.getString(5);
amount = rs.getString(6);
rev = rs.getString(7);
text1.setText(payNo);
combo1.setSelectedItem(pasNo);
combo2.setSelectedItem(pasName);
combo4.setSelectedItem(mode);
p_date.setText(dt);
combo8.setSelectedItem(amount);
combo3.setSelectedItem(rev);
} else {
JOptionPane.showMessageDialog(
null, "Record Not found", "ERROR", JOptionPane.DEFAULT_OPTION);
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
}
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());
}
}
}