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
Ïà¹ØÎĵµ£º
ʹÓõ÷ÊÔģʽ¼´¿É¡£
½øTOMCATµÄmanager¿ØÖÆÌ¨£¬¿ÉÒÔ¶ÔÖ¸¶¨µÄÐéÄâĿ¼½øÐпØÖÆ£¨¼ÓÔØ£¬ÖØÔØ£¬Ð¶ÔØ£©£¬±ÈÖØÆô¿ìµÄ¶à£¬ÔÚTOMCATµÄĬÈÏÊ×Ò³ÉÏÓÐÁ´½Ó¡£
============================================================================================
ÎÒÃÇÔÚ¿ª·¢µÄ¹ý³Ì¾³£ÐèÒªµ÷ÊÔ£¬Ò²³£³£ÐèÒªÐÞ¸ÄʹÓõÄÀàºÍservlet£¬Èç¹û ......
1£©&£ºÓëÔËË㣬½«Á½¸öÊý·Ö±ðת»¯³É²¹Â룬Ȼºó½øÐÐÔËË㣨ȫ1µÃ1£¬ÓÐ0³ö0£©¡£
2£©£¡£º·ÇÔËË㣬½«Êý×Ö×ÔÉíÈ¡·´£¨×ª»¯³É²¹Â룬°´Î»È¡·´——1±ä0£¬0±ä1£©¡£
3£©<<£º×óÒÆÔËËã·û£¬½«Ä³¸öÊ®½øÖÆ×ª»»³É¶þ½øÖÆÖ®ºóĩβµÄn¸ö¶þ½øÖÆÊýÒÔ´ËÍù×óÒÆ¶¯£¬Òç³öµÄnλÓÃ0ÔÚĩβ²¹×ã¡£
4£©>>£º´ø·ûºÅÓÒÒÆÔË ......
Kagula
2009-11-17
¹Ø¼ü´Ê
Java My SQL
¸ÅÒª£º
¶ÔMy SQL²Ù×÷·â×°µÄJavaÔ´ÂëʾÀý¡£
ÒªÇó»·¾³£º
J2SE1.5 + Eclipse3.4.2
ÕýÎÄ£º
Ïȵ½ÍøÉÏÏÂÔØmysql-connector-java-5.0.8-bin.jar£¬²¢°ÑËü·Åµ½ÄãµÄJava ProjectµÄUser Lib ......
ÏÂÃæÊÇÎÒÈÏΪÕýÈ·µÄ×ö·¨£¨½áºÏ×Ô¼ºµÄ¾ÑéдµÄ£¬Èç¹û²»ÕýÈ·£¬Çë´ó¼ÒÖ¸Õý£©£º
ÎҵĻæÍ¼¿Ø¼þÊÇJPanel£¬
³öÏÖ¹ö¶¯ÌõµÄǰÌᣬ±ØÐëÈûæÍ¼¿Ø¼þ·ÅÔÚJScrollPaneÉÏ£¬
¶ÔÓÚJScrollPaneµÄLayout£¬Ã»ÓÐÌØÊâÒªÇó£¬ÏÂÃæÕâÑù¼´¿É£º
jScrollPane1.setViewportView(jPanel1);
È»ºó£¬ÁíÍâά³ÖÒ»¸öBufferedImage£¨¼ÙÉè½Ðimage1£©£¬¸÷ÖÖÍ¼Ï ......
FlexÖÐXMLSocketÓëJavaÖÐSocketͨÐÅ£¬Óöµ½µÄÎÊÌâÊÇ£¬JavaÖеÄsocketÄܹ»½ÓÊܵ½XMLSocket´«ÊäµÄÊý¾Ý£¬µ«ÊÇFlex²¢²»ÄܽÓÊܵ½´ÓJava·þÎñÆ÷´«ÊäµÄÊý¾Ý£¬´ÓÍøÉÏËÑÁ˺öà×ÊÁÏ£¬ÖÕÓÚÕÒµ½ÁËÔÒò£¬ÔÀ´XMLSocket ½ÓÊÕµ½·þÎñ¶ËÏ·¢µÄÊý¾Ýʱ£¬½«Á¬Ðø·ÅÓÚ½ÓÊÕ»º³åÇø£¬Ö±µ½½ÓÊÕµ½ "\0" ×Ö½Ú£¨×Ö½ÚÄÚÈÝΪ ASCII Öµ 0£©£¬²ÅÈÏΪ½ÓÊÕÍê³É£¬² ......