java Á¬½ÓmysqlµÄÎÊÌâ,Çó½â.
ÏÂÔØµ½mysql-connector-java-5.1.12-bin.jarºó·ÅÔÚDÅÌ,ÔÚ»·¾³±äÁ¿ÀïÌí¼ÓÁËclasspath="D:\Program Files\Java\jdk1.6.0_19\lib",»¹ÊdzöÏÖClassNotFoundExceptionÒì³£,´úÂëºÍÒì³£ÈçÏÂ:
import java.sql.*;
import java.util.Vector;
public class test
{
public static void main (String[] args)
{
Vector<String> results = new Vector<String>();
Connection con = null;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","5647382910");
try{
Statement st = con.createStatement();
ResultSet rs = (ResultSet) st.executeQuery("SELECT * from staff");
while (rs.next()) {
String numb = rs.getString("name");
results.addElement(numb); }
st.close();
con.close();
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
ÔËÐ
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÌâÄ¿£º
ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......
ÒªÇó£º
1¡¢¾ßÓÐ2ÄêÒÔÉϵÄjava¿ª·¢¹¤×÷¾Ñ飬¾«Í¨java£»
2¡¢ÊìϤEclipse¿ª·¢¹¤¾ß£¬ÊìϤWEB¿ª·¢£¬¾ßÓÐÁ½ÄêÒÔÉÏJava¿ª·¢¾Ñ飬կÎÕÃæÏò¶ÔÏóµÄÈí¼þÉè¼Æ·½·¨£¬
ÓÐSpring¡¢HibernateÒÔ¼° ......