JDBC接続データベース構成

詳細

jdbc:sqlserver://localhost:1433;
databaseName=stufeedb;
integratedSecurity=true;
user=sa;
password=svse;

 

package com.singlee.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class DBHelper {
	public static Connection conn = null;

	/**
	 *                      ， JDBC             
	 */
	public DBHelper() {

		Properties pro = new Properties();
		try {
			//       
			pro.load(DBHelper.class
					.getResourceAsStream("jdbc_sqlserver.properties"));
			String Driver = pro.getProperty("Driver");
			String url = pro.getProperty("url");
			String user = pro.getProperty("user");
			String password = pro.getProperty("password");
			//     
			Class.forName(Driver);
			//     
			conn = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 *     ，    
	 */
	public static void close() {
		try {
			if (conn != null) {
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 *        
	 * 
	 * @return
	 */
	public static Connection getConn() {
		new DBHelper();
		return conn;

	}
}

 

package com.singlee.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class DBConnTest {

	public static void main(String[] args) {
		sybaseConnTest();

	}

	/**
	 * Sybase       
	 */
	public static void sybaseConnTest(){
		 try {
	            Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();
	            String url = "jdbc:sybase:Tds:127.0.0.1:5000/yxt";//     
	            Properties sysProps = System.getProperties();
	            sysProps.put("user", "sa"); //           
	            sysProps.put("password", ""); //   
	            Connection conn = DriverManager.getConnection(url, sysProps);
	            Statement stmt = conn
	                    .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
	                            ResultSet.CONCUR_UPDATABLE);
	            String sql = "select userid,username from tb_user"; //  
	            ResultSet rs = stmt.executeQuery(sql);
	            while (rs.next()) {
	                System.out.println("userid:"+rs.getString(1)+",username:"+rs.getString(2)); //        
	            }
	        } catch (Exception e) {
	        	e.printStackTrace();
	            System.out.println("sybaseConnTest Exception:"+e.getMessage());
	        }
	}
}

 

jconn3.jar (446 KB)

ダウンロード回数:0