Guest User

Untitled

a guest
Jan 15th, 2019
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. try {
  2. String driver = "com.mysql.jdbc.Driver";
  3. Class.forName(driver).newInstance();
  4. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull","root","P@typd79");
  5. Statement stmt = con.createStatement();
  6. String query = "INSERT INTO project_one.personal_info(ssn,name,street,city,state,zip,class,degree,s,imm) VALUES"
  7. + "(" + social + "," + Name + "," + Address + "," + City + "," + State + "," + Zip
  8. + "," + Year + "," + Degree + "," + HS + "," + IMM + ")";
  9.  
  10. stmt.executeUpdate(query);
  11. JOptionPane.showMessageDialog(null, "New student added successfully");
  12.  
  13. } catch (Exception e) {
  14.  
  15. JOptionPane.showMessageDialog(null,"Data not saved: " + e,"Error",JOptionPane.ERROR_MESSAGE);
  16.  
  17. }
  18.  
  19. }
  20.  
  21. .;C:j2sdk1.4.2_16jrelib;
  22. C:Program Filesmysql-connector-java-3.1.144mysql-connector-java-3.1.14-bin.jar
  23.  
  24. java -cp ".;C:j2sdk1.4.2_16jrelib;
  25. C:Program Filesmysql-connector-java-3.1.144mysql-connector-java-3.1.14-bin.jar"
  26. my.class.Name
Add Comment
Please, Sign In to add comment