eclipse mysql自有5.1_纠结一天了。没弄出来。代码在下面，用eclipse导入了mysql-connector-java-5.1.18。求帮助。...

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importcom.mysql.jdbc.Statement;importjava.sql.Statement;p...

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import com.mysql.jdbc.Statement;

import java.sql.Statement;

public class shuju

{

/**

* @param args

*/

public static void main(String[] args)

{

// TODO Auto-generated method stub

ResultSet rs;

Statement stmt;

Connection conn;

String SQL="insert into 登陆 value('程伟','12345','2011-11-28')";

if(args.length!=0)//args表示传入参数的数组 ,所以args.length表示传入参数的个数

{

SQL=args[0];

System.out.println("The SQL commanf you want to exxcute is");

System.out.println(SQL);

}

else

{

System.out.println("Please input the SQL command");

System.exit(0);//2个都是退出程序的意思； 2种参数返回值： 0--正常结束程序 1--异常关闭程序；

}

try

{

Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","893893");

stmt=conn.createStatement();

boolean hasResultSet=stmt.execute(SQL);

if(hasResultSet)

{

rs=stmt.getResultSet();

ResultSetMetaData rsmd=rs.getMetaData();

int columnCount =rsmd.getColumnCount();

while(rs.next())

{

for(int i=0;i

{

System.out.print(rs.getString(i+1)+"\t");

}

System.out.print("\n");

}

}

else

{

System.out.println("该SQL语句影响的记录为"+stmt.getUpdateCount()+"条");

}

}

finally

{

if(rs!=null)

{

rs.close();

}

if(stmt!=null)

{

stmt.close();

}

if(conn!=null)

{

conn.close();

}

}

}

}

stmt=conn.createStatement();就只有这一个错误。提示是;Type mismatch: cannot convert from java.sql.Statement to com.mysql.jdbc.StatementType mismatch: cannot convert from java.sql.Statement to com.mysql.jdbc.Statement.

跪求啊！

展开