java 连接mysql

作者:admin 日期:2007-09-28

字体大小: 小中大

import java.sql.*;
import java.lang.*;

public class mysql {

/**
* @param args
*/
public static void main(String[] args) {
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
Statement stat=(Statement) ((java.sql.Connection) con).createStatement();
String sql="select * from table";
ResultSet rs=((java.sql.Statement) stat).executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
}
}
catch(SQLException e)
{System.out.println(e);}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
}

}