java 连接oracle 写一个登陆注册,提示 缺失 SELECT 关键字 大神求解
package day03;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;
public class regUser {
public static void main(String[] args) {
System.out.println("请输入选项" );
System.out.println("1:注册");
System.out.println("2:登录");
System.out.println("3:修改");
System.out.println("4:删除");
System.out.println("5:查询");
Scanner scanner=new Scanner(System.in);
int option=Integer.parseInt(scanner.nextLine().trim());
switch(option){
case 1:
regUser(scanner);
break;
case 2:
break;
case 3:
break;
case 4:
break;
}
}
public static void regUser(Scanner scanner){
try{
System.out.println("现在是注册操作");
System.out.println("请输入账户");
String user=scanner.nextLine().trim();
System.out.println("请输入密码");
String pwd=scanner.nextLine().trim();
System.out.println("请输入账户金额度");
String money=scanner.nextLine().trim();
System.out.println("请输入邮箱地址");
String email=scanner.nextLine().trim();
//创建连接
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.201:1521:orcl",
"system","power123A" );
Statement state=conn.createStatement();
String idSql="SELECT MAX(id) id FROM user2";
ResultSet rs=state.executeQuery(idSql);
int id=-1;
if(rs.next()){
id=rs.getInt("id");
}
//统计最大值后,对id加一
id++;
rs.close();
String sql="INSERT INTO user2 VALUESE("+id+",'"+user+"','"+pwd+"',"+money+",'"+email+"')";
System.out.println(sql);
if(state.executeUpdate(sql)>0){
System.out.println("注册成功!欢迎您:"+user);
}else{
System.out.println("没注册成功");
}
}catch(Exception e){
e.printStackTrace();
}
}
public static void login(Scanner scanner){
}
}
报错如下:
请输入选项
1:注册
2:登录
3:修改
4:删除
5:查询
1
现在是注册操作
请输入账户
sdafa
请输入密码
asdf
请输入账户金额度
asdf
请输入邮箱地址
asf
INSERT INTO user2 VALUESE(1,'sdafa','asdf',asdf,'asf')
java.sql.SQLSyntaxErrorException: ORA-00928: 缺失 SELECT 关键字
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)