🔒 Closed Sino programmer dito?

[mighty dragon]

kelangan Netbeans db server ang iyong gagamitin??? may alam ako konti pero ibang db server..

anong db server boss?

 

[keo_fly]

Di ba sabi mo master may db problem ka anong programming language gamit mo vb 6. 0??? Pede ka gamit ibang server

 

[mighty dragon]

Di ba sabi mo master may db problem ka anong programming language gamit mo vb 6. 0??? Pede ka gamit ibang server

nakagamit na ko dati ng vb kaya alam ko un. kasi java gamit ko tapos environment ay Netbeans. tapos ung ginagamit ko na db ay sa netbeans mismo.

 

[drexz520]

java developer here.

 

[mighty dragon]

java developer here.

boss pano ung sa database pag java? tapos environment is netbeans

 

[drexz520]

boss pano ung sa database pag java? tapos environment is netbeans

ano ba app ang gagawin mo?

 

[mighty dragon]

ano ba app ang gagawin mo?

ung pang sms system. db lang problema ko pag nabuild na edi jar file na sya. nag oopen pero pag sa db need buksan at iconnect sa netbeans parin. sa madaling salita kailangan buksan pa ung netbeans para lang maconnect sa db nung netbeans

 

[drexz520]

ung pang sms system. db lang problema ko pag nabuild na edi jar file na sya. nag oopen pero pag sa db need buksan at iconnect sa netbeans parin. sa madaling salita kailangan buksan pa ung netbeans para lang maconnect sa db nung netbeans

d mo ata na set ng tama ang db mo. ano ba gamit mo db? pa kita ng codes sa connection sa DB kung pwede..

 

[mighty dragon]

d mo ata na set ng tama ang db mo. ano ba gamit mo db? pa kita ng codes sa connection sa DB kung pwede..

eto sir
public void DoConnect() {

try{

String host = "jdbc:derby://localhost:1527/SMS";
String uName = "administrator";
String uPass = "password";
con = DriverManager.getConnection(host, uName, uPass);
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "SELECT * FROM ABCOM";
rs = stmt.executeQuery(sql);

con2 = DriverManager.getConnection(host, uName, uPass);
stmt2 = con2.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2 = "SELECT * FROM BSA";
rs2 = stmt2.executeQuery(sql2);

con3 = DriverManager.getConnection(host, uName, uPass);
stmt3 = con3.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql3 = "SELECT * FROM BSBA";
rs3 = stmt3.executeQuery(sql3);

con4 = DriverManager.getConnection(host, uName, uPass);
stmt4 = con4.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql4 = "SELECT * FROM BSHRM";
rs4 = stmt4.executeQuery(sql4);

con5 = DriverManager.getConnection(host, uName, uPass);
stmt5 = con5.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql5 = "SELECT * FROM BSIT";
rs5 = stmt5.executeQuery(sql5);

con6 = DriverManager.getConnection(host, uName, uPass);
stmt6 = con6.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql6 = "SELECT * FROM BSPSY";
rs6 = stmt6.executeQuery(sql6);

con7 = DriverManager.getConnection(host, uName, uPass);
stmt7 = con7.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql7 = "SELECT * FROM BST";
rs7 = stmt7.executeQuery(sql7);


}
catch (SQLException err) {
// JOptionPane.showMessageDialog(StudentForm.this, err.getMessage());
}
}

 

[drexz520]

mag i stop kac ang server pag naka close na yung environment na IDE kac sa simula pa lang yun ang gamit mo sa pag oopen ng server mo. Pag nag close yun close then server mo.

 

[drexz520]

eto sir
public void DoConnect() {

try{

String host = "jdbc:derby://localhost:1527/SMS";
String uName = "administrator";
String uPass = "password";
con = DriverManager.getConnection(host, uName, uPass);
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "SELECT * FROM ABCOM";
rs = stmt.executeQuery(sql);

con2 = DriverManager.getConnection(host, uName, uPass);
stmt2 = con2.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2 = "SELECT * FROM BSA";
rs2 = stmt2.executeQuery(sql2);

con3 = DriverManager.getConnection(host, uName, uPass);
stmt3 = con3.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql3 = "SELECT * FROM BSBA";
rs3 = stmt3.executeQuery(sql3);

con4 = DriverManager.getConnection(host, uName, uPass);
stmt4 = con4.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql4 = "SELECT * FROM BSHRM";
rs4 = stmt4.executeQuery(sql4);

con5 = DriverManager.getConnection(host, uName, uPass);
stmt5 = con5.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql5 = "SELECT * FROM BSIT";
rs5 = stmt5.executeQuery(sql5);

con6 = DriverManager.getConnection(host, uName, uPass);
stmt6 = con6.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql6 = "SELECT * FROM BSPSY";
rs6 = stmt6.executeQuery(sql6);

con7 = DriverManager.getConnection(host, uName, uPass);
stmt7 = con7.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql7 = "SELECT * FROM BST";
rs7 = stmt7.executeQuery(sql7);


}
catch (SQLException err) {
// JOptionPane.showMessageDialog(StudentForm.this, err.getMessage());
}
}

glassfish server kac gamit ko. Wala nman problema sa code mo. D mo kac na run yung server mo sa pc mo kaya nag eeror. dun mo lang ni rurun sa Netbeans mo.

 

[mighty dragon]

glassfish server kac gamit ko. Wala nman problema sa code mo. D mo kac na run yung server mo sa pc mo kaya nag eeror. dun mo lang ni rurun sa Netbeans mo.

ayun talaga nagiging problema ko ung server ko nasa netbeans din talaga

 

[mighty dragon]

glassfish server kac gamit ko. Wala nman problema sa code mo. D mo kac na run yung server mo sa pc mo kaya nag eeror. dun mo lang ni rurun sa Netbeans mo.

ganun din codes pag gumamit ako ng glass server? oracle pala un nu?

 

[drexz520]

punta ka sa location ng server mo sa local disk C:
nasa Program Files ata yan then hanapin mo dun pag nakita mo hanapin mo c bin files.

pag may makikita ka ng asaadmin.bat i open mo yun.

 

[mighty dragon]

punta ka sa location ng server mo sa local disk C:
nasa Program Files ata yan then hanapin mo dun pag nakita mo hanapin mo c bin files.

pag may makikita ka ng asaadmin.bat i open mo yun.

wala ako makita nun. alin ung sa database?

 

[drexz520]

ano gamit mo driver?

 

[drexz520]

ano gamit mo dito?

 

[mighty dragon]

ano gamit mo dito?

eto

 

[drexz520]

eto

tignan mo yung pic na post ko .. ano gamit mo driver dun?

 

[mighty dragon]

tignan mo yung pic na post ko .. ano gamit mo driver dun?

andun na un nung ginamit ko sir eh. ung default