jdbctest.java

来自「java开发中的 数据分页」· Java 代码 · 共 54 行

package com.jgxy.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.junit.Test;

import com.jgxy.bean.Msgboard;
import com.jgxy.dao.MsgboardDAO;
import com.jgxy.util.DBUtil;


public class JDBCTest {
	
	@Test
	public  void testGetConn(){
		Connection conn=DBUtil.getConnection();
	}
	
	@Test
	public void testGetPreparedStatement(){
		Connection conn=DBUtil.getConnection();
		String sql="select * from msgboard limit ?,?";
		PreparedStatement pstmt=DBUtil.getPreparedStatement(conn, sql);
	
		try{
			pstmt.setInt(1, 2);
			pstmt.setInt(2, 3);
			ResultSet rs=pstmt.executeQuery();
			while (rs.next()){
				System.out.println("*******count "+rs.getString("subject"));
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	
	@Test
	public void testSave(){
		Msgboard m=new Msgboard();
		m.setSubject("AA");
		m.setQuestion("AAAAA");
		m.setQuestioner("ABC");
		MsgboardDAO mdao=new MsgboardDAO();
		mdao.save(m);
	}
	
	
	

}