Question

java插入 数据库语法错误 还有删除的?

package hc;
import java.io.*;
import java.sql.*;
public class J {
static Connection conn;
static Statement st;
public static void main(String[]args){
insert();
update();
delect();
query();
}
public static Connection getConnection(){
Connection con=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://192.168.0.160:3306/person","root","root");

} catch (Exception e){
e.printStackTrace();
}
return con;
}
public static void insert(){
conn= getConnection();
try {
String sql="INSERT INTO person(name,age,sex,address,depart,)"+"VALUES('we',23,'m','china','no')";
st=conn.createStatement();
int count=st.executeUpdate(sql);
System.out.println(count);
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
public static void update (){
conn=getConnection();
try {
String sql="update person set age=22 where name='w'";
st=conn.createStatement();
int count = st.executeUpdate(sql);
System.out.println("更新"+count);

}catch (Exception e){
e.printStackTrace();
}
}

public static void query(){
conn=getConnection();
try {
String sql="select*from person";
st=conn.createStatement();
ResultSet rs=st.executeQuery(sql);
while (rs.next()){
String name=rs.getString("name");
int age= rs.getInt("age");
String sex= rs.getString("sex");
String address=rs.getString("address");
String depart =rs.getString("depart");
System.out.println(name+ age +address +sex+depart);
}
conn.close();
}catch (Exception e){
e.printStackTrace();

}
}

public static void delect(){
conn=getConnection();
try {
String sql="delect from person where name='we'";
st=(Statement)conn.createStatement();
int count=st.executeUpdate(sql);
System.out.println(sql);
conn.close();

}catch (Exception e){
e.printStackTrace();
}

}
}
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delect from person where name='we'' at line 1

Answer 1

name='we'' at line 1 看这你引号错了，应该写成'we'

就这一个错误，改下就好了

Answer 2

sql 语句语法错误：

delet 改成 delete

delete 少了个字母“e”

追问

public static void insert(){
conn= getConnection();
try {
String sql="INSERT INTO person(name,age,sex,address,depart,)"+"VALUES('we',23,'m','china','no')";
st=conn.createStatement();
int count=st.executeUpdate(sql);
System.out.println(count);
conn.close();

这个有错么

追答

你执行下 看控制台报异常没·～ 再看看数据库是否为正确的值

Answer 3

String sql="delect from person where name='we'";
delect = 应该是select