import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;
public class Test {
public static void main(String[] args) {
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");//驱动的类名
Connection conn=
(Connection) DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/zhang", //服务器的IP地址和端口号,数据库的名字
"root",//用户名
"128928818"//密码
);
Statement stmt=(Statement) conn.createStatement();
rs=stmt.executeQuery("select * from student");
while(rs.next())
{
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
if(rs!=null)
{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
Java连接MySQL数据库并查询结果
最新推荐文章于 2024-05-22 08:33:48 发布