eclipseJDBC

首先在eclipse下配置环境为如下

配置jar如下图

代码如下

package cn.java.connect;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Time;
/**
 * 关于java连接mysql使用jdbc的一些应用.
 * @author hello
 *
 */
public class Mysql_jdbc {
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			try {
				Connection co=DriverManager.getConnection("jdbc:mysql://localhost:3306/two","root","123456");
				String sql="insert into test(id,name,age,date,time) values(?,?,?,?,?)";
				PreparedStatement ps=co.prepareStatement(sql);
				Date da=new Date(System.currentTimeMillis());
				Time ti =new Time(System.currentTimeMillis());
				ps.setString(1,"123459");
				ps.setString(2, "张兰");
				ps.setString(3, "21");
				ps.setDate(4,da);
				ps.setTime(5, ti);
				ps.execute();
				/**
				 * 以上的代码可以有以下的变形
				 * ps.setObject(1,"123456");
				 * ps.setObject(2,"李四");
				 * ps.setObject(3,"18");
				 */
				System.out.println("插入完成");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

下面是连接sql server的代码

package cn.sqlserver.java;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MainJava {
     public static void main(String[] args) {
    	 Connection con=null;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			try {
				con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;Databasename=test","sa","123456");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			System.out.println("连接成功");
		} catch (ClassNotFoundException e) {
			
			e.printStackTrace();
		}
	}
}

下面是连接Mongodb的代码

 package cn.mongo.java;
	import com.mongodb.MongoClient;
	import com.mongodb.MongoException;
	import com.mongodb.WriteConcern;
	import com.mongodb.DB;
	import com.mongodb.DBCollection;
	import com.mongodb.BasicDBObject;
	import com.mongodb.DBObject;
	import com.mongodb.DBCursor;
	import com.mongodb.ServerAddress;
	import java.util.Arrays;

	public class MongoDBJDBC{
	   public static void main( String args[] ){
	      try{   
			 // 连接到 mongodb 服务
	         MongoClient mongoClient = new MongoClient( "localhost" , 27017 );
	         // 连接到数据库
	         DB db = mongoClient.getDB( "test" );
			 System.out.println("Connect to database successfully");
	      }catch(Exception e){
		     System.err.println( e.getClass().getName() + ": " + e.getMessage() );
		  }
	   }
	}

挺基础的,刚开始学习java和数据库.