thanks for the replay...
i've following package.
Code:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package SQLite_DAL;
import java.sql.*;
/**
*
* @author Srihari
*/
public class SQLite_Database {
public String Data() {
return "Srihari";
}
public Connection GetConnection(String db_Path)
throws ClassNotFoundException {
Connection connection = null;
try {
Class.forName("org.sqlite.JDBC");
connection = DriverManager.getConnection("jdbc:sqlite:" + db_Path);
} catch (SQLException e) {
}
return connection;
}
public String GetEmployeeData(Connection connection, String query)
throws SQLException {
String data = "";
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(query);
while (rs.next()) {
data += rs.getString(1) + ",";
}
rs.close();
statement.close();
return data;
}
}
i created a jar file using
Code:
jar cvf SQLite_DAL.jar SQLite_DAL_DirectoryName
sqlitejdbc-v056.jar(driver) and SQLite_DAL.jar(it returns connectionstring .. etc..) both are in same directory "D:\Libraries\"
and added as a library for another project(JavaApplication_KMF_Test)
JavaApplication_KMF_Test project contains following class
Code:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import SQLite_DAL.SQLite_Database;
import java.sql.Connection;
import java.sql.SQLException;
/**
*
* @author Srihari
*/
public class JavaApplication_KMF_Test {
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
// TODO code application logic here
SQLite_Database objSQLite_Database = new SQLite_Database();
String name = objSQLite_Database.Data();
System.out.println(name);
Connection connection = null;
try {
connection = objSQLite_Database.GetConnection("D:\\SQLiteDB\\EMPLOYEE.db");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println(e.getMessage());
}
try {
String employeeData = objSQLite_Database.GetEmployeeData(
connection, "SELECT EMPNAME FROM EMPLOYEEDETAILS");
System.out.println(employeeData);
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println(e.getMessage());
}
}
}
path for above class was "C:\Users\Srihari\Documents\NetBeansProjects\JavaApplication_KMF_Test\src\"
now i am trying to execute from windows command prompt
Compiling
Code:
C:\Users\Srihari\Documents\NetBeansProjects\JavaApplication_KMF_Test\src>java -c
lasspath "D:\Libraries\SQLite_DAL.jar;D:\Libraries\sqlitejdbc-v056.jar" SQLite_D
AL.JavaApplication_KMF_Test
succeed...
Run
now i am getting
Code:
C:\Users\Srihari\Documents\NetBeansProjects\JavaApplication_KMF_Test\src>java -c
lasspath "D:\Libraries\SQLite_DAL.jar;D:\Libraries\sqlitejdbc-v056.jar" SQLite_D
AL.JavaApplication_KMF_Test
Exception in thread "main" java.lang.NoClassDefFoundError: SQLite_DAL/JavaApplic
ation_KMF_Test
Caused by: java.lang.ClassNotFoundException: SQLite_DAL.JavaApplication_KMF_Test
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Could not find the main class: SQLite_DAL.JavaApplication_KMF_Test. Program wil
l exit.
C:\Users\Srihari\Documents\NetBeansProjects\JavaApplication_KMF_Test\src>
please help me..
Reply With Quote
Bookmarks