代码:
import java.lang.String;
import java.sql.*;
//import java.util.Properties;
public class Jdbctext1 {
public static void main(String[] args)throws SQLException
{
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try
{
Class.forName("com.mysql.jdbc.Driver");//驱动
System.out.println("loading success!");
String url = "jdbc:mysql://localhost:3306/Library?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String user = "root";
String passward = "123456";
conn =DriverManager.getConnection(url,user,passward);//connection对象
String sql = "select * from users";
stmt = conn.prepareStatement(sql);//statement对象
rs = stmt.executeQuery();
System.out.println("id | name | passward | email | birthday");
if(rs.next()==false)System.out.println("false!");//re.next()一直等于false
while(rs.next())//进不去该循环
{
System.out.println("test");
int id = rs.getInt("id");
String name =rs.getString("name");
String psw =rs.getString("passward");
String email = rs.getString("email");
Date birthday = rs.getDate("birthday");
System.out.println(id + "|"+ name + "|" + psw+ "|" +email + "|" +birthday);
}
/******************** 下面不重要 *************************************/
System.out.println("connecting success!");
}catch(Exception e)
{
System.out.println("123");
e.printStackTrace();
}finally {
if(rs!=null) {
try
{
rs.close();
}catch(SQLException e)
{
e.printStackTrace();
}
rs=null;
}
if(stmt!=null) {
try
{
stmt.close();
}catch(SQLException e)
{
e.printStackTrace();
}
stmt=null;
}
if(conn!=null) {
try
{
conn.close();
}catch(SQLException e)
{
e.printStackTrace();
}
conn=null;
}
}
}
}
JAR
console: