MyEclipse Derby

最新推荐文章于 2019-01-08 02:57:21 发布

xyz0101123132

最新推荐文章于 2019-01-08 02:57:21 发布

阅读量4.1k

点赞数

分类专栏： java 文章标签： myeclipse derby string null email date

本文链接：https://blog.csdn.net/gudong2945/article/details/5440725

版权

java 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

环境:

MyEclipse Enterprise Workbench

Version: 8.5
Build id: 8.5-20100319

WindowsXp

1.切换到数据库视图.在DB Browser窗口中找到 MyEclipse Derby 单击右件选择new.

Driver template: 选择derby;

Driver name: 随便比如 MyDB;

Connection URL : jdbc:derby://localhost:1527/MyDb;create=true

说明:create=true 表示创建

Username:zhangsan Password:123456

Driver JARs:

C:/Program Files/Genuitec/MyEclipse 8.5/configuration/org.eclipse.osgi/bundles/13/1/.cp/lib/derbyclient.jar;(成功)

Driver classname = org.apache.derby.jdbc.ClientDriver

或者

C:/Program Files/Genuitec/MyEclipse 8.5/configuration/org.eclipse.osgi/bundles/13/1/.cp/lib/derby.jar;(我测试没有成功)

Driver classname = org.apache.derby.jdbc.EmbeddedDriver

3.测试一下

drop table guestbook; create table guestbook ( id int primary key generated by default as identity (START WITH 1, INCREMENT BY 1), name varchar(20) not null, email varchar(20), phone varchar(20), title varchar(50) not null, content varchar(2000) not null, time date not null ); insert into guestbook (id,name,email,phone,title,content,time) values(DEFAULT,'lala','gudong@163.com','13991736400','ok','okcontent',CURRENT DATE); select * from guestbook;

4.java中调用(如果出现不能侦听1527的错误,请重新启动Derby);

package webbook.chapter5; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class JDBCExample { public static void main(String[] args) { String driver = "org.apache.derby.jdbc.ClientDriver"; String url = "jdbc:derby://localhost:1527/MyDB"; String username = "zhangsan"; String password = "123456"; String sql = "insert into guestbook (id,name,email,phone,title,content,time)" +"values(DEFAULT,?,?,?,?,?,CURRENT DATE)"; /*DEFAULT Derby中的自动增长 CURRENT DATE当前时间*/ Connection conn = null; try{ Class.forName(driver); conn = DriverManager.getConnection(url, username, password); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, "gudong"); pstmt.setString(2, "ZhangFei@163.com"); pstmt.setString(3, "110"); pstmt.setString(4, "title"); pstmt.setString(5, "content"); pstmt.executeUpdate(); sql="select * from guestbook "; pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while(rs.next()){ System.out.println("id:"+rs.getInt("ID")); System.out.println("name:"+rs.getString("NAME")); System.out.println("email:"+rs.getString("EMAIL")); System.out.println("phone:"+rs.getString("PHONE")); System.out.println("title:"+rs.getString("TITLE")); System.out.println("content:"+rs.getString("content")); System.out.println("date:"+rs.getString("time")); } if (rs != null) { rs.close(); } if (pstmt != null) { pstmt.close(); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } }