System.out.println(System.getProperty("user.dir"));
//获取当前的目录的。当前目录到 哪一个级别。后面需要继续连接上的。
package javaWeb;
import jdk.nashorn.internal.ir.CallNode;
import java.sql.*;
public class Test {
public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3306/wgs";
String user = "root";
String password = "wgs";
Connection connection = DriverManager.getConnection(url, user, password);
Statement statement = connection.createStatement();
String sql = "select * from actor";
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
int id = resultSet.getInt(1);
String name = resultSet.getString(2);
System.out.println(id);
System.out.println(name);
System.out.println("=====");
//还可以根据数据库中的字段创建一个类,将从数据库中获取的数据,这届set到数据中去,然后将这个
//类放入到集合中去。
}
//释放资源
connection.close();
statement.close();
resultSet.close();
}
public void test1() throws Exception {
String url = "jdbc:mysql://localhost:3306/wgs";
String user = "root";
String password = "wgs";
Connection connection = DriverManager.getConnection(url, user, password);
String sql = "select * from actor where name = ? and password = ?";
String name = "wgs";
String password1 = "45556";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,name);
preparedStatement.setString(2,password1);
ResultSet resultSet = preparedStatement.executeQuery();
connection.close();
preparedStatement.close();
}
public void test2(){
System.out.println(System.getProperty("user.dir"));
//获取当前的目录的。当前目录到 哪一个级别。后面我需要继续连接上的。
}
}