红联Linux门户
Linux帮助

浅谈如何应用JDBC连接数据库My SQL

发布时间:2006-09-23 00:03:22来源:红联作者:fengmayi1
  最近在学习数据库开发的一些实例,这里浅谈一下用JDBC连接数据库MySQL(当然也可以连接SQL Sever或Oracle了,只是我更喜欢开源软件,同时也更简单)。

  首先正确安装好MySQL,建立好数据库studentinfo

[code]mysql>create database studentinfo;[/code]

  然后编写java代码,ConnectToMySQL.java

[code]import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException ,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/studentinfo";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "";
Connection con = DriverManager.getConnection(url,userName,password);
return con;
}
public static void main(String[] args) {
try{
Connection con = getConnection();
Statement sql = con.createStatement();
sql.execute("drop table if exists student");
sql.execute("create table student(id int not null auto_increment,name varchar(20) not
null default 'name',math int not null default 60,primary key(id));");
sql.execute("insert student values(1,'AAA','99')");
sql.execute("insert student values(2,'BBB','77')");
sql.execute("insert student values(3,'CCC','65')");
String query = "select * from student";
ResultSet result = sql.executeQuery(query);
System.out.println("Student表数据如下:");
System.out.println("---------------------------------");
System.out.println("学号"+" "+"姓名"+" "+"数学成绩");
System.out.println("---------------------------------");
int number;
String name;
String math;
while(result.next()){
number = result.getInt("id");
name = result.getString("name");
math = result.getString("math");
System.out.println(number + " " + name + " " + math);
}
sql.close();
con.close();

}catch(java.lang.ClassNotFoundException e){
System.err.println("ClassNotFoundException:" + e.getMessage());
}catch(SQLException ex){
System.err.println("SQLException:" + ex.getMessage());
}
}
}[/code]

  轻松搞定,一下为输出结果:

[align=center][/align]

  要注意的是使用MySQL数据库,需要用到对应的JDBC驱动程序mysql-connector-java-5.0.3,可以到zySQL的官方网站上下载(http://www.mysql.org)
文章评论

共有 91 条评论

  1. 71.70.225.* 于 2007-07-19 03:00:10发表:

    adult hot comic http://adultcomics17jul.tripod.com/adult_hot_comic.html adult hot comic adult hot comic
    adult book cam comic guest inurl web http://adultcomics17jul.tripod.com/adult_book_cam_comic_guest_inurl_web.html adult book cam comic guest inurl web adult book cam comic guest inurl web
    adult comic evil http://adultcomics17jul.tripod.com/adult_comic_evil.html adult comic evil adult comic evil
    adult comics free http://adultcomics17jul.tripod.com/adult_comics_free.html adult comics free adult comics free
    d adult comics http://adultcomics17jul.tripod.com/d_adult_comics.html d adult comics d adult comics

  2. 85.85.101.* 于 2007-07-17 16:27:32发表:

    http://efac683e322b8caf81693a0ba180b442-t.xkktxb.org efac683e322b8caf81693a0ba180b442 http://efac683e322b8caf81693a0ba180b442-b1.xkktxb.org efac683e322b8caf81693a0ba180b442 http://efac683e322b8caf81693a0ba180b442-b3.xkktxb.org 8d1f2bfe3cbc5359328d95464cab8b7c