package 增删改查;
import java.sql.*;
public class Linkmysql
{
private static final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
private static final String Name="root";
private static final String Password="woshinidie668";
private static Connection conn=null;
static
{
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败!");
}
}
public static Connection connection( )
{
return conn;
}
public static void main(String[] args) throws SQLException
{
// TODO 自动生成的方法存根
Statement stmt=conn.createStatement( );
ResultSet rs=stmt.executeQuery("select name,password from user");
while(rs.next())
{
System.out.println(rs.getString("name")+" "+rs.getString("password"));
}
}
}