如何在JAVA中创建sql 数据库

Java要连接数据库，那么首先你必须安装mysql数据库。

安装好mysql之后，安装JDK了。

安装好JDK之后，就是安装Eclipse了，要支持JDK版本，Eclipse安装的时候会自动去找JDK安装位置的，解压版的Eclipse，就要配置eclipse.ini文件了，将对应的JDK配置好，这些已经准备就绪的时候，就到mysql中创建数据库和表。

先创建数据库：

CREATE DATABASE SCUTCS

接着，创建表：

CREATE TABLE STUDENT

(

SNO CHAR(7) NOT NULL,

SNAME VARCHAR(8) NOT NULL,

SEX CHAR(2) NOT NULL,

BDATE DATE NOT NULL,

HEIGHT DEC(5,2) DEFAULT 000.00,

PRIMARY KEY(SNO)

)

然后插入数据，可以用SQL语句insert into <表名>values (value1, value2, ...)

编写.java文件来演示一下如何访问MySQL数据库。

import java.sql.*

public class JDBCTest {

public static void main(String[] args){

// 驱动程序名 String driver = "com.mysql.jdbc.Driver"

// URL指向要访问的数据库名scutcs String url = "jdbc:mysql://127.0.0.1:3306/scutcs"

// MySQL配置时的用户名 String user = "root"// MySQL配置时的密码 String password = "root"

try { // 加载驱动程序 Class.forName(driver)

// 连续数据库 Connection conn = DriverManager.getConnection(url, user, password)

if(!conn.isClosed()) System.out.println("Succeeded connecting to the Database!")

// statement用来执行SQL语句 Statement statement = conn.createStatement()

// 要执行的SQL语句 String sql = "select * from student"

// 结果集 ResultSet rs = statement.executeQuery(sql)

while(rs.next()) // 选择sname这列数据 name = rs.getString("sname

// 输出结果 System.out.println(rs.getString("sno") + "\t" + name)}

rs.close()conn.close()

} catch(ClassNotFoundException e) {

System.out.println("Sorry,can`t find the Driver!")e.printStackTrace()

} catch(SQLException e) {

e.printStackTrace()

} catch(Exception e) {

e.printStackTrace()

} } }

先要将相应数据库的驱动包放到项目的lib目录下。

conn

=

DriverManager.getConnection(dbURL,

userName,

password)

conn.setAutoCommit(true)

stmt

=

conn.createStatement()

rs

=

stmt.executeQuery(sql)

Student 类

public class Student

{

private int id

private int age

private int score

private String name

public Student()

{

}

public Student(int id, int age, int score, String name)

{

this.id = id

this.age = age

this.score = score

this.name = name

}

public int getId()

{

return id

}

public void setId(int id)

{

this.id = id

}

public int getAge()

{

return age

}

public void setAge(int age)

{

this.age = age

}

public int getScore()

{

return score

}

public void setScore(int score)

{

this.score = score

}

public String getName()

{

return name

}

public void setName(String name)

{

this.name = name

}

@Override

public String toString()

{

return "学号：" + id + " 姓名：" + name + " 年龄：" + age + " 成绩：" + score

}

}

Manager类

import java.util.ArrayList

import java.util.Iterator

import java.util.List

public class Manager

{

private List<Student>list

public Manager(List<Student>list)

{

this.list = list

}

public List<Student>getList()

{

return list

}

public void setList(List<Student>list)

{

this.list = list

}

//添加学生

public void add(Student s)

{

list.add(s)

}

//根据学生学号返回学生年龄

public int search(int id)

{

for(Iterator<Student>iter = list.iterator()iter.hasNext())

{

Student s = iter.next()

if(s.getId() == id)

{

return s.getAge()

}

}

return -1

}

//删除学生

public void remove(int id)

{

for(Iterator<Student>iter = list.iterator()iter.hasNext())

{

Student s = iter.next()

if(s.getId() == id)

{

list.remove(s)

}

}

}

//计算总成绩

public int allScore()

{

int score = 0

int temp = 0

for(Iterator<Student>iter = list.iterator()iter.hasNext())

{

Student s = iter.next()

temp = s.getScore()

score += temp

}

return score

}

//修改成绩

public void update(int id)

{

for(Iterator<Student>iter = list.iterator()iter.hasNext())

{

Student s = iter.next()

if(s.getId() == id)

{

s.setScore(s.getScore() + 10)

}

}

}

}

测试类 Client

import java.util.ArrayList

import java.util.List

public class Client

{

public static void main(String[] args)

{

List<Student>list = new ArrayList<Student>()

Manager manager = new Manager(list)//创建一个管理者

Student s1 = new Student()//无参构造方法创建的学生实例

//通过方法设置s1的属性

s1.setId(201105)

s1.setAge(20)

s1.setScore(100)

s1.setName("zhangsan")

Student s2 = new Student(201101,21,98,"lisi")//通过带参数的构造方法创建实例

Student s3 = new Student(201108,25,95,"zhaoliu")

Student s4 = new Student(201110,23,80,"xiaoming")

Student s5 = new Student(201106,28,78,"hello")

//放到集合当中

manager.getList().add(s1)//添加学生

manager.getList().add(s2)

manager.getList().add(s3)

manager.getList().add(s4)

manager.getList().add(s5)

System.out.println(list)

System.out.println(manager.allScore())

System.out.println(manager.search(201110))//根据学生学号查询学生年龄

manager.remove(201110)//删除学生

manager.update(201101)//修改成绩

}

}

可以完成你上述的基本要求，如果改动可以自行修改 很简单。

---