开发者社区> 问答> 正文

使用Java编写MySQL数据库,eclipse总提示错误

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<j;k++){
                 System.out.print(rsmd.getColumnName(k+1));
                 System.out.print("\t");
             }
             System.out.println();
             while(rs.next()){
                 for(int i=0;i<j;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());
             }
         }
     }

 }

展开
收起
爵霸 2016-03-23 14:56:15 2141 0
1 条回答
写回答
取消 提交回答
  • frommylist 中间加个空格 from mylist

    2019-07-17 19:11:09
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像