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

刺骨的言语ヽ痛彻心扉 2022-09-21 01:02 124阅读 0赞

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

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();
    			}
    		}
    	}
    
    }

标签： [数据库][Link 1] [H2][] [增删改查][Link 2] [CRUD][] [java][]话题： [数据库相关][Link 3] [入门教程][Link 4] [Web开发][Web]

[java H2]: http://www.zuidaima.com/share/1550463278058496.htm
[Link 1]: http://www.zuidaima.com/share/search.htm?key=%E6%95%B0%E6%8D%AE%E5%BA%93
[H2]: http://www.zuidaima.com/share/search.htm?key=H2
[Link 2]: http://www.zuidaima.com/share/search.htm?key=%E5%A2%9E%E5%88%A0%E6%94%B9%E6%9F%A5
[CRUD]: http://www.zuidaima.com/share/search.htm?key=CRUD
[java]: http://www.zuidaima.com/share/search.htm?key=java
[Link 3]: http://www.zuidaima.com/share/topic.htm?topic=%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9B%B8%E5%85%B3
[Link 4]: http://www.zuidaima.com/share/topic.htm?topic=%E5%85%A5%E9%97%A8%E6%95%99%E7%A8%8B
[Web]: http://www.zuidaima.com/share/topic.htm?topic=Web%E5%BC%80%E5%8F%91