java报错 无效字符_写入数据库为啥报的无效字符错误

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

import java.io.BufferedInputStream;

import java.io.BufferedReader;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class JDBCDemo {

public static void main(String[] args) {

File file=new File("D:\\航班\\航班.txt");

BufferedReader reader;

try {

reader = new BufferedReader(new InputStreamReader(new FileInputStream(file)));

try {

String str=reader.readLine();

String []strs=str.split(" ");

User user=new User(strs[0],strs[1],strs[2],strs[3],strs[4],strs[5],strs[6],strs[7]);

insert(user);

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void insert(User u) {

String begin=u.getBegin();

String end=u.getEnd();

int day=u.getDay();

String name=u.getName();

String begtime=u.getBegtime();

String endtime=u.getEndtime();

int price=u.getPrice();

String pricetag=u.getPricetag();

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","123");

Statement stmt=conn.createStatement();

String sql="insert into plane values('" +u.getBegin()+"','"+u.getEnd()+"',"+u.getDay()+",'"+u.getName()+"','"+u.getBegtime()+"','"+u.getEndtime()+"',"+u.getPrice()+",'"+u.getPricetag()+"');";

int i=stmt.executeUpdate(sql);

if(i==1){

System.out.println("成功插入一个用户到数据库");

}

else{

System.out.println("插入用户失败");

}

conn.close();

stmt.close();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

class User{

public String begin;

public String end;

public int day;

public String name;

public String begtime;

public String endtime;

public int price;

public String pricetag;

private void User() {

}

User(String begin,String end,String name,String begtime,String endtime,int price,String pricetag){

this.begin=begin;

this.end=end;

this.day=day;

this.name=name;

this.begtime=begtime;

this.endtime=endtime;

this.price=price;

this.pricetag=pricetag;

}

public User(String[] string, String[] string2, String[] string3, String[] string4,

String[] string5, String[] string6, String[] string7, String[] string8) {

// TODO Auto-generated constructor stub

}

public User(String string, String string2, String string3, String string4,

String string5, String string6, String string7, String string8) {

// TODO Auto-generated constructor stub

}

public String getBegin() {

return begin;

}

public void setBegin(String begin) {

this.begin = begin;

}

public String getEnd() {

return end;

}

public void setEnd(String end) {

this.end = end;

}

public int getDay() {

return day;

}

public void setDay(int day) {

this.day = day;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getBegtime() {

return begtime;

}

public void setBegtime(String begtime) {

this.begtime = begtime;

}

public String getEndtime() {

return endtime;

}

public void setEndtime(String endtime) {

this.endtime = endtime;

}

public int getPrice() {

return price;

}

public void setPrice(int price) {

this.price = price;

}

public String getPricetag() {

return pricetag;

}

public void setPricetag(String pricetag) {

this.pricetag = pricetag;

}

}

报错：

java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)

at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)

at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)

at netThread.JDBCDemo.insert(JDBCDemo.java:60)

at netThread.JDBCDemo.main(JDBCDemo.java:29)

我没写错啊那个insert语句 有大神来帮忙看看吗