Guest User

Untitled

a guest
Mar 24th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. try {
  2. Connection con = DriverManager.getConnection("jdbc:sqlite:myDB.sqlite");
  3. PreparedStatement pstm = con.prepareStatement("insert into hell(username,pssword) " +
  4. "values ('"+tfUname.getText()+"','"+tfUpass.getText()+"')");
  5.  
  6. pstm.close();
  7. con.close();
  8. JOptionPane.showMessageDialog(null,"Congrats, you have been registered succesfully");
  9. RegisterWindow rw = new RegisterWindow();
  10. rw.setVisible(false);
  11. pack();
  12. dispose();
  13. } catch(SQLException ex) {
  14. setTitle(ex.toString());
  15. }
  16.  
  17. "java.sql.SQLException: No suitable driver found for jdbc:sqlite:C\LoginJava2\myDB.sqlite"
  18.  
  19. Class.forName("org.sqlite.JDBC");
  20.  
  21. <dependency>
  22. <groupId>org.xerial</groupId>
  23. <artifactId>sqlite-jdbc</artifactId>
  24. <version>3.15.1
  25. </version>
  26. </dependency>
  27.  
  28. DriverManager.getConnection("D:\db\my-db.sqlite").
  29.  
  30. DriverManager.getConnection("jdbc:sqlite:D:\db\my-db.sqlite").
  31.  
  32. static {
  33. try {
  34. DriverManager.registerDriver(new JDBC());
  35. }
  36. catch (SQLException e) {
  37. e.printStackTrace();
  38. }
  39. }
  40.  
  41. DriverManager.registerDriver(new JDBC());
  42.  
  43. <plugins>
  44. <!-- any other plugins -->
  45. <plugin>
  46. <artifactId>maven-assembly-plugin</artifactId>
  47. <executions>
  48. <execution>
  49. <phase>package</phase>
  50. <goals>
  51. <goal>single</goal>
  52. </goals>
  53. </execution>
  54. </executions>
  55. <configuration>
  56. <archive>
  57. <manifest>
  58. <addDefaultImplementationEntries>true</addDefaultImplementationEntries>
  59. <addDefaultSpecificationEntries>true</addDefaultSpecificationEntries>
  60. <addClasspath>true</addClasspath>
  61. <mainClass>MyPackage.Main</mainClass>
  62. </manifest>
  63. </archive>
  64. <descriptorRefs>
  65. <descriptorRef>jar-with-dependencies</descriptorRef>
  66. </descriptorRefs>
  67. </configuration>
  68. </plugin>
  69. </plugins>
Add Comment
Please, Sign In to add comment