java jdbc mysql查询_Java Jdbc查询MySQL数据库示例

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class MySQLTest {

public static void main(String[] args) {

// TODO Auto-generated method stub

Connection conn = null;

try

{

String userName = "username";

String password = "password";

String url = "jdbc:mysql://localhost/test";

Class.forName ("com.mysql.jdbc.Driver").newInstance ();

conn = DriverManager.getConnection (url, userName, password);

System.out.println ("Database connection established");

PreparedStatement pstmt;

ResultSet rset;

pstmt = conn.prepareStatement("select count(*) from testtable");

rset=pstmt.executeQuery();

while (rset.next()){

System.out.println (rset.getString(1)); // Print col 1

}

}

catch (Exception e)

{

System.err.println ("Cannot connect to database server");

}

finally

{

if (conn != null)

{

try

{

conn.close ();

System.out.println ("Database connection terminated");

}

catch (Exception e) { /* ignore close errors */ }

}

}

}

}

企业、个人免费注册，获取想要的深圳软件工程师招聘信息 月薪最低3000-8000，更有高端猎头职位！

www.szrcwz.com

分享到：

2010-09-27 09:23

浏览 1623

评论