mysql resolved_The import com.mysql cannot be resolved

代码如下

代码如下

String driverNam="com.mysql.jdbc.Driver";

//数据库用户名

String userName="root";

String userPasswd="5622";

String dbName="test";

String tableName="studenInfo";

//连接字符串

String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;

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

Connection conn=DriverManager.getConnection(url);

Statement stmt=conn.createStatement();

//zhixingyuju

String sql="SELECT*FROM"+tableName;

ResultSet rs=stmt.executeQuery(sql);

//huodeshuju

ResultSetMetaData rmeta=rs.getMetaData();

//quedingshujujji

int numColumns=rmeta.getColumnCount();

out.print("

");

//shuchushuzhi

out.print("======xuehao=======");

out.print("|");

out.print("======xingming=====");

out.print("|");

out.print("======dianhua======");

out.print("
");

while (rs.next())

{

out.print(rs.getString(1)+"====");

out.print("|");

out.print(rs.getString(2)+"====");

out.print("|");

out.print(rs.getString(3));

out.print("
");

}//geichujieguo

out.print("
");

out.print("数据库操作成");

out.print("

");

//guanbijilu

rs.close();

//guanbilianjie

stmt.close();

conn.close();

%>

展开