58,454
社区成员
发帖
与我相关
我的任务
分享
30.conn=DriverManager.getConnection("jdbc:sqlite:d:/Iotek/sqlite/company.db");
35.String str="delete from employee where name='张三'"
+ "update employee set gender='男' where name='李四'"
+ "select * from employee";
42.employee=new Employee(rs.getInt(1),rs.getString(2),rs.getInt(3),rs.getString(4).charAt(0),rs.getDouble(5),rs.getString(6));
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "update": syntax error)
at org.sqlite.core.DB.newSQLException(DB.java:890)
at org.sqlite.core.DB.newSQLException(DB.java:901)
at org.sqlite.core.DB.throwex(DB.java:868)
at org.sqlite.core.NativeDB.prepare(Native Method)
at org.sqlite.core.DB.prepare(DB.java:211)
at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81)
at JDBCDemo.DBTest.fetchData(DBTest.java:39)
at JDBCDemo.DBTest.main(DBTest.java:14)
package JDBCDemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class DBTest {
public static void main(String[] args) {
List<Employee> list=fetchData();
for(Employee e:list){
System.out.println(e);
}
}
//执行SQL语句更改DB数据,返回更改后数据
private static List<Employee> fetchData() {
//新建一个list对象用于存放Employee对象(对应DB中每条数据)
List<Employee> list=new ArrayList<Employee>();
Employee employee=null;
Connection conn=null;
try {
//1.加载数据库驱动程序
//返回与带有给定字符串名的类或接口相关联的 Class 对象。
Class.forName("org.sqlite.JDBC");
//2.建立连接
conn=DriverManager.getConnection("jdbc:sqlite:d:/Iotek/sqlite/company.db");
//3.由Connection对象的createStatement方法创建
// Statement对象用于发送简单的SQL语句
Statement sm=conn.createStatement();
//4.书写SQL语句
String str="delete from employee where name='张三'"
+ "update employee set gender='男' where name='李四'"
+ "select * from employee";
//5.执行SQL语句,返回结果集
ResultSet rs=sm.executeQuery(str);
//6.将结果集中的属性值赋给Employee对象
while(rs.next()){
employee=new Employee(rs.getInt(1),rs.getString(2),rs.getInt(3),rs.getString(4).charAt(0),rs.getDouble(5),rs.getString(6));
list.add(employee);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
finally{
//关闭连接
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return list;
}
}