62,614
社区成员
发帖
与我相关
我的任务
分享
import java.sql.*;
public class Base {
public static void main(String[] args) {
}
static void test() throws SQLException{
//1,注册驱动
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//2,建立连接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc","root","caofeng");
//3,创建语句
Statement statement=con.createStatement();
//4,执行语句
ResultSet resultSet=statement.executeQuery("SELECT * FROM user");
//5,处理结果
while(resultSet.next()){
System.out.println(resultSet.getObject(1)+"\t"+resultSet.getObject(2)+"\t"+resultSet.getObject(3)+"\t"+resultSet.getObject(4));
}
//6,释放资源
resultSet.close();
statement.close();
con.close();
}
}
System.out.println("now the value is :"+value);