package lx;
import java.util.*;
import java.sql.*;
import java.io.*;
public class Lmysql
{
public static void main(String args[])
{
Connection con=null;
Statement st=null;
ResultSet rs=null;
String DriverStr="org.gjt.mm.mysql.Driver";
try
{
Class.forName(DriverStr);
con=DriverManager.getConnection("jdbc:mysql://localhost/testxinleedatabase","root","admin");
String ssql="select * from user";
st= con.createStatement();
rs=st.executeQuery(ssql);
while(rs.next())
{
String nid=rs.getString(1);
String name=rs.getString(2);
String age=rs.getString(3);
System.out.println(nid+"\t\t"+name+"\t\t"+age);
}
rs.close();
st.close();
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
try
{
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
}
