eclipse连接数据库_eclipse链接数据库

eclipse连接Oracle数据库或者MySQL数据库
1.下载JDBC，解压后会有这么一个文件夹和两个.jar文件，官方网站下载对应版本即可，jdbc是通用的不用计较用oracle还是mysql的jdbc

2.将ojdbc8.jar放在如下目录

3.右击项目-properties，搜索框搜索java build path,点击该按钮

把解压到磁盘的该文件添加进去

点击该按钮

选择User Library

4.打勾然后finish，若无此选项，点击User libraries…，new一个名字，再打勾

5.新建一个连接数据库的class类

连接数据库代码：

package zlm;

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

public class Conn {
	private String username = "", pw = "", realname = "", picture = "";
	private String function;
	public StringBuffer columns = new StringBuffer(), grids = new StringBuffer();
	private long tel = 0;

	public void setPicture(String picture) {
		this.picture = picture;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public void setPw(String pw) {
		this.pw = pw;
	}

	public void setFunction(String function) {
		this.function = function;
	}

	public void setRealname(String realname) {
		this.realname = realname;
	}

	public void setTel(long tel) {
		this.tel = tel;
	}

	public void queryData(String database, String table, String userName, String password) {
		Connection con;
		DatabaseMetaData meta;
		Statement state;
		ResultSet rs1, rs2;
		int record = 0;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (Exception e) {
		}
		try {
			char c[] = table.toCharArray();
			for (int i = 0; i < c.length; i++)
				if (c[i] >= 'a' && c[i] <= 'z')
					c[i] -= 32;
			con = DriverManager.getConnection("jdbc:oracle:thin:@//127.0.0.1:1521/" + database, userName, password);
			meta = con.getMetaData();
			rs1 = meta.getColumns(null, null, new String(c), null);
			while (rs1.next()) {
				columns.append("#" + rs1.getString(4));
				record++;
			}
			state = con.createStatement();
			String connString = null;
			if (function.equals("insert")) {
				connString = "insert into " + table + " values('" + username + "','" + pw + "','" + realname + "','"
						+ tel + "','" + picture + "')";
			} else if (function.equals("check")) {
				connString = "select pw,picture from " + table + " where username='" + username + "'";
			}
			rs2 = state.executeQuery(connString);
			while (rs2.next()) {
				for (int i = 1; i <= record; i++)
					grids.append("#" + rs2.getString(i));
			}
			con.close();
		} catch (Exception e) {
			System.out.println("Error:" + e.toString());
		}
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80

运行JSP：

查看Oracle数据库，注册用户数据插入成功

这是我编写网页登陆注册连接数据库的部分，有多余内容，请忽略，更改function=“insert”，更改database,table,username,password对应自己数据库自行更改，执行后grids里就装着执行此条语句的记录了。也可以System.out.println(Arrays.toString(grids))；测试一下看看。若提示no row selected则表中无记录，插入即可，关于插入数据库，创建表，创建用户，更改数据库用户密码，解锁用户等等，在我的另一篇博客里有提到：《Oracle数据库基本操作》
以上代码适用于Oracle数据库，若是MySQL数据库，加载数据库驱动和URL代码需要更改，代码如下：
1.Class.forName(“oracle.jdbc.driver.OracleDriver”);更改为Class.forName(“com.mysql.jdbc.Driver”);
2."jdbc:oracle:thin:@//127.0.0.1:1521/"更改为"jdbc:mysql://127.0.0.1/3306"