flexͨ¹ýblazedsÓëjavaʵÏÖÔöɾ¸Ä²é
ÓõÄÊÇMySQLÊý¾Ý¿â¡£
1£¬½¨Ò»¸öuserdb¿â£¬ÔÙ½¨userinfo±í£¬×ֶΣºid(int),username(varchar),password(varchar)¡£
create database userdb;
use userdb;
create table userinfo(
id int(10) not null auto_increment,
username varchar(20),
password varchar(20),
primary key(id));
2£¬DBConnection.java
package com.datainfo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
public static Connection getConnection() throws ClassNotFoundException,
SQLException {
Connection conn = null;
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/userdb";
String username = "root";
String password = "mysql";
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
return conn;
}
}
3£¬User.java
package com.datainfo;
public class User {
private int id;
private String username;
private String password;
public User() {
}
/**
* @return the id
*/
public int getId() {
return id;
}
/**
* @param id
* the id to set
*/
public void setId(int id) {
this.id = id;
}
/**
* @return the username
*/
public String getUsername() {
return username;
}
/**
* @param username
* the username to set
*/
public void setUsername(String username) {
this.username = username;
}
/**
* @return the password
*/
public String getPassword() {
return password;
}
/**
* @param password
* the password to set
*/
public void setPassword(String password) {
this.password = password;
}
}
4£¬UserDAO.java
package com.datainfo;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import com.datainfo.DBConnection;
public class UserDAO {
public ArrayList getUserList() throws ClassNotFoundExcep
Ïà¹ØÎĵµ£º
javaÖÐʹÓÃscoketÄ£Äâhttp postÇëÇó·¢ËÍͼƬ»òÎļþ
×î½üÓöµ½¸öÎÊÌ⣬Á½¸öϵͳ¹²ÓÃÓû§µÄÍ·Ïñ£¬Óû§µÄÍ·ÏñÔÚÒ»¸öϵͳÖб£´æ£¬Õâ¾ÍÉæ¼°µ½½«Í¼Æ¬Í¨¹ýscoket·¢Ë͸øÁíÒ»¸öϵͳ´æ´¢µÄÎÊÌ⣬×î³õµÄ˼·Êǽ«Í¼Æ¬¶Á³Ébyte[]Êý×飬Ȼºó·¢ËÍ£¬µ«ÓÖ·¢ÏÖ£¬·¢ËÍͼƬµÄͬʱ»¹Òª·¢ËÍÃÜÔ¿¡¢uid¡¢usernameµÈÐÅÏ¢£¬ºÃͨ¹ý¶Ô·½ÏµÍ³µÄÑéÖ¤£¬Õâ¾Í ......
ÔÚjava´úÂëÖо³£ÓжÁÈ¡Íⲿ×ÊÔ´µÄÒªÇó:ÈçÅäÖÃÎļþµÈµÈ,ͨ³£»á°ÑÅäÖÃÎļþ·ÅÔÚclasspathÏ»òÕßÔÚwebÏîÄ¿ÖзÅÔÚweb-infÏÂ.
1.´Óµ±Ç°µÄ¹¤×÷Ŀ¼ÖжÁÈ¡:
try {
BufferedReader in = new BufferedReader(new InputStreamRea ......
Ñ¡ÔñjavaºóµÄÄÇЩÊÂ…
ÕâÁ½ÌìѧУ¿ªÊ¼ÈÃÎÒÃÇÕâÒ»´óÅú¸ß·ÑÉúÑ¡Ôñ×Ô¼ºµÄרҵ·½Ïò£¬FocuserÎÒ¾¹ýºÃ¼¸¸öÄêÍ·µÄ˼¿¼£¬²¢ÇÒÔÚÎÒÃÇÇ×°®c#ÀÏʦÈÈÇéµÄÏòÎÒÃǽéÉÜ.netµÄÇ°¾°ºó£¬ÒãÈ»¼á¶¨µÄÑ¡ÔñÁËjavaÕâÌõ×Ô¼ºÈÏΪǰ³ÌËƽõµÄµÀ·¡£ÒÔϵÄÕâЩÍøÕ¾ÊÇÎÒƽʱ¾³£·ÃÎʵÄһЩ¹úÍâµÄÓ¢ÎÄjavaÍøÕ¾£¬½ñÌìÌصصķ¢²¼¸ø´ó¼Ò£¬Ï£ÍûÎÒÃÇÄ ......