eclipse总提示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 'frommylist' at line 1
Java代码
package mytest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
String user="root";
String password="6917";
String url="jdbc:mysql://localhost:3306/mytest";
String driver="com.mysql.jdbc.Driver";
String tableName="mylist";
String sqlstr;
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName(driver);
con=DriverManager.getConnection(url, user, password);
stmt=con.createStatement();
sqlstr="insert into "+tableName+" values('222','honey',21)";
stmt.executeUpdate(sqlstr);
sqlstr="select * from "+tableName;
rs=stmt.executeQuery(sqlstr);
ResultSetMetaData rsmd=rs.getMetaData();
int j=0;
j=rsmd.getColumnCount();
for(int k=0;k
System.out.print(rsmd.getColumnName(k+1));
System.out.print("\t");
}
System.out.println();
while(rs.next()){
for(int i=0;i
System.out.print(rs.getString(i+1));
System.out.print("\t");
}
System.out.println();
}
}catch(ClassNotFoundException e1){
System.out.println("数据库驱动不存在!");
System.out.println(e1.toString());
}catch(SQLException e2){
System.out.println("数据库存在异常!");
System.out.println(e2.toString());
}finally{
try{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(con!=null)
con.close();
}catch(SQLException e){
System.out.println(e.toString());
}
}
}
}