java H2数据库使用并实现增删改查功能

最新推荐文章于 2023-02-26 20:27:17 发布

yaerfeng

最新推荐文章于 2023-02-26 20:27:17 发布

阅读量885

点赞数

分类专栏： java 数据库文章标签：数据库 H2 增删改查 CRUD java

java 同时被 2 个专栏收录

297 篇文章 0 订阅

订阅专栏

数据库

3 篇文章 0 订阅

订阅专栏

原文：java H2数据库使用并实现增删改查功能代码下载地址：http://www.zuidaima.com/share/1550463278058496.htm

java H2数据库使用并实现增删改查功能

package com.zuidaima.h2sql.test;

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

public class MainClass {

	/**
	 * @param args
         * @author www.zuidaima.com
	 */
	public static void main(String[] args) {
		Statement stmt = null;
		Connection conn = null;
		try {
			Class.forName("org.h2.Driver");
			conn = DriverManager.getConnection(
					"jdbc:h2:tcp://www.zuidaima.com:5435/mem:DBTest", "Guest",
					"123456");
			// add application code here
			stmt = conn.createStatement();
//			String createSql = "create table product(product_id integer not null,title varchar2(30) not null,type_id integer not null,info varchar2(80),price number(16,2) not null,constraint product_pk primary key (product_id),constraint product_fk foreign key(type_id) references item(type_id)))";
//			stmt.executeUpdate(createSql);
			// 添加一条语句
			// String insertSql =
			// "insert into UserInfo values('刘尚','www.zuidaima.com','888888','true',15827288756,15827288756)";
			// stmt.executeUpdate(insertSql);
			// 删除一条记录
			// String deleteSql = "delete from USERINFO where UID = '刘尚1'";
			// stmt.executeUpdate(deleteSql);
			// 修改一条语句
			// String UpdateSql =
			// "UPDATE USERINFO  SET IP='www.zuidaima.com' ,  LINKID='11111' , ACTION='FALSE' ,  UPTIME=2121231 ,DOWNTIME=2121212 WHERE UID='刘尚'";
			// stmt.executeUpdate(deleteSql);
			ResultSet rs = stmt.executeQuery("SELECT * FROM UserInfo ");
			 while (rs.next()) {
			 System.out.println("Uid:" + rs.getString("Uid") + "\tIp:"
			 + rs.getString("Ip") + "\tLinkId:"
			 + rs.getString("LinkId") + "\tAction:"
			 + rs.getBoolean("Action") + "\tUpTime:"
			 + rs.getLong("UpTime") + "\tDownTime:"
			 + rs.getLong("DownTime"));
			 }
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (stmt != null) {
					stmt.close();
					stmt = null;
				}
				if (conn != null) {
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}

标签：数据库 H2 增删改查 CRUD java话题：数据库相关入门教程 Web开发