API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 4th, 2017
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.31 KB | None | 0 0
raw download clone embed print report
  1. //MUDE AQUI E COLOQUE O PACOTE DE ACORDO COM O SEU PROJETO
  2. //DICA: OLHE O PACKAGE QUE OUTRA CLASSE DO SEU PROJETO EST� E COLOQUE O MESMO!
  3.  
  4.  
  5. //Classes necessárias para uso de Banco de dados //
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.SQLException;
  9.  
  10.  
  11.  
  12. public class ConexaoMySQL {
  13.  
  14. private static ConexaoMySQL instance = null;
  15. private Connection connection = null;
  16.  
  17.  
  18. private ConexaoMySQL() {
  19. try {
  20.  
  21. String driverName = "com.mysql.jdbc.Driver";
  22. Class.forName(driverName);
  23.  
  24. String serverName = "127.0.0.1";
  25.  
  26. //nesta linha estar� o nome do seu banco de dados. Olhe no workbench
  27. //o nome do banco. Caso voce tenha criado o modelo no workbench e n�o
  28. //tenha modificado o nome do banco, o nome padr�o � "mydb".
  29. String dbName = "bancodadoscursos";
  30. String url = "jdbc:mysql://" +
  31. serverName + "/" +
  32. dbName;
  33.  
  34. //ajuste o username e password de acordo com o que voce utiliza para
  35. //acessar o banco
  36. String username = "root";
  37. String password = "123muda123";
  38.  
  39. connection = DriverManager.getConnection(url,
  40. username, password);
  41.  
  42. if (connection != null) {
  43. System.out.println("STATUS--->Conectado "
  44. + "com sucesso!");
  45. } else {
  46. System.err.println("STATUS--->Não foi "
  47. + "possivel realizar conexão");
  48. }
  49. connection.setAutoCommit(true);
  50. } catch (ClassNotFoundException e) {
  51.  
  52. System.out.println("O driver expecificado"
  53. + " nao foi encontrado.");
  54. } catch (SQLException e) {
  55.  
  56. System.out.println("Nao foi possivel"
  57. + " conectar ao Banco de Dados.");
  58. e.printStackTrace();
  59. }
  60. }
  61.  
  62. public static ConexaoMySQL getInstance() {
  63. if (instance == null) {
  64. instance = new ConexaoMySQL();
  65. }
  66. return instance;
  67. }
  68.  
  69. public java.sql.Connection getConnection() {
  70. return connection;
  71. }
  72.  
  73.  
  74. }
  75.  
  76.  
  77.  
  78.  
  79.  
  80.  
  81.  
  82.  
  83.  
  84.  
  85.  
  86.  
  87.  
  88.  
  89.  
  90.  
  91.  
  92.  
  93.  
  94.  
  95.  
  96.  
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105.  
  106.  
  107.  
  108. import java.sql.Connection;
  109. import java.sql.SQLException;
  110.  
  111. /*
  112. * To change this license header, choose License Headers in Project Properties.
  113. * To change this template file, choose Tools | Templates
  114. * and open the template in the editor.
  115. */
  116.  
  117. /**
  118. *
  119. * @author Picasso
  120. */
  121. public class CadastroDisciplinasForm extends javax.swing.JFrame {
  122.  
  123. private String cmd;
  124. private Object ConexaoMySQL;
  125.  
  126. /**
  127. * Creates new form CadastroDisciplinasForm
  128. */
  129. public CadastroDisciplinasForm() {
  130. initComponents();
  131. }
  132.  
  133. /**
  134. * This method is called from within the constructor to initialize the form.
  135. * WARNING: Do NOT modify this code. The content of this method is always
  136. * regenerated by the Form Editor.
  137. */
  138. @SuppressWarnings("unchecked")
  139. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  140. private void initComponents() {
  141.  
  142. jLabel1 = new javax.swing.JLabel();
  143. jLabel2 = new javax.swing.JLabel();
  144. jLabel3 = new javax.swing.JLabel();
  145. jLabel4 = new javax.swing.JLabel();
  146. jLabel5 = new javax.swing.JLabel();
  147. jTextFieldNomeDisciplina = new javax.swing.JTextField();
  148. jTextFieldCargaHoraria = new javax.swing.JTextField();
  149. jButton1 = new javax.swing.JButton();
  150. jButton2 = new javax.swing.JButton();
  151. jTextFieldCursoPertencente = new javax.swing.JTextField();
  152. jTextFieldNumeroVagas = new javax.swing.JTextField();
  153. jTextFieldPeriodo = new javax.swing.JTextField();
  154.  
  155. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  156.  
  157. jLabel1.setText("Nome da Disciplina:");
  158.  
  159. jLabel2.setText("Carga Horária:");
  160.  
  161. jLabel3.setText("Curso Pertencente:");
  162.  
  163. jLabel4.setText("Número de Vagas:");
  164.  
  165. jLabel5.setText("Período:");
  166.  
  167. jButton1.setText("Cancelar");
  168. jButton1.addActionListener(new java.awt.event.ActionListener() {
  169. public void actionPerformed(java.awt.event.ActionEvent evt) {
  170. jButton1ActionPerformed(evt);
  171. }
  172. });
  173.  
  174. jButton2.setText("Cadastrar");
  175. jButton2.addActionListener(new java.awt.event.ActionListener() {
  176. public void actionPerformed(java.awt.event.ActionEvent evt) {
  177. jButton2ActionPerformed(evt);
  178. }
  179. });
  180.  
  181. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  182. getContentPane().setLayout(layout);
  183. layout.setHorizontalGroup(
  184. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  185. .addGroup(layout.createSequentialGroup()
  186. .addGap(19, 19, 19)
  187. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  188. .addGroup(layout.createSequentialGroup()
  189. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  190. .addComponent(jLabel1)
  191. .addComponent(jLabel2))
  192. .addGap(18, 18, 18)
  193. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  194. .addComponent(jTextFieldNomeDisciplina, javax.swing.GroupLayout.PREFERRED_SIZE, 211, javax.swing.GroupLayout.PREFERRED_SIZE)
  195. .addComponent(jTextFieldCargaHoraria, javax.swing.GroupLayout.PREFERRED_SIZE, 211, javax.swing.GroupLayout.PREFERRED_SIZE)))
  196. .addGroup(layout.createSequentialGroup()
  197. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  198. .addComponent(jLabel3)
  199. .addComponent(jLabel4)
  200. .addComponent(jLabel5))
  201. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  202. .addGroup(layout.createSequentialGroup()
  203. .addGap(16, 16, 16)
  204. .addComponent(jTextFieldCursoPertencente, javax.swing.GroupLayout.PREFERRED_SIZE, 211, javax.swing.GroupLayout.PREFERRED_SIZE))
  205. .addGroup(layout.createSequentialGroup()
  206. .addGap(18, 18, 18)
  207. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  208. .addComponent(jTextFieldNumeroVagas)
  209. .addComponent(jTextFieldPeriodo))))))
  210. .addContainerGap(22, Short.MAX_VALUE))
  211. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  212. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  213. .addComponent(jButton2)
  214. .addGap(30, 30, 30)
  215. .addComponent(jButton1)
  216. .addGap(20, 20, 20))
  217. );
  218. layout.setVerticalGroup(
  219. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  220. .addGroup(layout.createSequentialGroup()
  221. .addGap(23, 23, 23)
  222. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  223. .addComponent(jLabel1)
  224. .addComponent(jTextFieldNomeDisciplina, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  225. .addGap(18, 18, 18)
  226. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  227. .addComponent(jLabel2)
  228. .addComponent(jTextFieldCargaHoraria, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  229. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  230. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  231. .addComponent(jLabel3)
  232. .addComponent(jTextFieldCursoPertencente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  233. .addGap(18, 18, 18)
  234. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  235. .addComponent(jLabel4)
  236. .addComponent(jTextFieldNumeroVagas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  237. .addGap(18, 18, 18)
  238. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  239. .addComponent(jLabel5)
  240. .addComponent(jTextFieldPeriodo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  241. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 17, Short.MAX_VALUE)
  242. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  243. .addComponent(jButton1)
  244. .addComponent(jButton2))
  245. .addContainerGap())
  246. );
  247.  
  248. pack();
  249. }// </editor-fold>
  250.  
  251. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  252. // TODO add your handling code here:
  253. dispose();
  254. }
  255.  
  256. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  257. try {
  258. // TODO add your handling code here:
  259. String insert = "insert into disciplinas (NomeDisciplina, CargaHoraria, CursoPertencente, NumeroVagas, Periodo) VALUES ('"+
  260. jTextFieldNomeDisciplina.getText()+"', "+jTextFieldCargaHoraria.getText()+", '"+jTextFieldCursoPertencente.getText()+"', "+jTextFieldNumeroVagas.getText()+", "+jTextFieldPeriodo.getText()+"')";
  261.  
  262. Connection conec = ConexaoMySQL.getInstance().getConnection();
  263. conec.createStatement().executeUpdate(insert);
  264.  
  265. } catch (SQLException ex) {
  266. }
  267.  
  268. }
  269.  
  270. /**
  271. * @param args the command line arguments
  272. */
  273. public static void main(String args[]) {
  274. /* Set the Nimbus look and feel */
  275. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  276. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  277. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  278. */
  279. try {
  280. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  281. if ("Nimbus".equals(info.getName())) {
  282. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  283. break;
  284. }
  285. }
  286. } catch (ClassNotFoundException ex) {
  287. java.util.logging.Logger.getLogger(CadastroDisciplinasForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  288. } catch (InstantiationException ex) {
  289. java.util.logging.Logger.getLogger(CadastroDisciplinasForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  290. } catch (IllegalAccessException ex) {
  291. java.util.logging.Logger.getLogger(CadastroDisciplinasForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  292. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  293. java.util.logging.Logger.getLogger(CadastroDisciplinasForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  294. }
  295. //</editor-fold>
  296.  
  297. /* Create and display the form */
  298. java.awt.EventQueue.invokeLater(new Runnable() {
  299. public void run() {
  300. new CadastroDisciplinasForm().setVisible(true);
  301. }
  302. });
  303. }
  304.  
  305. // Variables declaration - do not modify
  306. private javax.swing.JButton jButton1;
  307. private javax.swing.JButton jButton2;
  308. private javax.swing.JLabel jLabel1;
  309. private javax.swing.JLabel jLabel2;
  310. private javax.swing.JLabel jLabel3;
  311. private javax.swing.JLabel jLabel4;
  312. private javax.swing.JLabel jLabel5;
  313. private javax.swing.JTextField jTextFieldCargaHoraria;
  314. private javax.swing.JTextField jTextFieldCursoPertencente;
  315. private javax.swing.JTextField jTextFieldNomeDisciplina;
  316. private javax.swing.JTextField jTextFieldNumeroVagas;
  317. private javax.swing.JTextField jTextFieldPeriodo;
  318. // End of variables declaration
  319. }
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!