java怎么调用数据库函数

java怎么调用数据库函数,第1张

1先确定你装好了maven 输入mvn --version看有没有版本

2继续命令行下,输入mvn archetype:generate 这时会看到许多选项,然后选你要新建的servlet 3.你执行命令行的所在目录,

neo4j采纳java语言开发,如果我们要在java程序中以内嵌方式应用neo4j,只需导入neo4j的对应包即可。

首先,我们来创建一个maven项目并改动pom.xml添加对neo4j的依附。

<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 "><modelVersion>4.0.0</modelVersion><groupId>neo4j-learn</groupId><artifactId>neo4j-learn</artifactId><version>1.0-SNAPSHOT</version><dependencies><dependency><groupId>org.neo4j</groupId><artifactId>neo4j</artifactId><version>1.9.4</version></dependency></dependencies></project>

然后,我们在项目中创建一个neo4j.properties(数据的配置文件)文件和一个java类(调用数据库)。

neo4j.properties

# Default values for the low-level graph engine #neostore.nodestore.db.mapped_memory=25M #neostore.relationshipstore.db.mapped_memory=50M #neostore.propertystore.db.mapped_memory=90M #neostore.propertystore.db.strings.mapped_memory=130M #neostore.propertystore.db.arrays.mapped_memory=130M # Autoindexing # Enable auto-indexing for nodes, default is false #node_auto_indexing=true # The node property keys to be auto-indexed, if enabled #node_keys_indexable=name,age # Enable auto-indexing for relationships, default is false #relationship_auto_indexing=true # The relationship property keys to be auto-indexed, if enabled #relationship_keys_indexable=name,age # Keep logical logs, needed for online backups to work keep_logical_logs=true # Enable online backups to be taken from this database. online_backup_enabled=true # Uncomment and specify these lines for running Neo4j in High Availability mode. # ha.server_id is a unique integer for each instance of the Neo4j database in the cluster. # (as opposed to the coordinator instance IDs) # example: ha.server_id=1 #ha.server_id= # ha.coordinators is a comma-separated list (without spaces) of the host:port of where to # find one or more of the Neo4j coordinator servers. # Avoid localhost due to IP resolution issues on some systems. # example: ha.coordinators=localhost:2181,1.2.3.4:4321 #ha.coordinators=localhost:2181 # You can also, optionally, configure the ha.cluster_name. This is the name of the cluster this # instance is supposed to join. Accepted characters are alphabetical, numerical, dot and dash. # This configuration is useful if you have multiple Neo4j HA clusters managed by the same # Coordinator cluster. # Example: ha.cluster_name = my.neo4j.ha.cluster #ha.cluster_name = # IP and port for this instance to bind to to communicate data with the # other neo4j instances in the cluster. This is broadcasted to the other # cluster members, so different members can have different communication ports. # Optional if the members are on different machines so the IP is different for every member. #ha.server = localhost:6001 # The interval at which slaves will pull updates from the master. Comment out # the option to disable periodic pulling of updates. Unit is seconds. ha.pull_interval = 10 # The session timeout for the zookeeper client. Lower values make new master # election happen closer to the master loosing connection but also more sensitive # to zookeeper quorum hiccups. If experiencing master switches without reason # consider increasing this value. Unit is seconds #ha.zk_session_timeout = 5 # Amount of slaves the master will try to push a transaction to upon commit (default is 1). # The master will optimistically continue and not fail the transaction even if it fails to # reach the push factor. Setting this to 0 will increase write performance when writing # through master but could potentially lead to branched data (or loss of transaction) # if the master goes down. #ha.tx_push_factor=1 # Strategy the master will use when pushing data to slaves (if the push factor is greater than 0). # There are two options available "fixed" (default) or "round_robin". Fixed will start by # pushing to slaves ordered by server id (highest first) improving performance since the # slaves only have to cache up one transaction at a time. #ha.tx_push_strategy=fixed # Enable this to be able to upgrade a store from 1.4 ->1.5 or 1.4 ->1.6 #allow_store_upgrade=true # Enable this to specify a parser other than the default one. 1.5, 1.6, 1.7 are available #cypher_parser_version=1.6

java文件(neo4j示例文件改动而来)

Java程序向数据库中插入数据,代码如下:

//首先创建数据库,(access,oracle,mysql,sqlsever)其中之一,其中access,sqlsever需要配置数据源(odbc)

//然后再eclipse中创建类(ConnDb,Test,TestBean)ConnDb功能为连接数据库,查询,插入,删除,修改数据的类,Test为含有main方法的测试类,TestBean为数据表中的字段属性及set,get方法

//以下是ConnDb代码:

package db

import java.sql.Connection

import java.sql.DriverManager

import 

java.sql.ResultSet

import java.sql.SQLException

import 

java.sql.Statement

import java.util.ArrayList

public class ConnDb {

public Connection startConn(Connection conn){

  try {

   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

   conn = DriverManager.getConnection("jdbc:odbc:数据库","用户名", "密码")

  } catch (Exception e) {

   System.out.println("连接数据库时出现错误")

  }

  return conn

 }

 

public ArrayList executeQuery(String sql){

  Connection conn = null

  Statement stmt = null

  ResultSet rs = null

  ArrayList list = new ArrayList()

  try {

   conn = startConn(conn)

   stmt = conn.createStatement()

   rs = stmt.executeQuery(sql)//sql为sql语句例如"select * from 

表名",从main方法中传进来,这里用的是ArrayList 类将查询结果存储起来

   while(rs.next()){

    TestBean tb = new TestBean()

    tb.setTid(rs.getString("tid"))

    tb.setTname(rs.getString("tname"))

    tb.setTinfo(rs.getString("tinfo"))

    list.add(tb)

   }

  } 

catch (SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace()

  }finally{

   closeConn(rs,stmt,conn)

  }

  return list

 } 

 public void executeUpdate(String sql){

  Connection conn = null

  Statement stmt = null

  try {

   conn = 

startConn(conn)

   stmt = conn.createStatement()

   stmt.executeUpdate(sql)

  } 

catch (SQLException e) {

   System.out.println("修改,插入或者删除数据库数据时发生错误!")

  }finally{

   closeConn(stmt,conn)

  }

 }

 public void closeConn(ResultSet rs,Statement stmt,Connection conn){

  try {

   if(rs != 

null){

    rs.close()

   }

   if(stmt != null){

    stmt.close()

   }

   if(conn != null){

    conn.close()

   }

  } 

catch (SQLException e) {

   // TODO Auto-generated catch 

block

   System.out.println("关闭数据库的时候发生错误!")

  }

 }

 public void closeConn(Statement stmt,Connection conn){

  try {

   if(stmt != null){

    stmt.close()

   }

   if(conn != null){

    conn.close()

   }

  } 

catch (SQLException e) {

   // TODO Auto-generated catch block

   System.out.println("关闭数据库的时候发生错误!")

  }

 }

}


欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/9612194.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-04-30
下一篇 2023-04-30

发表评论

登录后才能评论

评论列表(0条)

保存