java jdbc mysql例子，JDBC练习，链接数据库，对mysql数据库的操作等。

package wzq.j2se;

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

public class JDBC {

public static void main(String[] args) {
connetMysqlTest();

}
public static void connetMysqlTest()
{
String connectionUrl = “jdbc:mysql://localhost:3306/obpm?user=root&password=1111″;

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

try
{
Class.forName(“com.mysql.jdbc.Driver”);
conn = DriverManager.getConnection(connectionUrl);
conn.setAutoCommit(false);
stmt = conn.createStatement();
rs = stmt.executeQuery(“select * from t_application”);

while (rs.next())
{
System.out.print(rs.getString(“ID”) + ” “);
System.out.print(rs.getString(“NAME”) + ” “);
System.out.println(rs.getString(“DESCRIPTION”));
}
}
catch (Exception e)
{
if(null != conn)
{
try
{
conn.rollback();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
e.printStackTrace();
}
finally
{
if (null != rs)
{
try
{
rs.close();
rs = null;
}
catch (Exception e2)
{
e2.printStackTrace();
}
}

if (null != stmt)
{
try
{
stmt.close();
stmt = null;
}
catch (Exception e2)
{
e2.printStackTrace();
}
}

if (null != conn)
{
try
{
conn.close();
conn = null;
}
catch (Exception e2)
{
e2.printStackTrace();
}
}
}
}
}