我按如下步骤执行:
一、下载SQLite数据库的JDBC:http://www.zentus.com/sqlitejdbc/
二、将下载到的包解压后得到jar包放到%JAVA_HOME%\lib下,并且将其添加到ClassPath系统环境变量中。
然后使用sqlite,但是import org.sqlite.JDBC;出错,为什么呢
以下为代码:
import java.sql.*;
import org.sqlite.JDBC;
public class TestSQLite{
public static void main(String[] args){
try{
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:zieckey.db");
Statement stat = conn.createStatement();
stat.executeUpdate( "create table tbl1(name varchar(20), org.hibernate.QueryException: could not resolve property, salary int);" );
stat.executeUpdate( "insert into tbl1 values('ZhangSan',8000);" );
stat.executeUpdate( "insert into tbl1 values('LiSi',7800);" );
stat.executeUpdate( "insert into tbl1 values('WangWu',5800);" );
stat.executeUpdate( "insert into tbl1 values('ZhaoLiu', java.lang.NoClassDefFoundError: javax/servlet/http/,9100);" );
ResultSet rs = stat.executeQuery("select * from tbl1;");
while (rs.next()) {
System.out.print("name = " + rs.getString("name") + " ");
System.out.println("salary = " + rs.getString("salary")); }
rs.close();
conn.close();
}
catch( Exception e )
{
e.printStackTrace ( );
}
}
}
无满意答案
------解决方案--------------------------------------------------------
可参考:
CGI怎么连接SQLite http://www.myexception.cn/cgi/206265.html
相关的主题文章:
一、下载SQLite数据库的JDBC:http://www.zentus.com/sqlitejdbc/
二、将下载到的包解压后得到jar包放到%JAVA_HOME%\lib下,并且将其添加到ClassPath系统环境变量中。
然后使用sqlite,但是import org.sqlite.JDBC;出错,为什么呢
以下为代码:
import java.sql.*;
import org.sqlite.JDBC;
public class TestSQLite{
public static void main(String[] args){
try{
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:zieckey.db");
Statement stat = conn.createStatement();
stat.executeUpdate( "create table tbl1(name varchar(20), org.hibernate.QueryException: could not resolve property, salary int);" );
stat.executeUpdate( "insert into tbl1 values('ZhangSan',8000);" );
stat.executeUpdate( "insert into tbl1 values('LiSi',7800);" );
stat.executeUpdate( "insert into tbl1 values('WangWu',5800);" );
stat.executeUpdate( "insert into tbl1 values('ZhaoLiu', java.lang.NoClassDefFoundError: javax/servlet/http/,9100);" );
ResultSet rs = stat.executeQuery("select * from tbl1;");
while (rs.next()) {
System.out.print("name = " + rs.getString("name") + " ");
System.out.println("salary = " + rs.getString("salary")); }
rs.close();
conn.close();
}
catch( Exception e )
{
e.printStackTrace ( );
}
}
}
无满意答案
------解决方案--------------------------------------------------------
可参考:
CGI怎么连接SQLite http://www.myexception.cn/cgi/206265.html
相关的主题文章: