JAVA JDBC·ÃÎÊÊý¾Ý¿â±ê×¼´úÂë
package edu.zzu.jdbc.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.ambow.jdbc.entity.Student;
public class TestDBConn{
public static void main(String args[]){
String url="jdbc:sqlserver://localhost:1433;databaseName=zzu";
String username="sa";
String password="123456";
Connection conn =null;
Statement stmt =null;
ResultSet rs =null;
try {
//1¡¢¼ÓÔØÇý¶¯
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//2¡¢Í¨¹ýDriverManagee»ñÈ¡Á¬½Ó°üÀ¨(Êý¾Ý¿âÁ¬½Ó×Ö·û´®,Óû§Ãû,ÃÜÂë)
conn = DriverManager.getConnection(url, username, password);
//3¡¢Í¨¹ý Connection ¶ÔÏóÀ´´´½¨ createStatement
stmt = conn.createStatement();
//4¡¢×Ô¶¨Òå SQL Óï¾ä
// String sql = " select * from student ";
String sql = "insert into student values (?,?,?) ";
//5¡¢Í¨¹ý statement ¶ÔÏóÀ´Ö´ÐÐ SQL Óï¾ä£¬²¢ÇÒ·µ»Ø½á¹û¸ø ResultSet
rs =stmt.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getInt("id")+" ");
System.out.print(rs.getString("name")+" ");
System.out.println(rs.getString("password"));
}
} catch (Exception e) {
e.printStackTrace();
} finally{
try{
if(conn!=null){
conn.close();
conn=null;
}
if(stmt!=null){
stmt.close();
stmt=null;
&n
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
String : ×Ö·û´®ÀàÐÍ
Ò»¡¢¹¹Ô캯Êý
String(byte[ ] bytes)£ºÍ¨¹ýbyteÊý×é¹¹Ôì×Ö·û´®¶ÔÏó¡£
String(char[ ] value)£ºÍ¨¹ýcharÊý×é¹¹Ôì×Ö·û´®¶ÔÏó¡£
String(Sting original)£º¹¹ÔìÒ»¸öoriginalµÄ¸±±¾¡£¼´£º¿½±´Ò»¸öoriginal¡£
String(StringBuffer buffer)£ºÍ¨¹ýStringBufferÊý×é¹¹Ôì×Ö·û´®¶ÔÏó¡£
ÀýÈ磺
byte[] b = ......
//¼òµ¥µÄjavaÈÕÆÚ¸ñʽ¿ØÖÆ
java.Text.SimpleDateFormat format = new java.Text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss");//ÄãÏëÒªµÄ¸ñʽ
//×¢ÒâÔµÄλÖÃÒª´óдµÄMM Òª²»¾Í¿´µ½µÄ²»ÊÇÕýÈ·ÏÔʾ£¬¿ÉÒÔ°ÑÄãÏëҪת»»µÄÈÕÆÚת»»ÎªÏàÓ¦µÄ¸ñʽ°¡
format.format(new java.util.Date());//dateΪÈÕÆÚÐÍÊý¾Ý£¬¿ÉÒÔÈÎÒ ......
ÔÚ
Java SE1.5
ÖУ¬
Ôö¼ÓÁËÒ»¸öеÄÌØÐÔ£º·ºÐÍ£¨ÈÕ±¾ÓïÖеÄ×ܳÆÐÍ£©¡£ºÎν·ºÐÍÄØ£¿Í¨Ë×µÄ˵£¬¾ÍÊÇ·º·ºµÄÖ¸¶¨¶ÔÏóËù²Ù×÷µÄÀàÐÍ£¬¶ø²»Ïñ³£¹æ·½Ê½Ò»ÑùʹÓÃijÖ̶ֹ¨µÄÀàÐÍÈ¥Ö¸¶¨¡£
·ºÐ͵ı¾ÖʾÍÊǽ«Ëù²Ù×÷µÄÊý¾ÝÀàÐͲÎÊý»¯£¬Ò²¾ÍÊÇ˵£¬¸ÃÊý¾ÝÀàÐͱ»Ö¸¶¨ÎªÒ»¸ö²ÎÊý¡£ÕâÖÖ²ÎÊýÀàÐÍ¿ÉÒÔʹÓÃÔÚÀà¡¢½Ó¿ÚÒÔ¼°·½·¨¶¨ÒåÖС£
......
ÎÊÌâÓò:
--ϵͳÖÐÄãÐèÒª»ñµÃij¸öÀàµÄΨһʵÀý£¬ËùÓпͻ§¶Ë¶ÔËüµÄ·ÃÎʶ¼½«Í¨¹ýÒ»¸ö¹«¹²µÄ·ÃÎʵã»ñµÃ
--´´½¨Ò»¸öÀಢʹÆä£º(A)¶¨ÒåÒ»¸ö˽ÓеĹ¹ÔìÆ÷£¨B£©¶¨ÒåÒ»¸ö˽ÓС¢¾²Ì¬µÄ±äÁ¿Ö¸Ïò×Ô¼º£¨C£©¶¨ÒåÒ»¸ö¹«ÓС¢¾²Ì¬µÄ·ÃÎÊ·½·¨ÓÃÓÚ·µ»Ø¸ÃÀàµÄÒ»¸öΨһʵÀý
·ÖΪ ¶öººÊ½ ºÍ ÀÁººÊ½,ÏÂÃæÊÇÒ»¸ö¼òµ¥µÄʾÀý´úÂ룬Ӧ¸Ã ......