JDBC

package cn.jason.test;

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

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

public class TestJunit {

/* public static void main(String[] args){
           System.out.println("aa");
 }
 @Test
 public void testJunit(){
          System.out.println("hello Junit");
 }
 @Before
 public void testBefore(){
          System.out.println("before!");
 }
 @After
 public void testAfter(){
          System.out.println("after!");
 }
 */
 
 
// @Test
 public void f2() throws Exception{       //init开头的错误表示，初始化错误
           //注册驱动
          Class.forName("com.mysql.jdbc.Driver");
           //获取链接
           Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day07", "root", "123");
           //编写sql
           String sql = "select *from category";
           //创建语句执行者
           PreparedStatement st=conn.prepareStatement(sql);
           //设置参数
  
           //执行SQL
           ResultSet rs = st.executeQuery();
           //处理结果
           while(rs.next()){
            System.out.println(rs.getString("cid")+"::"+rs.getString("cname"));
  }
           //释放资源.先打开的后关闭
           rs.close();
           st.close();
           conn.close();
 }
 //插入一条数据
 @Test
 public void f3(){
           Connection conn = null;
           ResultSet rs = null;
           PreparedStatement st =null;
  
           try{
                     //获取连接
                     conn=JdbcUtils.getConnection();
                     //编写sql
                     String sql = "insert into category values(?,?)";
                     //获取语句执行者
                     st=conn.prepareStatement(sql);
                     //设置参数
                     st.setString(1,"c005");
                     st.setString(2,"户外");
                     //执行sql
                     int i=st.executeUpdate();
                     //处理结果
                     if(i==1){
                               System.out.println("success");
                     }else{
                               System.out.println("fail");
                     }
                    }catch(Exception e){
                     e.printStackTrace();
                    }finally{
                              //释放资源
                              JdbcUtils.closeResource(conn,st,rs);
  }
 }
 
}