Java- Jdbc学习

java jdbc test

 

jsbc:

package cn.honji.sqlserver;

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

import cn.honji.model.UserInfo;

public class UserInfoDao {
    public boolean add(UserInfo model) {

        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            conn = UtilsHelper.getConnection();
            stmt = conn.createStatement();
            String strSql = "insert into UserInfo(username,password,fgroupid) values('"
                    + model.getUserName()
                    + "','"
                    + model.getPassWord()
                    + "',"
                    + model.getfGroupID() + ")";
            int result = stmt.executeUpdate(strSql);
            UtilsHelper.close(conn, stmt, rs);
            if (result > 0) {
                return true;
            } else {
                return false;
            }
        } catch (Exception e) {
            return false;
        }
    }

    public boolean delete(int id) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            String strSql = "delete UserInfo where id=" + id;
            conn = UtilsHelper.getConnection();
            stmt = conn.createStatement();
            int result = stmt.executeUpdate(strSql);
            UtilsHelper.close(conn, stmt, rs);
            if (result > 0) {
                return true;
            } else {
                return false;
            }

        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        }

    }

    public boolean update(UserInfo model) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            conn = UtilsHelper.getConnection();
            stmt = conn.createStatement();

            String strSql = "update UserInfo set UserName='"
                    + model.getUserName() + "',PassWord='"
                    + model.getPassWord() + "',FGroupId=" + model.getfGroupID()
                    + " where id = " + model.getId() + "";
            int result = stmt.executeUpdate(strSql);
            UtilsHelper.close(conn, stmt, rs);
            if (result > 0) {
                return true;
            } else {
                return false;
            }
        } catch (Exception e) {
            return false;
        }

    }
}

 

 

untilhelper

package cn.honji.sqlserver;
import java.sql.*;

public class UtilsHelper {

    public static Connection getConnection() {
        
        String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=Trade"; // 连接服务器和数据库sample
        String userName = "sa"; // 默认用户名
        String userPwd = "123456"; // 密码

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        } catch (ClassNotFoundException e1) {
            e1.printStackTrace();
        }
        try {
            return DriverManager.getConnection(dbURL, userName, userPwd);
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }

    public static void close(Connection conn, Statement stmt, ResultSet rs) {
        if (null != rs)
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        if (null != stmt)
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        if (null != conn)
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
    }
}