java 入门篇<一>

java 连接mysql 的一个小测试：

package com.chap;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import com.mysql.jdbc.Statement;

public class databasetest {
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","120440");
System.out.println("Connected .");
Statement statement = (Statement) con.createStatement();
String sql = "select * from member_info";
ResultSet rs = statement.executeQuery(sql);
int count =0;
rs.last();
int c = rs.getRow();
rs.first();
do
{
count=count+1;
System.out.println(rs.getString(2)+"***"+count+"+++Total:"+c);
}while(rs.next());

rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
}

//注表已经创建好了。

一定要导入 mysql-connection-java-5.1.7-bin.jar 包到 lib 目录下