Oracle Java错误记录--每天一条记录我的愚蠢

1.ORACL-12514, TNS:listener does not currently know of service requested in connec
我在获取连接的时候少写了端口号和是实例名称，愚蠢！！！

con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","a");
	

2.ORA-00933: SQL 命令未正确结束
因为我的无知update的时候不能and

update loluser set lolglod=lolglod+500 and lolpoint=lolpoint+750 where lid=xxx;

正确写法

update loluser set lolgold=lolgold+500,lolpoint=lolpoint+750 where lid=xxx;