java访问mysql

houbin

　　package com.lj;
　　import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
　　import java.sql.Connection;
import java.sql.Statement;
　　public class Mysqltest {
 private static String url="jdbc:mysql://localhost:3306/test";
 private static String driver="com.mysql.jdbc.Driver";
 private static Connection conn=null;
 private static ResultSet rs = null;
 private static Statement st = null;
 public static Connection initConn(){
  try {
  Class.forName(driver);
   conn = DriverManager.getConnection(url,"root","dtv");
 } catch (Exception e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
  return conn;
 }
 public static void main(String[] args) throws Exception {
  st = Mysqltest.initConn().createStatement();
  String sql ="select cust_no,cust_name from terminal_cust";
  rs = st.executeQuery(sql);
  while(rs.next()){
   System.out.println("客户编号"+rs.getString("cust_no")+"客户名称"+rs.getString("cust_name"));
  }
  rs.close();
  st.close();
  conn.close();
}
}