日期:2014-05-16 浏览次数:20459 次
不能运行,需要数据库 package procedures; import java.sql.*; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import com.mysql.jdbc.*; public class testProce { public static void main(String[] args) { getJDBC(); } public static void getJDBC(){ String sql = "select * from thaha"; Connection conn = null; Statement s =null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql" ,"root","123"); s = conn.createStatement(); rs = s.executeQuery(sql); while(rs.next()){ p(rs.getInt("fuserid")+" ----- "); p(rs.getString("fusername")+" ----- "); p(rs.getString("fpasswrod")+" ----- "); p(rs.getString("fbirday")+" ----- "); p(rs.getString("fzhuzhi")+" ----- "); p(rs.getString("")); p(rs.getString("")); p("\n"); } } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); }finally{ try { rs.close(); s.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void p(String s){ System.out.print(s); } public static void p(int s){ System.out.print(s); } }