API tools faq
paste
Guest User

Untitled

a guest
Oct 31st, 2017
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.68 KB | None | 0 0
raw download clone embed print report
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.PreparedStatement;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6. import java.sql.Statement;
  7. import javax.swing.JOptionPane;
  8.  
  9. /*
  10. * To change this license header, choose License Headers in Project Properties.
  11. * To change this template file, choose Tools | Templates
  12. * and open the template in the editor.
  13. */
  14.  
  15. /**
  16. *
  17. * @author User
  18. */
  19. public class NovoJFrame extends javax.swing.JFrame {
  20.  
  21. PreparedStatement stl;
  22. ResultSet rs;
  23. Connection con;
  24.  
  25.  
  26.  
  27. public NovoJFrame() {
  28. initComponents();
  29.  
  30. IniciarBD();
  31.  
  32. this.PrencherComboBox();
  33.  
  34. jPanel3.setVisible(false);
  35. }
  36.  
  37.  
  38. public void PrencherComboBox(){
  39. String sql = "Select * from ALUNO";
  40. try {
  41.  
  42. stl = con.prepareStatement(sql);
  43. rs = stl.executeQuery();
  44.  
  45. while(rs.next()){
  46. jComboBox1.addItem(rs.getString("NOME"));
  47. }
  48. } catch(SQLException ex){
  49. JOptionPane.showMessageDialog(null,ex);
  50. }
  51.  
  52. }
  53.  
  54.  
  55.  
  56.  
  57.  
  58. @SuppressWarnings("unchecked")
  59. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  60. private void initComponents() {
  61.  
  62. jPanel1 = new javax.swing.JPanel();
  63. jLabel6 = new javax.swing.JLabel();
  64. jPanel2 = new javax.swing.JPanel();
  65. jButton1 = new javax.swing.JButton();
  66. jLabel7 = new javax.swing.JLabel();
  67. jComboBox1 = new javax.swing.JComboBox<>();
  68. jLabel1 = new javax.swing.JLabel();
  69. jLabel3 = new javax.swing.JLabel();
  70. jComboBox2 = new javax.swing.JComboBox<>();
  71. jButton2 = new javax.swing.JButton();
  72. jPanel3 = new javax.swing.JPanel();
  73. jLabel5 = new javax.swing.JLabel();
  74. jLabel4 = new javax.swing.JLabel();
  75. jLabel8 = new javax.swing.JLabel();
  76. jButton3 = new javax.swing.JButton();
  77.  
  78. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  79. setBackground(java.awt.Color.blue);
  80.  
  81. jPanel1.setBackground(new java.awt.Color(0, 51, 255));
  82. jPanel1.setForeground(new java.awt.Color(204, 255, 51));
  83.  
  84. jLabel6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/liceu terras.png"))); // NOI18N
  85.  
  86. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  87. jPanel1.setLayout(jPanel1Layout);
  88. jPanel1Layout.setHorizontalGroup(
  89. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  90. .addGroup(jPanel1Layout.createSequentialGroup()
  91. .addGap(265, 265, 265)
  92. .addComponent(jLabel6)
  93. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  94. );
  95. jPanel1Layout.setVerticalGroup(
  96. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  97. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  98. .addContainerGap(33, Short.MAX_VALUE)
  99. .addComponent(jLabel6)
  100. .addGap(31, 31, 31))
  101. );
  102.  
  103. jPanel2.setBackground(new java.awt.Color(255, 255, 0));
  104.  
  105. jButton1.setFont(new java.awt.Font("Tahoma", 0, 36)); // NOI18N
  106. jButton1.setText("Visualizar Tempo");
  107. jButton1.addActionListener(new java.awt.event.ActionListener() {
  108. public void actionPerformed(java.awt.event.ActionEvent evt) {
  109. jButton1ActionPerformed(evt);
  110. }
  111. });
  112.  
  113. jLabel7.setIcon(new javax.swing.ImageIcon(getClass().getResource("/med grande.png"))); // NOI18N
  114.  
  115. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  116. jPanel2.setLayout(jPanel2Layout);
  117. jPanel2Layout.setHorizontalGroup(
  118. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  119. .addGroup(jPanel2Layout.createSequentialGroup()
  120. .addGap(19, 19, 19)
  121. .addComponent(jLabel7)
  122. .addGap(40, 40, 40)
  123. .addComponent(jButton1)
  124. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  125. );
  126. jPanel2Layout.setVerticalGroup(
  127. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  128. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
  129. .addContainerGap(100, Short.MAX_VALUE)
  130. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  131. .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 77, javax.swing.GroupLayout.PREFERRED_SIZE)
  132. .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 79, javax.swing.GroupLayout.PREFERRED_SIZE))
  133. .addGap(61, 61, 61))
  134. );
  135.  
  136. jComboBox1.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
  137.  
  138. jLabel1.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
  139. jLabel1.setText("Aluno:");
  140.  
  141. jLabel3.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
  142. jLabel3.setText("Quantidade:");
  143.  
  144. jComboBox2.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
  145. jComboBox2.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
  146.  
  147. jButton2.setFont(new java.awt.Font("Tahoma", 0, 36)); // NOI18N
  148. jButton2.setText("Adicionar");
  149. jButton2.addActionListener(new java.awt.event.ActionListener() {
  150. public void actionPerformed(java.awt.event.ActionEvent evt) {
  151. jButton2ActionPerformed(evt);
  152. }
  153. });
  154.  
  155. jLabel5.setFont(new java.awt.Font("Tahoma", 0, 36)); // NOI18N
  156. jLabel5.setForeground(new java.awt.Color(51, 255, 0));
  157. jLabel5.setText("Com Sucesso");
  158.  
  159. jLabel4.setFont(new java.awt.Font("Tahoma", 0, 36)); // NOI18N
  160. jLabel4.setForeground(new java.awt.Color(0, 255, 0));
  161. jLabel4.setText("Operação Realizada");
  162.  
  163. jLabel8.setIcon(new javax.swing.ImageIcon(getClass().getResource("/simbolo dinheiro.png"))); // NOI18N
  164.  
  165. javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
  166. jPanel3.setLayout(jPanel3Layout);
  167. jPanel3Layout.setHorizontalGroup(
  168. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  169. .addGroup(jPanel3Layout.createSequentialGroup()
  170. .addContainerGap()
  171. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  172. .addGroup(jPanel3Layout.createSequentialGroup()
  173. .addComponent(jLabel4)
  174. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  175. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
  176. .addGap(0, 0, Short.MAX_VALUE)
  177. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  178. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
  179. .addComponent(jLabel8)
  180. .addGap(115, 115, 115))
  181. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
  182. .addComponent(jLabel5)
  183. .addGap(51, 51, 51))))))
  184. );
  185. jPanel3Layout.setVerticalGroup(
  186. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  187. .addGroup(jPanel3Layout.createSequentialGroup()
  188. .addContainerGap()
  189. .addComponent(jLabel8)
  190. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  191. .addComponent(jLabel4)
  192. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  193. .addComponent(jLabel5)
  194. .addContainerGap(30, Short.MAX_VALUE))
  195. );
  196.  
  197. jButton3.setFont(new java.awt.Font("Tahoma", 0, 36)); // NOI18N
  198. jButton3.setText("Status");
  199.  
  200. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  201. getContentPane().setLayout(layout);
  202. layout.setHorizontalGroup(
  203. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  204. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  205. .addGroup(layout.createSequentialGroup()
  206. .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  207. .addContainerGap())
  208. .addGroup(layout.createSequentialGroup()
  209. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  210. .addGroup(layout.createSequentialGroup()
  211. .addComponent(jLabel1)
  212. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  213. .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 173, javax.swing.GroupLayout.PREFERRED_SIZE))
  214. .addGroup(layout.createSequentialGroup()
  215. .addComponent(jLabel3)
  216. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  217. .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  218. .addGroup(layout.createSequentialGroup()
  219. .addComponent(jButton2)
  220. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  221. .addComponent(jButton3)))
  222. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  223. .addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  224. .addGap(116, 116, 116))
  225. );
  226. layout.setVerticalGroup(
  227. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  228. .addGroup(layout.createSequentialGroup()
  229. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  230. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  231. .addGroup(layout.createSequentialGroup()
  232. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  233. .addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  234. .addGap(6, 6, 6))
  235. .addGroup(layout.createSequentialGroup()
  236. .addGap(26, 26, 26)
  237. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  238. .addComponent(jLabel1)
  239. .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  240. .addGap(29, 29, 29)
  241. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  242. .addComponent(jLabel3)
  243. .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  244. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  245. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  246. .addComponent(jButton2)
  247. .addComponent(jButton3))
  248. .addGap(32, 32, 32)))
  249. .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  250. );
  251.  
  252. pack();
  253. }// </editor-fold>
  254.  
  255. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  256. // TODO add your handling code here:
  257. jPanel3.setVisible(true);
  258. }
  259.  
  260. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  261. // TODO add your handling code here:
  262. med frame = new med();
  263.  
  264. frame.setVisible(true);
  265. }
  266.  
  267. /**
  268. * @param args the command line arguments
  269. */
  270. public static void main(String args[]) {
  271.  
  272.  
  273.  
  274.  
  275.  
  276.  
  277. java.awt.EventQueue.invokeLater(new Runnable() {
  278. public void run() {
  279. new NovoJFrame().setVisible(true);
  280. }
  281. });
  282. }
  283.  
  284. // Variables declaration - do not modify
  285. private javax.swing.JButton jButton1;
  286. private javax.swing.JButton jButton2;
  287. private javax.swing.JButton jButton3;
  288. private javax.swing.JComboBox<String> jComboBox1;
  289. private javax.swing.JComboBox<String> jComboBox2;
  290. private javax.swing.JLabel jLabel1;
  291. private javax.swing.JLabel jLabel3;
  292. private javax.swing.JLabel jLabel4;
  293. private javax.swing.JLabel jLabel5;
  294. private javax.swing.JLabel jLabel6;
  295. private javax.swing.JLabel jLabel7;
  296. private javax.swing.JLabel jLabel8;
  297. private javax.swing.JPanel jPanel1;
  298. private javax.swing.JPanel jPanel2;
  299. private javax.swing.JPanel jPanel3;
  300. // End of variables declaration
  301.  
  302.  
  303. private void IniciarBD(){
  304.  
  305. try {
  306. Class.forName("org.apache.derby.jdbc.ClientDriver");
  307. } catch ( ClassNotFoundException e){
  308. System.out.println("Erro :" + e.getMessage() );
  309. }
  310.  
  311. String url = "jdbc:derby://localhost:1527/bd" ;
  312. String user = "root" ;
  313. String pass = "senha" ;
  314.  
  315.  
  316. try {
  317. Connection con = DriverManager.getConnection( url, user, pass );
  318.  
  319. Statement stmt = con.createStatement();
  320.  
  321. System.out.println("Conexão Realizada com Sucesso");
  322. } catch (SQLException e) {
  323. System.out.println("Erro :" + e.getMessage() );
  324. }
  325.  
  326. }
  327. }
  328.  
  329. Connection con = null;
  330.  
  331. stl = con.prepareStatement(sql); // con = null
  332.  
  333. rs = stl.executeQuery();
  334. jComboBox1.addItem(rs.getString("NOME"));
Add Comment
Please, Sign In to add comment
Public Pastes
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!