test.java

来自「Spring +Web 的完整 MyEclipse 项目源码,使用者可以作为入门」· Java 代码 · 共 32 行

package login;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import org.gjt.mm.mysql.Driver;

public class test {
  public static void main(String[] args) {
    test test = new test();
    try{
    Class.forName("org.gjt.mm.mysql.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root","123321");
    Statement stmt=conn.createStatement();

    String sql="select password from user where username ='kingbill'";
    ResultSet rs=stmt.executeQuery(sql);

    while(rs.next())
    {
    System.out.print(rs.getString("password"));
    }
    rs.close();
    stmt.close();
    conn.close();
    }catch(Exception e){e.printStackTrace();}

  }

}