jdbc insert方法示例

最新推荐文章于 2024-10-05 21:34:09 发布

MAO_JIN_DAO

最新推荐文章于 2024-10-05 21:34:09 发布

阅读量887

点赞数

分类专栏： sql Java 文章标签： jdbc

本文链接：https://blog.csdn.net/MAO_JIN_DAO/article/details/52629419

版权

Java 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

sql

3 篇文章 0 订阅

订阅专栏

insert操作在initStore方法里。

stmt = con.createStatement();
String sql = "insert into store (id) value (" + "'"+i+"')";;
stmt.executeUpdate(sql);

这里是jdbc的文档

</pre><pre name="code" class="java"><pre name="code" class="java">package pro1;

import java.sql.*;

public class Gradation
{

	private static final String PreparedStatement = null;

	/**
	 * @param args
	 */
	public static void main(String[] args)
	{
		Gradation g = new Gradation();
		g.getCon();
		g.initStore();
		g.showInfo();
	}

	static Connection con;
	static Statement stmt;
	static ResultSet res;

	public void getCon(){
		con = ConnectionClass.getConnection();
	}
	public void showInfo()
	{
		try
		{
			stmt = con.createStatement();
			res = stmt.executeQuery("select * from store");
			while (res.next())
			{
				String id = res.getString("id");
				String pwd = res.getString("pwd");
				String isStore = res.getString("isStore");
				System.out.println(id + "  " + pwd + "   " + isStore);
			}
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void initStore()
	{
		try
		{
			for(int i=1;i<=15;i++)
			{
				stmt = con.createStatement();
				String sql = "insert into store (id) value (" + "'"+i+"')";;
				stmt.executeUpdate(sql);
			}
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}