API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 26th, 2016
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.38 KB | None | 0 0
raw download clone embed print report
  1.  
  2. package bazaaaa;
  3.  
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import javax.swing.JOptionPane;
  10.  
  11.  
  12. public class Bazaaaa extends javax.swing.JFrame {
  13. Connection con;
  14. Statement stmt;
  15. ResultSet rs;
  16.  
  17. public Bazaaaa() {
  18. initComponents();
  19. Polaczenie();
  20.  
  21. }
  22. public void Polaczenie()
  23. {
  24. try {
  25. //Połączenie z bazą danych
  26. String host = "jdbc:oracle:thin:@155.158.112.45:1521:oltpstud";
  27. String uzytkownik = "msbd9";
  28. String haslo = "haslo2016";
  29. con = DriverManager.getConnection(host, uzytkownik, haslo);
  30.  
  31. stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE );
  32. String sql = "SELECT * FROM EMPLOYEES";
  33. rs = stmt.executeQuery(sql);
  34.  
  35. rs.next();
  36. int id_kol = rs.getInt("EMPLOYEE_ID");
  37. String id = Integer.toString(id_kol);
  38. String imie = rs.getString("FIRST_NAME");
  39. String nazwisko = rs.getString("LAST_NAME");
  40. int placa = rs.getInt("SALARY");
  41. String zarobki = Integer.toString(placa);
  42.  
  43. textID.setText(id);
  44. textImie.setText(imie);
  45. textNaziwsko.setText(nazwisko);
  46. textZarobki.setText(zarobki);
  47.  
  48. }catch (SQLException err) {
  49. System.out.println(err.getMessage());
  50. }
  51. }
  52.  
  53.  
  54. @SuppressWarnings("unchecked")
  55. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  56. private void initComponents() {
  57.  
  58. jPanel1 = new javax.swing.JPanel();
  59. jLabel1 = new javax.swing.JLabel();
  60. textID = new javax.swing.JTextField();
  61. textImie = new javax.swing.JTextField();
  62. textNaziwsko = new javax.swing.JTextField();
  63. textZarobki = new javax.swing.JTextField();
  64. btPierwszy = new javax.swing.JButton();
  65. btNastepny = new javax.swing.JButton();
  66. btPoprzedni = new javax.swing.JButton();
  67. btOstatni = new javax.swing.JButton();
  68. btZakoncz = new javax.swing.JButton();
  69.  
  70. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  71.  
  72. jLabel1.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
  73. jLabel1.setText("Zarobki");
  74.  
  75. textID.addActionListener(new java.awt.event.ActionListener() {
  76. public void actionPerformed(java.awt.event.ActionEvent evt) {
  77. textIDActionPerformed(evt);
  78. }
  79. });
  80.  
  81. btPierwszy.setText("Pierwszy");
  82. btPierwszy.addActionListener(new java.awt.event.ActionListener() {
  83. public void actionPerformed(java.awt.event.ActionEvent evt) {
  84. btPierwszyActionPerformed(evt);
  85. }
  86. });
  87.  
  88. btNastepny.setText("Nastepny");
  89. btNastepny.addActionListener(new java.awt.event.ActionListener() {
  90. public void actionPerformed(java.awt.event.ActionEvent evt) {
  91. btNastepnyActionPerformed(evt);
  92. }
  93. });
  94.  
  95. btPoprzedni.setText("Poprzedni");
  96. btPoprzedni.addActionListener(new java.awt.event.ActionListener() {
  97. public void actionPerformed(java.awt.event.ActionEvent evt) {
  98. btPoprzedniActionPerformed(evt);
  99. }
  100. });
  101.  
  102. btOstatni.setText("Ostatni");
  103. btOstatni.addActionListener(new java.awt.event.ActionListener() {
  104. public void actionPerformed(java.awt.event.ActionEvent evt) {
  105. btOstatniActionPerformed(evt);
  106. }
  107. });
  108.  
  109. btZakoncz.setText("Zakoncz");
  110. btZakoncz.addActionListener(new java.awt.event.ActionListener() {
  111. public void actionPerformed(java.awt.event.ActionEvent evt) {
  112. btZakonczActionPerformed(evt);
  113. }
  114. });
  115.  
  116. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  117. jPanel1.setLayout(jPanel1Layout);
  118. jPanel1Layout.setHorizontalGroup(
  119. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  120. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  121. .addContainerGap()
  122. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  123. .addComponent(btZakoncz, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  124. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
  125. .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
  126. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  127. .addComponent(textZarobki))
  128. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
  129. .addComponent(btPierwszy, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE)
  130. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  131. .addComponent(btNastepny, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE)
  132. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  133. .addComponent(btPoprzedni, javax.swing.GroupLayout.DEFAULT_SIZE, 87, Short.MAX_VALUE)
  134. .addGap(10, 10, 10)
  135. .addComponent(btOstatni, javax.swing.GroupLayout.PREFERRED_SIZE, 77, javax.swing.GroupLayout.PREFERRED_SIZE))
  136. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
  137. .addComponent(textID, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
  138. .addGap(18, 18, 18)
  139. .addComponent(textNaziwsko, javax.swing.GroupLayout.PREFERRED_SIZE, 103, javax.swing.GroupLayout.PREFERRED_SIZE)
  140. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  141. .addComponent(textImie)))
  142. .addContainerGap())
  143. );
  144. jPanel1Layout.setVerticalGroup(
  145. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  146. .addGroup(jPanel1Layout.createSequentialGroup()
  147. .addContainerGap()
  148. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  149. .addComponent(textID, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
  150. .addComponent(textNaziwsko, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
  151. .addComponent(textImie, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE))
  152. .addGap(18, 18, 18)
  153. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  154. .addComponent(textZarobki, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
  155. .addComponent(jLabel1))
  156. .addGap(18, 18, 18)
  157. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  158. .addComponent(btPierwszy, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
  159. .addComponent(btNastepny, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
  160. .addComponent(btPoprzedni, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
  161. .addComponent(btOstatni, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE))
  162. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  163. .addComponent(btZakoncz, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
  164. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  165. );
  166.  
  167. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  168. getContentPane().setLayout(layout);
  169. layout.setHorizontalGroup(
  170. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  171. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  172. .addContainerGap()
  173. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  174. .addContainerGap())
  175. );
  176. layout.setVerticalGroup(
  177. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  178. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  179. .addContainerGap()
  180. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  181. .addContainerGap())
  182. );
  183.  
  184. pack();
  185. }// </editor-fold>
  186.  
  187. private void textIDActionPerformed(java.awt.event.ActionEvent evt) {
  188. // TODO add your handling code here:
  189. }
  190.  
  191. private void btPierwszyActionPerformed(java.awt.event.ActionEvent evt) {
  192. try {
  193. rs.first();
  194. int id_kol = rs.getInt("EMPLOYEE_ID");
  195. String id = Integer.toString(id_kol);
  196. String imie = rs.getString("FIRST_NAME");
  197. String nazwisko = rs.getString("LAST_NAME");
  198. int placa = rs.getInt("SALARY");
  199. String zarobki = Integer.toString(placa);
  200.  
  201. textID.setText(id);
  202. textImie.setText(imie);
  203. textNaziwsko.setText(nazwisko);
  204. textZarobki.setText(zarobki);
  205. } catch (SQLException err){
  206. JOptionPane.showMessageDialog(Bazaaaa.this, err.getMessage());
  207. }
  208.  
  209. }
  210.  
  211. private void btNastepnyActionPerformed(java.awt.event.ActionEvent evt) {
  212. try{
  213. if(rs.next()){
  214. int id_kol = rs.getInt("EMPLOYEE_ID");
  215. String id = Integer.toString(id_kol);
  216. String imie = rs.getString("FIRST_NAME");
  217. String nazwisko = rs.getString("LAST_NAME");
  218. int placa = rs.getInt("SALARY");
  219. String zarobki = Integer.toString(placa);
  220.  
  221. textID.setText(id);
  222. textImie.setText(imie);
  223. textNaziwsko.setText(nazwisko);
  224. textZarobki.setText(zarobki);
  225. } else {
  226. rs.previous();
  227. JOptionPane.showMessageDialog(Bazaaaa.this, "Koniec pliku");
  228. }
  229. } catch (SQLException err) {
  230. JOptionPane.showMessageDialog(Bazaaaa.this, err.getMessage());
  231. }
  232. // TODO add your handling code here:
  233. }
  234.  
  235. private void btPoprzedniActionPerformed(java.awt.event.ActionEvent evt) {
  236. try{
  237. if(rs.previous()){
  238. int id_kol = rs.getInt("EMPLOYEE_ID");
  239. String id = Integer.toString(id_kol);
  240. String imie = rs.getString("FIRST_NAME");
  241. String nazwisko = rs.getString("LAST_NAME");
  242. int placa = rs.getInt("SALARY");
  243. String zarobki = Integer.toString(placa);
  244.  
  245. textID.setText(id);
  246. textImie.setText(imie);
  247. textNaziwsko.setText(nazwisko);
  248. textZarobki.setText(zarobki);
  249. } else {
  250. rs.next();
  251. JOptionPane.showMessageDialog(Bazaaaa.this, "Początek pliku");
  252. }
  253. } catch (SQLException err) {
  254. JOptionPane.showMessageDialog(Bazaaaa.this, err.getMessage());
  255. }
  256. // TODO add your handling code here:
  257. }
  258.  
  259. private void btOstatniActionPerformed(java.awt.event.ActionEvent evt) {
  260. try {
  261. rs.last();
  262. int id_kol = rs.getInt("EMPLOYEE_ID");
  263. String id = Integer.toString(id_kol);
  264. String imie = rs.getString("FIRST_NAME");
  265. String nazwisko = rs.getString("LAST_NAME");
  266. int placa = rs.getInt("SALARY");
  267. String zarobki = Integer.toString(placa);
  268.  
  269. textID.setText(id);
  270. textImie.setText(imie);
  271. textNaziwsko.setText(nazwisko);
  272. textZarobki.setText(zarobki);
  273. } catch (SQLException err){
  274. JOptionPane.showMessageDialog(Bazaaaa.this, err.getMessage());
  275. }
  276. }
  277.  
  278. private void btZakonczActionPerformed(java.awt.event.ActionEvent evt) {
  279. System.exit(0); // TODO add your handling code here:
  280. }
  281.  
  282.  
  283. public static void main(String args[]) {
  284.  
  285. java.awt.EventQueue.invokeLater(new Runnable() {
  286. public void run() {
  287. new Bazaaaa().setVisible(true);
  288. }
  289. });
  290. }
  291.  
  292. // Variables declaration - do not modify
  293. private javax.swing.JButton btNastepny;
  294. private javax.swing.JButton btOstatni;
  295. private javax.swing.JButton btPierwszy;
  296. private javax.swing.JButton btPoprzedni;
  297. private javax.swing.JButton btZakoncz;
  298. private javax.swing.JLabel jLabel1;
  299. private javax.swing.JPanel jPanel1;
  300. private javax.swing.JTextField textID;
  301. private javax.swing.JTextField textImie;
  302. private javax.swing.JTextField textNaziwsko;
  303. private javax.swing.JTextField textZarobki;
  304. // End of variables declaration
  305. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!