body{font-size:14px;font-family:'宋体';line-height:25px;padding:8px 10px;margin:0;}pre { white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word; font-family:'';}.rm_line{border-top:2px solid #F1F1F1; font-size:0; margin:15px 0}.atchImg img{border:2px solid #c3d9ff;}.lnkTxt{ color:#0066CC}.rm_PicArea *{ font-family:Arial, sans-serif; font-size:14px;font-weight:700;}.fbk3{ color:#333; line-height:160%}.fTip{ font-size:11px; font-weight:normal}
首先得把MYECLIPSE自带的JDK的DERBY数据库的JAR文件给导入工程,反正没事把几个都导进来,如下:
derby.jar,derbyclient.jar,derbynet.jar,derbyrun.jar,derbytools.jar.
myelipse 里 的DB Browser已经自带了myeclipse derby,直接启动服务,然后在app 的table建表,如videoinfo.
写连接数据的类,如下。
- import java.sql.Connection;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import org.apache.derby.impl.sql.compile.StaticClassFieldReferenceNode;
- public class DBmanager {
- public static void main(String[] args) throws Exception {
- Class.forName( "org.apache.derby.jdbc.ClientDriver" );
- Connection conn = java.sql.DriverManager.getConnection(
- "jdbc:derby://localhost:1527/MyEclipse" , "classiccars" ,
- "classiccars" );
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt
- .executeQuery( "select v.id, v.name,v.videopath from app.videoinfo v" );
- while (rs.next()) {
- System.out.print(rs.getString( "id" ) + "; " + rs.getString( "name" ));
- System.out.println( " " );
- }
- rs.close();
- stmt.close();
- conn.close();
- }
- }